Design and maintain the Microsoft Fabric Bronze-Silver-Gold medallion architecture
Build ingestion pipelines from pharmacy claims, eligibility, formulary and reference APIs
Normalize and conform data across differing PBM file specs and claims layouts
Design and evolve the conformed data model and star schema
Set coding and design standards, run code reviews, and mentor engineers
From the employer’s posting
Own the design, build, and ongoing maintenance of our Microsoft Fabric medallion architecture (Bronze → Silver → Gold)
Develop and operate ingestion pipelines from multiple sources — pharmacy claims, eligibility, formulary, contract data, rebate and actuarial data, and public reference APIs
Normalize and conform data across differing PBM file specifications, formularies, and claims layouts
Design and evolve the conformed data model and star schema that serve as the analytical source of truth
setting coding and design standards, running code reviews, and unblocking day-to-day work
comparable experience with Azure Synapse, Databricks, or similar platforms will be considered.
Serve the business Ensure the platform reliably feeds downstream consumers: Power BI, Excel reporting, internal web applications, and AI/Copilot-ready data services.
Posting Description 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: https://www.NFP.com. 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: 7+ years in data engineering, including 2+ years leading, mentoring, or acting as tech lead for other engineers. Deep experience building lakehouse / medallion architectures. Microsoft Fabric strongly preferred; comparable experience with Azure Synapse, Databricks, or similar platforms will be considered. Strong SQL and hands-on proficiency in Python and/or PySpark for large-scale data transformation. Dimensional modeling expertise — you can design and maintain star schemas that hold up as reporting needs grow. BI analytics fluency, including an understanding of the semantic/serving layer that makes BI performant and trustworthy. A track record of taming messy data — ingesting and conforming heterogeneous sources and file formats into clean, reliable models. Solid engineering fundamentals — data governance, data quality frameworks, and CI/CD for data pipelines. Strong communication skills — able to explain technical tradeoffs to non-technical stakeholders and collaborate across teams. Preferred Qualifications Experience with pharmacy, PBM, healthcare claims, or payer data. Familiarity with pharmacy data standards (NCPDP, claims file layouts) and healthcare reference data. Experience enabling AI/Copilot or MCP-based data access on top of a data platform. Broader Azure ecosystem experience (Azure SQL, data pipelines, security/RBAC, cost management). Experience standing up a data platform or engineering function in an early or growth-stage environment. What We Offer: We're proud to offer a competitive salary, PTO & paid holidays, 401(k) with match, exclusive discount programs, health & wellness programs, and more. Our PeopleFirst culture focuses on building and nurturing lifelong relationships with our employees because, ultimately, we exist to be there for others. The base salary range for this position is $135,000 – $150,000. The base salary offered will be determined by factors including, but not limited to, experience, credentials, education, certifications, skill level required for the position, the scope of the position, and geographic location. Actual base salary offered will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives. NFP and You... Better Together! NFP is an inclusive Equal Employment Opportunity employer. 2588638
About NFP
People
About 60,000 in 2025, about the same as the year before.Annual report (SEC Form 10-K)
Company
Listed as AON.
Demand for Data Leadership roles
New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Leadership, by the work the posting describes.
Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.
Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.
Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.
US government figures for computer and information systems managers
Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs
The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.