Description

Define end-to-end data architecture and lead migration of 14+ systems into Snowflake.

This role is on-site.

Responsibilities

• Architect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks.
• Design migration strategy, data mapping, transformation logic, and reconciliation for 14+ systems including InsuranceNow.
• Lead report rationalization, design Power BI semantic layers, and standardize KPIs for unified dashboards.
• Establish data governance, lineage, metadata standards, and compliance with insurance regulatory requirements.
• Act as technical SME for business and leadership teams, driving architecture governance and risk mitigation.

Required Skills

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

Preferred Skills

• Knowledge of Cortex AI.

Key Skills

Education

Bachelor's degree