About Milliman
Milliman is among the world's largest providers of actuarial and related products and services. The firm has consulting practices in healthcare, property & casualty insurance, life insurance and financial services, and employee benefits. Founded in 1947, Milliman is an independent firm with offices in major cities around the globe.
Role Summary
The Data Engineer will support data ingestion, transformation, profiling, documentation, and Microsoft Fabric environment operations for a data and actuarial discovery sandbox. This role will work closely with senior data engineering, actuarial, product, IT, and security teams to help build reliable data pipelines, maintain Lakehouse tables, validate data quality, and support controlled access to curated datasets.
Key Responsibilities
- Support ingestion of sample source data from cloud storage into Microsoft Fabric using ADF pipelines, OneLake landing folders, and Lakehouse tables.
- Assist with the creation and maintenance of bronze, silver, and gold tables based on the agreed discovery data model.
- Build and run data profiling scripts and notebooks to identify file structures, schemas, row counts, null rates, duplicate records, timestamp ranges, and field-level quality issues.
- Help standardize common source data fields such as entity identifiers, transaction or event IDs, timestamps, event types, measurement units, and geography fields.
- Support data transformation work required to prepare daily summary, event-summary, exposure, behavioral, and contextual feature datasets.
- Document source tables, transformations, assumptions, data quality findings, known limitations, and operational procedures for actuarial users.
- Support ad hoc data requests from the actuarial team during discovery and help refine datasets based on feedback.
- Assist with Microsoft Fabric workspace setup, Lakehouse configuration, pipeline permissions, access controls, and environment support.
- Help configure and validate secure connections between Microsoft Fabric and external cloud platforms, including authentication handling, service account/key usage, and privileged access management considerations.
- Monitor pipeline runs, ingestion failures, storage usage, compute activity, and basic cost/performance indicators during the discovery build.
- Provide crossover support to the product build effort, including Fabric configuration, Lakehouse setup, Power BI access support, and troubleshooting with IT/security teams.
Required Skills and Experience
- Foundational experience in data engineering, data pipelines, ETL/ELT, data transformation, or cloud data platforms.
- Working knowledge of SQL and Python; exposure to Spark, notebooks, or distributed data processing is preferred.
- Basic understanding of data modeling, data quality checks, schema validation, and table maintenance.
- Familiarity with Microsoft Azure, Microsoft Fabric, ADF pipelines, OneLake, Lakehouse tables, or similar cloud data services.
- Ability to analyze source data, identify quality issues, and document findings clearly for technical and non-technical audiences.
- Strong attention to detail, willingness to learn, and ability to work collaboratively with senior engineers and actuarial stakeholders.
Preferred Qualifications
- Exposure to insurance, actuarial, mobility, operational, or risk analytics data.
- Experience working with GCP, Azure, Power BI, or cloud-to-cloud data ingestion patterns.
- Understanding of access controls, workspace permissions, data retention, and secure data handling practices.
- Experience using Git, Azure DevOps, or similar tools for version control, task tracking, and documentation.
Skills Required
- Foundational experience in data engineering, data pipelines, ETL/ELT, data transformation, or cloud data platforms
- Working knowledge of SQL
- Working knowledge of Python
- Exposure to Spark, notebooks, or distributed data processing
- Basic understanding of data modeling, data quality checks, schema validation, and table maintenance
- Familiarity with Microsoft Azure, Microsoft Fabric, ADF pipelines, OneLake, and Lakehouse tables
- Ability to analyze source data, identify quality issues, and document findings for technical and non-technical audiences
- Strong attention to detail, willingness to learn, and ability to work collaboratively with senior engineers and actuarial stakeholders
- Exposure to insurance, actuarial, mobility, operational, or risk analytics data
- Experience with GCP, Azure, Power BI, or cloud-to-cloud data ingestion patterns
- Understanding of access controls, workspace permissions, data retention, and secure data handling practices
- Experience using Git, Azure DevOps, or similar tools for version control and task tracking
Milliman Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Milliman and has not been reviewed or approved by Milliman.
-
Healthcare Strength — Core coverage includes subsidized medical, dental, and vision, plus company-paid life, AD&D, and disability. Materials highlight robust health protections as part of the standard package.
-
Retirement Support — A 401(k) with matching is paired with profit-sharing contributions described as generous. These features can significantly bolster long-term compensation when contributions are strong.
-
Parental & Family Support — Paid parental leave and family-building support (adoption and fertility) are available alongside caregiver and emotional support resources. These programs extend protection beyond core insurance to meet family needs.
Milliman Insights
What We Do
Milliman is among the world’s largest independent actuarial and consulting firms. Founded in Seattle in 1947, Milliman has offices in key locations worldwide. Through consulting practices in employee benefits, healthcare, investment, life insurance and financial services, and property & casualty/general insurance, Milliman serves the full spectrum of business, financial, government, union, education, and nonprofit organizations. In addition to consulting actuaries, Milliman’s body of professionals includes numerous other specialists, ranging from clinicians to economists.
