Back to jobs

Lead Analytics Engineer - Data Modeling & Quality

Pay
USD 160,000–185,000/year — pay source
Salary 160,000 – 185,000 USD per year About Arcadia
Read the full posting
Work setting
Working pattern needs review — work setting source
Arcadia's data platform powers population health analytics for health plans, ACOs, and provider groups across the country. As a Lead Analytics Engineer — Data Modeling & Quality, you sit at the intersection of data quality ownership and analytical data modeling. You'll own the SQL and DBT layer that transforms raw clinical and claims data into trusted, production-grade datasets, while also serving as the quality authority for the data those models produce. This is a hybrid role — deeper SQL and DBT expertise than a traditional Data Health Professional, with a more analytical and model-focused scope than a Data Engineering role. You're less focused on pipeline infrastructure and more on the logic, shape, and trustworthiness of the data itself. What Success Looks Like
Listed location: Remote (USA)
Read the full posting
Employment
Full-time — employment source
Employment type Full-time
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Author, review, and maintain DBT models on Spark/Hudi from ingest through silver

  • Triage and classify data quality alerts, separating source issues from transform failures

  • Design and maintain volume and DQ monitors for null rates and distributions

  • Lead data quality reviews during connector installation and promotion

  • Own the ticket queue for DQ and customer-specific data quality issues

From the employer’s posting
Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver
Triage and classify data quality alerts, distinguishing source-level issues from transform-layer failures
Design and maintain volume monitors and DQ monitors (null rate, distribution, future-date checks)
Lead data quality reviews during connector installation and promotion (UAT → PRD)
Own the ticket queue for DQ, attribution, hierarchy, and customer-specific data quality issues

What you’ll bring

All qualifications

Core experience

  • Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field
  • Ability to manage several projects simultaneously, leveraging AI tooling to stay organized and efficient
  • Experience with Spark SQL and Hudi table format
  • Familiarity with data quality monitoring tools
  • Python scripting for data investigation and automation
  • Experience with Argo Workflows or similar orchestration platforms
Qualification wording
Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field
Ability to manage several projects simultaneously, leveraging AI tooling to stay organized and efficient
Experience with Spark SQL and Hudi table format
Familiarity with data quality monitoring tools
Python scripting for data investigation and automation
Experience with Argo Workflows or similar orchestration platforms
Education & alternatives
Education: - Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field Experience:

About Arcadia

Arcadia.io helps innovative providers and payers across the country transform healthcare to reduce cost while improving patient health.

In the employer’s words · Read in context

Apply at Arcadia

Posting record

Report an error

Open 5 monthsWe first saw this posting 177 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
May 29, 2026177 days ago
Recorded sightings
61
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$160K–$185K against $123K–$190K, the middle half of what similar US postings state.

From 342 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 177

Up longer than most. Similar jobs usually come down between day 7 and day 52.

From 1,781 similar postings that came down. Coming down is not always a hire.

Arcadia is hiring

4 open jobs

  • No new data jobs since August
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • dbt
  • Grafana
  • Redshift
  • Spark
  • Airflow
Where the posting names them
- Exposure to population health analytics concepts: HEDIS measures, risk adjustment, value-based care metrics - Python scripting for data investigation and automation - Experience with Argo Workflows or similar orchestration platforms
Why This Role Is Important to Arcadia Arcadia's data platform powers population health analytics for health plans, ACOs, and provider groups across the country. As a Lead Analytics Engineer — Data Modeling & Quality, you sit at the intersection of data quality ownership and analytical data modeling. You'll own the SQL and DBT layer that transforms raw clinical and claims data into trusted, production-grade datasets, while also serving as the quality authority for the data those models produce. This is a hybrid role — deeper SQL and DBT expertise than a traditional Data Health Professional, with a more analytical and model-focused scope than a Data Engineering role. You're less focused on pipeline infrastructure and more on the logic, shape, and trustworthiness of the data itself.
Arcadia's data platform powers population health analytics for health plans, ACOs, and provider groups across the country. As a Lead Analytics Engineer — Data Modeling & Quality, you sit at the intersection of data quality ownership and analytical data modeling. You'll own the SQL and DBT layer that transforms raw clinical and claims data into trusted, production-grade datasets, while also serving as the quality authority for the data those models produce. This is a hybrid role — deeper SQL and DBT expertise than a traditional Data Health Professional, with a more analytical and model-focused scope than a Data Engineering role. You're less focused on pipeline infrastructure and more on the logic, shape, and trustworthiness of the data itself. What Success Looks Like
- Troubleshoot and fix issues, then write DBT tests to catch issues proactively - Optimize SQL performance for slow-running jobs - Partner with Data Engineering on table design, partition strategy, and incremental patterns
TECHNOLOGIES - Data modeling: DBT-Spark, SQL, Claude - Warehousing: Amazon Redshift, Apache Hudi, AWS Athena
Experience: - Advanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databases - DBT: hands-on experience authoring models, tests, macros, and yml documentation; familiarity with incremental strategies
Would Love For You To Have - Experience with Spark SQL and Hudi table format - Familiarity with data quality monitoring tools
- Data modeling: DBT-Spark, SQL, Claude - Warehousing: Amazon Redshift, Apache Hudi, AWS Athena - Data quality: volume/DQ monitors, DBT tests
- Independently triage and resolve pipeline data quality issues - Author at least one new DBT model or refactor an existing one to meet current modeling standards - Understand the end-to-end pipeline from ingress through silver and gold, and be able to trace a data quality issue to its root layer
What You'll Be Doing DATA MODELING & DBT DEVELOPMENT - Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver
DATA MODELING & DBT DEVELOPMENT - Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver - Help clients understand their data model, assumptions, and limitations through intentional validation
- Help clients understand their data model, assumptions, and limitations through intentional validation - Troubleshoot and fix issues, then write DBT tests to catch issues proactively - Optimize SQL performance for slow-running jobs
- Warehousing: Amazon Redshift, Apache Hudi, AWS Athena - Data quality: volume/DQ monitors, DBT tests - Orchestration: Argo Workflows, Airflow
- Advanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databases - DBT: hands-on experience authoring models, tests, macros, and yml documentation; familiarity with incremental strategies - Healthcare data literacy: working knowledge of claims data (professional, institutional, pharmacy), clinical data (EHR entities), and common quality dimensions (member months, coverage rates, null patterns)
- Source control: Git / GitHub, PR-based review workflows - Observability: Grafana, Jira - Healthcare data: Claims (plan/professional/pharmacy), EHR (clinical entities), MPI
- Data quality: volume/DQ monitors, DBT tests - Orchestration: Argo Workflows, Airflow - Source control: Git / GitHub, PR-based review workflows

