Manager of Data Engineering

Who We Are:

NFP, an Aon company, is a multiple Best Places to Work award winner in Business Insurance who has also earned the WORK180 employer endorsement. We are an organization of consultative advisors and problem solvers. We help companies and individuals around the globe address their most significant risk, workforce, wealth management and retirement challenges through custom solutions and a people-first approach. To learn more, please visit: .

Principal Duties and Responsibilities / Essential Functions:

Lead the platform architecture and build

• Own the design, build, and ongoing maintenance of our Microsoft Fabric medallion architecture (Bronze → Silver → Gold), ensuring data flows optimally from raw ingestion through conformed, analytics-ready models.
• Make and document key architectural decisions around ingestion patterns, storage, the serving layer, orchestration, and performance — balancing speed, reliability, and cost.
• Establish the engineering practices that keep the platform healthy as it scales: version control, testing, CI/CD, monitoring, and documentation.

Lead and grow the team

• Guide a small team of data engineers — setting coding and design standards, running code reviews, and unblocking day-to-day work.
• Mentor engineers and help grow their technical skills, giving the team a clear sense of how “good” is defined.
• Help shape hiring and team structure as the function grows.

Build and maintain the data pipelines

• Develop and operate ingestion pipelines from multiple sources — pharmacy claims, eligibility, formulary, contract data, rebate and actuarial data, and public reference APIs (e.g., NADAC, NCPDP, CMS, 340B).
• Normalize and conform data across differing PBM file specifications, formularies, and claims layouts so that downstream models are consistent and trustworthy.
• Design and evolve the conformed data model and star schema that serve as the analytical source of truth.

Serve the business

• Ensure the platform reliably feeds downstream consumers: Power BI, Excel reporting, internal web applications, and AI/Copilot-ready data services.
• Serve as a point for complex reporting and data issues, guiding to 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

Minimum Requirements for Education, Experience, and Certifications/Licenses: