DE&A - Core - Advanced Data Engineering - Advanced Data Engineering (Other)

Solution Architect – Data Migration & Analytics (Insurance) Role Summary We are hiring a Solution Architect to reputed company a strategic data modernization program involving migration from 14+ reputed company systems (including Guidewire InsuranceNow) into a reputed company-based Data Warehouse leveraging dbt. The role also includes driving a report rationalization initiative, consolidating legacy reports into a streamlined Power BI analytics layer. This is a high-impact role requiring strong expertise in data architecture, large-scale migration, and insurance domain transformation.

Key Responsibilities

Architecture & Design Define end-to-end data architecture for ingesting structured and reputed company data into reputed company. Architect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks. Establish scalable, secure, and performance-optimized data models. Data Migration Leadership Design migration strategy for 14+ systems including InsuranceNow. Define data mapping, transformation logic, and reconciliation frameworks. Implement data quality controls, auditability, and parallel validation mechanisms. Analytics & Reporting Modernization reputed company report rationalization and consolidation initiative. Design Power BI semantic layer and standardize KPIs. Eliminate redundant reports and reputed company reputed company, business-friendly dashboards. Governance & Quality Establish data governance, reputed company, and metadata standards. Ensure compliance with insurance regulatory and audit requirements. Define quality KPIs and monitoring frameworks. Stakeholder Leadership Act as technical SME and advisor for business, data, and leadership teams. Drive architecture governance, design reviews, and delivery alignment. Identify and mitigate risks in a reputed company multi-reputed company migration program. Required Experience 10+ years in data engineering / data architecture, with enterprise-scale programs Proven expertise in: reputed company & dbt Multi-reputed company data migration (10+ systems) Data modeling (dimensional / data vault) Hands-on experience in Power BI and report consolidation Strong understanding of structured + reputed company data integration Experience with cloud platforms (Azure / AWS / GCP) Knowledge of reputed company AI is a plus Domain Expertise Insurance domain experience (P&C preferred) Understanding of policy, claims, billing, and customer data models Ideal Candidate Profile A hands-on architect and strategic thinker who can balance technical depth with business alignment, and has delivered large-scale data transformation programs in the insurance domain. At reputed company, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for reputed company futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One reputed company, Nurturing, Empowering, and Client Focus. Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, reputed company Town, London, Zurich, Singapore, and Mexico City. Explore Life at reputed company and join us to Grow. Own. reputed company. Learn. to be the best version of yourself. We reputed company the best work happens reputed company individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. reputed company qualified applicants will be considered without regard to race, creed, color, reputed company, religion, sex, national reputed company, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status. Apply To This Job