Your next step

Complete your application on jobs.lever.co. The employer’s form will show what is required.

Applying through Lever

  • No account needed: one form, and Lever reads your resume into the profile recruiters search.

Already applied? Track this application

Job description

View original posting ↗

Arcadia is dedicated to happier, healthier days for all. We believe that there is a better healthcare world – one powered by data. Our platform transforms complex, diverse data into a unified foundation for health, helping organizations deliver better care, boost revenue, and lower costs.
 
We’re a team of fiercely driven individuals committed to making healthcare more sustainable—and we’re looking for passionate people to help us get there.
 
For more information, visit arcadia.io.
 
 
Why This Role Is Important to Arcadia 

Arcadia's data platform powers population health analytics for health plans, ACOs, and provider groups across the country. As a Lead Analytics Engineer — Data Modeling & Quality, you sit at the intersection of data quality ownership and analytical data modeling. You'll own the SQL and DBT layer that transforms raw clinical and claims data into trusted, production-grade datasets, while also serving as the quality authority for the data those models produce.

This is a hybrid role — deeper SQL and DBT expertise than a traditional Data Health Professional, with a more analytical and model-focused scope than a Data Engineering role. You're less focused on pipeline infrastructure and more on the logic, shape, and trustworthiness of the data itself.

 
What Success Looks Like
In 3 months
  • Independently triage and resolve pipeline data quality issues
  • Author at least one new DBT model or refactor an existing one to meet current modeling standards
  • Understand the end-to-end pipeline from ingress through silver and gold, and be able to trace a data quality issue to its root layer
In 6 months
  • Building strong working relationships with clients and cross-functional partners (Data Engineering, Customer Success)
  • Deeply familiar with Arcadia's full data stack — from ingress through silver, gold, and downstream consumers
  • Driving at least one improvement project forward, whether technical (e.g. model refactor, new DQ framework) or process-focused (e.g. promotion playbook, triage workflow)
In 12 months
  • Recognized as a leader within the department — peers and stakeholders seek out your expertise on data modeling and quality
  • Operating independently across the full scope of the role with minimal guidance
  • Two or more improvement projects completed and in production, with measurable impact on data quality or operational efficiency

What You'll Be Doing

    DATA MODELING & DBT DEVELOPMENT
  • Author, review, and maintain DBT models using Spark/Hudi from ingest through bronze and silver
  • Help clients understand their data model, assumptions, and limitations through intentional validation
  • Troubleshoot and fix issues, then write DBT tests to catch issues proactively
  • Optimize SQL performance for slow-running jobs
  • Partner with Data Engineering on table design, partition strategy, and incremental patterns
  • DATA QUALITY OWNERSHIP
  • Triage and classify data quality alerts, distinguishing source-level issues from transform-layer failures
  • Design and maintain volume monitors and DQ monitors (null rate, distribution, future-date checks)
  • Author and apply clinical DQ rules (entity volume, field coverage, LOINC coverage, referential integrity) and claims validation rules across silver and gold layers
  • Conduct quality reviews for connector promotions — evaluating silver entity coverage, validation rule pass rates, and bronze-to-silver transformation correctness
  • Own the ticket queue for DQ, attribution, hierarchy, and customer-specific data quality issues, writing clear customer-facing findings
  • CROSS-FUNCTIONAL QUALITY COLLABORATION
  • Lead data quality reviews during connector installation and promotion (UAT → PRD), including claims validation playbooks and null analysis
  • Partner with Data Engineering on root-cause triage for errors, ingress anomalies, and silver table issues surfaced through data quality monitoring
  • Coordinate with the Measure Implementation Team (MIT) when data quality issues affect quality measure scores
  • Contribute to and enforce data modeling standards across teams
  • TECHNOLOGIES
  • Data modeling: DBT-Spark, SQL, Claude
  • Warehousing: Amazon Redshift, Apache Hudi, AWS Athena
  • Data quality: volume/DQ monitors, DBT tests
  • Orchestration: Argo Workflows, Airflow
  • Source control: Git / GitHub, PR-based review workflows
  • Observability: Grafana, Jira
  • Healthcare data: Claims (plan/professional/pharmacy), EHR (clinical entities), MPI

