Lead Analytics Engineer - Data Modeling & Quality

The role

You will own the SQL and DBT layer that turns raw clinical and claims data into trusted datasets. You will also act as the quality authority for the data those models produce, triaging alerts and owning the data quality ticket queue.

What you will do

• Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver
• Triage and classify data quality alerts, separating source-level issues from transform-layer failures
• Design and maintain volume monitors and DQ monitors
• Author and apply clinical and claims data quality rules across silver and gold layers
• Conduct quality reviews for connector promotions from UAT to PRD
• Own the ticket queue for DQ, attribution, hierarchy, and customer-specific data quality issues
• Optimize SQL performance for slow-running jobs
• Partner with Data Engineering on table design, partition strategy, and incremental patterns
• Coordinate with the Measure Implementation Team when data quality affects quality measure scores
• Contribute to and enforce data modeling standards across teams

Required qualifications

• Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field
• Advanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databases
• DBT: hands-on experience authoring models, tests, macros, and yml documentation
• Working knowledge of claims data (professional, institutional, pharmacy) and clinical data (EHR entities)
• Data quality mindset: differentiating source issues from transform issues and communicating findings clearly
• Clear communicator who can translate technical findings for clients and non-technical stakeholders
• Ability to manage several projects simultaneously
• Desire to learn and apply AI tools for operational efficiency

Nice to have

• Experience with Spark SQL and Hudi table format
• Familiarity with data quality monitoring tools
• Comfort operating in an AI-first environment using Claude
• Exposure to population health concepts: HEDIS measures, risk adjustment, value-based care metrics
• Python scripting for data investigation and automation
• Experience with Argo Workflows or similar orchestration platforms
• Healthcare data standards: ICD-10, CPT, NDC, LOINC, NPI

Benefits

• Work alongside a talented team on complex healthcare data challenges
• Flexible, fully remote work environment with resources and support
• Exposure to senior leaders
• Be on the front lines of AI adoption
• Membership in the Arcadian Community

Before you apply

• Responsible for following all Security policies and procedures to protect PHI and Arcadia intellectual property

About the company

Arcadia helps providers and payers reduce cost and improve patient health by aggregating large amounts of disparate data and making opportunities actionable at the point of care. The company describes itself as a market leader in population health management software.