Lead Analytics Engineer - Data Modeling & Quality

3 months, 2 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

Software Engineer II, Data Analytics & Engineering

Pinterest 5K-10K Internet Software & Services

Pinterest is seeking a Software Engineer II, Data Analytics and Engineering to build reliable data foundations, analytics tools, and analysis pipelines that support trusted, self-service insights for product and cross-functional teams.

Python R SQL
8 hours, 20 minutes ago

Sr. Business Intelligence Engineer

ZipRecruiter 1K-5K Internet Software & Services

ZipRecruiter is seeking a Senior BI Engineer to build scalable data systems, models, and AI-powered tools that support business decision-making and product engineering across billions of daily records.

Apache Spark CI/CD Databricks dbt GCP Git Kubernetes Python Scala Snowflake SQL
1 day, 7 hours ago

Lead Analytics Engineer

ComputerCare 51-250 Technology Hardware, Storage & Peripherals

ComputerCare is hiring a hands-on Lead Analytics Engineer to build and own the company’s analytics function, including data pipelines, models, reporting, governance, and trusted operational insights.

dbt JIRA Looker NetSuite Power BI Snowflake SQL Tableau
3 days, 7 hours ago

Analytics Engineer

FiscalNote 251-1K Diversified Financial Services

FiscalNote is hiring an Analytics Engineer to build scalable data models, reporting infrastructure, and analytics capabilities that support operational efficiency and enterprise decision-making across the company.

CI/CD dbt Git Looker Metabase Pandas Python Snowflake SQL Tableau
4 days, 7 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