What You'll Bring

    Education:
  • Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field
  • Experience:
  • Advanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databases
  • DBT: hands-on experience authoring models, tests, macros, and yml documentation; familiarity with incremental strategies
  • Healthcare data literacy: working knowledge of claims data (professional, institutional, pharmacy), clinical data (EHR entities), and common quality dimensions (member months, coverage rates, null patterns)
  • Data quality mindset: ability to differentiate source data issues from transform issues, design systematic validation checks, and communicate data quality findings clearly
  • Skills:
  • Clear communicator — able to translate technical findings for clients and non-technical stakeholders
  • Strong analytical judgment — you can look at a distribution and know when something is wrong
  • Ability to manage several projects simultaneously, leveraging AI tooling to stay organized and efficient
  • Genuine desire to learn and apply AI tools for operational efficiency

Would Love For You To Have

  • Experience with Spark SQL and Hudi table format
  • Familiarity with data quality monitoring tools
  • Comfortable operating in an AI-first environment using Claude to build/verify various day-to-day workflows
  • Exposure to population health analytics 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

What You'll Get

  • Work alongside a talented team on some of the most complex and rewarding challenges in healthcare data
  • Flexible, fully remote work environment with the resources and support to do your best work
  • Exposure to senior leaders
  • Be on the front lines of AI adoption — use cutting-edge tools to accelerate your work and shape how the team operates in an AI-first environment
  • Make a meaningful impact on healthcare data operations by improving the quality, reliability, and trustworthiness of data that drives patient care decisions
  • Be a part of a mission driven company that is transforming the healthcare industry
  • Become a member of the talented, energized, diverse and purpose-driven Arcadian Community

Salary

160,000 – 185,000 USD per year

About Arcadia
Arcadia.io helps innovative providers and payers across the country transform healthcare to reduce cost while improving patient health. We do this by aggregating large amounts of disparate data, applying algorithms to identify opportunities to provide better patient care, and making those opportunities actionable by physicians at the point of care in near-real time. We are passionate about helping our customers drive meaningful outcomes. We are growing fast and have emerged as a market leader in the highly competitive population health management software market and have been recognized by industry analysts KLAS, IDC, Forrester, and Chilmark for our leadership. For a better sense of our brand and products, please explore our website.

Protect Yourself
If you have concerns about the authenticity of a job offer or recruitment-related communication claiming to be from Arcadia, we encourage you to verify by contacting us directly at (781) 202-3600 and select option 3. For more information, visit our website.

This position is responsible for following all Security policies and procedures in order to protect all PHI under Arcadia's custodianship as well as Arcadia Intellectual Properties.  For any security-specific roles, the responsibilities would be further defined by the hiring manager.

Employment type

Full-time

Demand for Analytics Engineer roles

New Analytics Engineer postings at the employers we follow are down 21% over the last 6 weeks compared with the 6 before.

Weekly new Analytics Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 81, the most 168, and the latest week had 91.
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 Analytics Engineer, by the work the posting describes.

Analytics engineers turn raw warehouse data into clean, tested and documented tables that analysts and dashboards can rely on, often with dbt.

Expect strong SQL, data modeling, Git, and a warehouse such as Snowflake, BigQuery or Redshift.

A data engineer gets data into the warehouse; an analytics engineer shapes it once it is there and works closer to the analysts who use it.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for analytics engineers, so these figures are for the closest group, database architects, the same group we use for data engineers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary 160,000 – 185,000 USD per year About Arcadia
Location & working pattern

Remote (USA)

Arcadia's data platform powers population health analytics for health plans, ACOs, and provider groups across the country. As a Lead Analytics Engineer — Data Modeling & Quality, you sit at the intersection of data quality ownership and analytical data modeling. You'll own the SQL and DBT layer that transforms raw clinical and claims data into trusted, production-grade datasets, while also serving as the quality authority for the data those models produce. This is a hybrid role — deeper SQL and DBT expertise than a traditional Data Health Professional, with a more analytical and model-focused scope than a Data Engineering role. You're less focused on pipeline infrastructure and more on the logic, shape, and trustworthiness of the data itself. What Success Looks Like
More source context
- Work alongside a talented team on some of the most complex and rewarding challenges in healthcare data - Flexible, fully remote work environment with the resources and support to do your best work - Exposure to senior leaders
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.