Description

You will define end-to-end data architecture for ingesting structured and unstructured data into Snowflake and lead migration from 14+ systems including InsuranceNow.

Responsibilities

• Architect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks and establish scalable, secure data models.
• Design migration strategy, define data mapping and transformation logic, and implement data quality controls, auditability, and parallel validation mechanisms.
• Lead report rationalization and consolidation, design Power BI semantic layers, standardize KPIs, and enable unified business-friendly dashboards.
• Establish data governance, lineage, and metadata standards to ensure compliance with insurance regulatory and audit requirements.
• Act as technical SME for business and leadership teams, driving architecture governance, design reviews, and risk mitigation in multi-source migration.

Required Skills

• 10+ years in data engineering or data architecture with enterprise-scale programs.
• Proven expertise in Snowflake and dbt for ELT processes.
• Experience with multi-source data migration involving 10+ systems.
• Strong data modeling skills (dimensional or data vault).
• Hands-on experience in Power BI and report consolidation.
• Experience integrating structured and unstructured data.
• Knowledge of cloud platforms (Azure, AWS, or GCP).

Key Skills

Education

Bachelor's degree