Lead Analytics Engineer - Data Modeling & Quality

4 months, 1 week 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

Marketing Data Analytics Engineer (US)

PointClickCare 1K-5K Health Care Providers & Services

PointClickCare is seeking a Marketing Data Analytics Engineer to build reliable data infrastructure and automated reporting across Salesforce, Marketo, and its data warehouse, supporting marketing-sourced pipeline reporting for its healthcare businesses.

Apache Airflow dbt GCP LLM Looker Power BI Python Salesforce Snowflake SQL Tableau
2 hours, 14 minutes ago

Marketing Data Analytics Engineer (CA)

PointClickCare 1K-5K Health Care Providers & Services

PointClickCare is hiring a Marketing Data Analytics Engineer to build reliable data infrastructure and automated reporting that connects marketing systems and supports pipeline reporting across its healthcare businesses.

Apache Airflow dbt GCP LLM Looker Power BI Python Salesforce Snowflake SQL Tableau
2 hours, 14 minutes ago

Senior Analytics Engineer (Finance & Operations)

Skylight / Skylight Frame 51-200 Consumer electronics

Skylight is hiring a Senior Analytics Engineer to own the Finance and Operations data layer, integrating business systems and delivering trusted metrics and dashboards that support company decision-making.

ERP Looker NetSuite Power BI Snowflake SQL Tableau
4 days, 2 hours ago

Data and Analytics Engineer

Nimble Gravity 51-250 IT Services

Nimble Gravity is seeking an Analytics Engineer & AI Specialist to help financial institutions and other clients build governed, production-ready data foundations and semantic models that enable reliable AI applications on Snowflake.

Apache Airflow CI/CD dbt Git Python Snowflake SQL YAML
5 days, 2 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