Senior Data Engineer

About Milliman:

Independent for over 70 years, Milliman delivers market-leading services and solutions to clients worldwide. Today, we are helping companies take on some of the world’s most critical and complex issues, including retirement funding and healthcare financing, risk management and regulatory compliance, data analytics and business transformation. 

Through a team of professionals ranging from actuaries to clinicians, technology specialists to plan administrators, we offer unparalleled expertise in employee benefits, investment consulting, healthcare, life insurance, and financial services, and property and casualty insurance. 

Role Summary

The Data Architect will lead the design and implementation of data architecture for a Microsoft Fabric-based sandbox environment supporting data and actuarial discovery use cases. This role will define ingestion patterns, Lakehouse structure, data layer strategy, data quality controls, and analytics-ready datasets that enable pricing, underwriting, claims, fraud, and risk segmentation analysis.

Key Responsibilities

• Lead the end-to-end data architecture for the sandbox, including ingestion patterns, Microsoft Fabric Lakehouse structure, bronze, silver, and gold table strategy, and data quality framework.
• Own the technical design and implementation approach for data ingestion into Microsoft Fabric, including pipeline design, file validation, schema handling, partitioning, and incremental load strategy.
• Translate raw and curated source data into analytics-ready datasets, including daily summary, event-summary, exposure, behavioral, and contextual feature tables.
• Define and implement data profiling, reconciliation, and validation outputs such as row counts, file counts, duplicate checks, null analysis, timestamp coverage, identifier stability, and unit validation.
• Partner closely with actuarial teams to understand required features and ensure the data model supports pricing, underwriting, claims, fraud, and risk segmentation analysis.
• Provide technical direction, design guidance, and code review for junior engineers.
• Coordinate with product leadership and IT/security stakeholders on Microsoft Fabric configuration, Lakehouse setup, roadmap decisions, access controls, and environment readiness.
• Establish documentation standards for data models, transformation logic, quality rules, assumptions, limitations, and operational procedures.

Required Skills and Experience

• Strong experience designing and implementing scalable data engineering or data architecture solutions.
• Hands-on experience with Microsoft Fabric, Azure data services, Lakehouse architecture, OneLake, pipelines, notebooks, and modern cloud data platforms.
• Strong understanding of bronze, silver, and gold data layer design, data modeling, data integration, and data quality frameworks.
• Proficiency in SQL, Python, Spark, and data pipeline development.
• Experience with schema management, incremental processing, partitioning, validation, reconciliation, and performance optimization.
• Ability to translate business and actuarial requirements into robust technical data models and feature datasets.
• Strong communication skills with the ability to explain technical concepts to actuarial, product, engineering, and security stakeholders.

Preferred Qualifications

• Experience working with insurance, actuarial, claims, pricing, underwriting, mobility, operational, or risk analytics data.
• Experience integrating data from GCP or other cloud platforms into Azure or Microsoft Fabric environments.
• Familiarity with data governance, access control, security configuration, and compliance-oriented data environments.
• Prior experience mentoring junior engineers or leading technical delivery in a cross-functional product environment.