Lead Analytics Engineer - Data Modeling & Quality

2 weeks, 5 days 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

Lead Analytics Engineer

Monzo 1K-5K Banks

Monzo is hiring a Lead Analytics Engineer in its Operations team to shape and scale the data warehouse and analytics foundations that support customer service, forecasting, and operational decision-making across the UK bank.

GCP LLM Machine Learning SQL
12 hours, 27 minutes ago

Senior Analytics Engineer (Data + BI) — Healthcare

FamilyWell 11-50 Health Care Providers & Services

FamilyWell Health is hiring an Analytics Engineer to own its end-to-end healthcare data stack, turning operational and clinical data into governed analytics and BI for teams across the business.

Apache Airflow CI/CD Dagster Databricks dbt Docker GCP Git HIPAA HubSpot Looker PostgreSQL Power BI Prefect Python Salesforce Snowflake SQL Tableau Terraform
1 day, 12 hours ago

Analytics Engineer II

Affirm 1K-5K Diversified Financial Services

Affirm is hiring an Analytics Engineer to maintain and optimize its finance data platform for Accounting, ensuring reliable pipelines, core datasets, and reporting foundations at scale.

dbt Git GitHub Python Snowflake SQL
2 days, 12 hours ago

Analytics Engineer, DTC E-commerce

Hyprwork 51-200 Online and Mail Order Retail

Hyprwork is hiring a hands-on Analytics Engineer to build the company’s first dedicated data function and turn fragmented operational, marketing, and customer data into reliable reporting and business insights for a fast-growing DTC health and wellness brand.

Apache Airflow dbt Facebook Ads GCP Looker Metabase Power BI Python Shopify Snowflake SQL Tableau
4 days, 12 hours 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