Lead Analytics Engineer - Data Modeling & Quality

1 month, 3 weeks ago
Full-time
Lead
Data Science and Analytics
Arcadia

Arcadia

Arcadia provides a healthcare data platform that enables organizations to unify diverse data sources, derive actionable insights through analytics, and enhance patient outcomes by delivering high-quality care experiences.

IT Services
251-1K
Founded 2002
$154M raised

Description

  • Author, review, and maintain dbt models using Spark/Hudi across ingest, bronze, and silver layers.
  • Help clients understand data model assumptions and limitations through intentional validation.
  • Troubleshoot and fix data issues, then create dbt tests to catch problems proactively.
  • Optimize SQL performance for slow-running jobs.
  • Partner with Data Engineering on Hudi table design, partition strategy, and incremental patterns.
  • Triage and classify data quality alerts, distinguishing source-level issues from transform-layer failures.
  • Design and maintain volume monitors and data quality monitors such as null rate, distribution, and future-date checks.
  • Author and apply clinical and claims data quality rules across silver and gold layers.
  • Conduct quality reviews for connector promotions, including silver entity coverage and transformation correctness.
  • Own the ticket queue for data quality, attribution, hierarchy, and customer-specific issues, and write clear customer-facing findings.
  • Lead data quality reviews during connector installation and promotion from UAT to production.
  • Partner with Data Engineering on root-cause triage for ingress anomalies and silver table issues.
  • Coordinate with the Measure Implementation Team when data quality issues affect quality measure scores.
  • Contribute to and enforce data modeling standards across teams.

Requirements

  • Bachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related field.
  • Advanced SQL experience, including window functions, complex CTEs, aggregation patterns, and performance tuning on columnar databases.
  • Hands-on dbt experience authoring models, tests, macros, and YAML documentation.
  • Familiarity with incremental strategies in dbt.
  • Working knowledge of healthcare claims data, clinical EHR entities, and common data quality dimensions such as member months, coverage rates, and null patterns.
  • Ability to differentiate source data issues from transform issues and design systematic validation checks.
  • Strong communication skills for translating technical findings to clients and non-technical stakeholders.
  • Strong analytical judgment for identifying anomalies in data distributions.
  • Ability to manage several projects simultaneously while using AI tooling to stay organized and efficient.
  • Willingness to learn and apply AI tools for operational efficiency.
  • Experience with Spark SQL and the Hudi table format is preferred.
  • Familiarity with data quality monitoring tools is preferred.
  • Comfort operating in an AI-first environment using Claude is preferred.
  • Exposure to population health analytics concepts such as HEDIS measures, risk adjustment, and value-based care metrics is preferred.
  • Python scripting experience for data investigation and automation is preferred.
  • Experience with Argo Workflows or similar orchestration platforms is preferred.
  • Healthcare data standards knowledge such as ICD-10, CPT, NDC, LOINC, and NPI is preferred.

Benefits

  • $160,000 - $185,000 annual salary.
  • Flexible, fully remote work environment.
  • Opportunity to work alongside a talented, diverse, mission-driven team.
  • Exposure to senior leaders.
  • Access to cutting-edge AI tools in an AI-first environment.
  • Opportunity to make a meaningful impact on healthcare data quality and patient care decisions.
  • Work at a fast-growing company recognized by industry analysts.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Analytics Engineer III - FMX

Fanatics 5K-10K Retailing

Fanatics Betting and Gaming is hiring an Analytics Engineer III to help build accurate reporting and self-serve analytics for its sports betting and gaming business.

dbt GitHub Looker Power BI Snowflake SQL Tableau
53 minutes ago

FBS Analytics Engineer

Capgemini 100K+ Internet Software & Services

FBS – Farmer Business Services, in partnership with Capgemini as Employer of Record, is hiring an Analytics Engineer to build and maintain data models and pipelines that support business analytics for Farmers operations.

Apache Airflow dbt Power BI Python Snowflake SQL
1 hour, 23 minutes ago

FBS Associate Analytics Engineer (Remote)

Capgemini 100K+ Internet Software & Services

FBS – Farmer Business Services, part of Farmers operations and partnered with Capgemini as employer of record, is hiring a data-focused professional to help turn raw data into structured datasets for organization-wide analysis and decision-making.

Apache Airflow AWS Azure dbt GCP Python SQL
1 hour, 23 minutes ago

Power Platform Analytics Engineer

Accenture 100K+ Professional Services

Accenture Federal Services is seeking an Analytics Engineer to support the CFIUS Analytics team in building and maintaining a Microsoft Power Platform-based analytics platform for federal mission work.

Azure CI/CD JavaScript OAuth Power BI Python React TypeScript
1 hour, 38 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers