A

Aon

Global risk, retirement, health solutions provider

Manager of Data Engineering

Engineering LeadershipConfirmed live in the last 24 hours
Full-timeChesterfield, MO, USAIn-person

About the Job

Requirements

  • At least 7 years of data engineering experience, including at least 2 years leading, mentoring, or acting as a technical lead for other engineers.
  • Deep experience building lakehouse or medallion architectures; Microsoft Fabric is strongly preferred, while comparable experience with Azure Synapse, Databricks, or similar platforms is acceptable.
  • Strong SQL skills and hands-on proficiency in Python and/or PySpark for large-scale data transformation.
  • Expertise in dimensional modeling, including designing and maintaining star schemas that support growing reporting needs.
  • Business intelligence analytics fluency, including understanding the semantic and serving layers that make business intelligence performant and trustworthy.
  • A track record of ingesting heterogeneous data sources and file formats and conforming them into clean, reliable models.
  • Strong engineering fundamentals in data governance, data quality frameworks, and continuous integration and continuous delivery for data pipelines.
  • Ability to explain technical tradeoffs to non-technical stakeholders and collaborate across teams.

Responsibilities

  • Own the design, build, and ongoing maintenance of the Microsoft Fabric medallion architecture (Bronze, Silver, and Gold), ensuring data flows from raw ingestion through conformed, analytics-ready models.
  • Make and document architectural decisions around ingestion patterns, storage, the serving layer, orchestration, and performance while balancing speed, reliability, and cost.
  • Establish engineering practices for platform health and scale, including version control, testing, continuous integration and delivery, monitoring, and documentation.
  • Guide a small team of data engineers by setting coding and design standards, conducting code reviews, and unblocking day-to-day work.
  • Mentor engineers and help develop their technical skills, giving the team clear standards for quality.
  • Help shape hiring and team structure as the function grows.
  • Develop and operate ingestion pipelines from pharmacy claims, eligibility, formulary, contract, rebate, and actuarial data, and public reference application programming interfaces such as NADAC, NCPDP, CMS, and 340B.
  • Normalize and conform data across differing pharmacy benefit manager file specifications, formularies, and claims layouts so downstream models are consistent and trustworthy.
  • Design and evolve the conformed data model and star schema that serve as the analytical source of truth.
  • Ensure the platform reliably feeds downstream consumers, including Power BI, Excel reporting, internal web applications, and AI/Copilot-ready data services.
  • Serve as a point of contact for complex reporting and data issues, guiding resolution across reporting and data teams.
  • Own data quality, governance, lineage, performance, and cost optimization end to end.
  • Partner with the platform architect, analytics, clinical, and product teams to align the technical roadmap with business and client priorities and translate ambiguous requirements into concrete data solutions.
  • Collaborate with cross-functional leaders to prioritize initiatives and allocate resources.

Desired Qualifications

  • Experience with pharmacy, pharmacy benefit manager, healthcare claims, or payer data.
  • Familiarity with pharmacy data standards, including NCPDP, claims file layouts, and healthcare reference data.
  • Experience enabling AI/Copilot or model context protocol-based data access on a data platform.
  • Broader Azure ecosystem experience, including Azure SQL, data pipelines, security and role-based access control, and cost management.
  • Experience establishing a data platform or engineering function in an early-stage or growth-stage environment.
  • Microsoft Fabric experience is strongly preferred; comparable experience with Azure Synapse, Databricks, or similar platforms will be considered.

About the Company

Aon

Global risk, retirement, health solutions provider

Aon provides risk management, retirement, and health solutions to businesses, governments, and individuals by offering consulting, brokerage, and software. It uses data and analytics to tailor insights across risk assessment, benefits design, and workforce optimization. Its global, diversified service mix and data-driven approach allow it to deliver more integrated risk, retirement, and health solutions than firms focusing on a single area. Its goal is to shape decisions for the better and protect and enrich lives worldwide.

Company size
10,001+
Company stage
IPO
Headquarters
London, United Kingdom
Founded
1919

Recently Posted Jobs

Explore more opportunities at Aon

See more jobs