Lead Analytics Engineer - Data Modeling & Quality

21 hours, 55 minutes 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
501-1000
Founded 2002
$154M raised

Description

  • Author, review, and maintain DBT-Spark models and SQL transformations across ingest, bronze, and silver layers.
  • Troubleshoot data issues, identify root causes across source and transformation layers, and implement DBT tests to prevent recurrence.
  • Optimize SQL performance for slow-running jobs and partner with Data Engineering on table design, partitioning, and incremental patterns.
  • Triage and own the ticket queue for data quality, attribution, hierarchy, and customer-specific issues, including customer-facing findings.
  • Design and maintain volume and data-quality monitors for null rates, distributions, future dates, and other quality signals.
  • Apply clinical and claims validation rules across silver and gold datasets, including coverage, referential integrity, and transformation checks.
  • Lead data-quality reviews for connector installation and promotion from UAT to production.
  • Collaborate with Data Engineering, Customer Success, clients, and the Measure Implementation Team to resolve quality issues and assess downstream impacts.
  • Contribute to and enforce data modeling standards and deliver technical or process improvements to strengthen data quality and operational efficiency.
  • Follow security policies and procedures to protect PHI and Arcadia intellectual property.

Requirements

  • Bachelor’s or Master’s degree in Computer Science, Statistics, Business, Economics, or a related field.
  • Advanced SQL expertise, including window functions, complex CTEs, aggregation patterns, and columnar-database performance tuning.
  • Hands-on DBT experience authoring models, tests, macros, and YAML documentation, including incremental strategies.
  • Working knowledge of healthcare claims data, clinical EHR entities, and quality dimensions such as member months, coverage rates, and null patterns.
  • Ability to distinguish source-data issues from transformation failures and design systematic validation checks.
  • Ability to communicate technical data-quality findings clearly to clients and non-technical stakeholders.
  • Strong analytical judgment and ability to manage multiple projects simultaneously.
  • Interest in using AI tooling, including Claude, to improve workflow efficiency.
  • Experience with Spark SQL, Apache Hudi, data-quality monitoring tools, Python, or Argo Workflows is preferred.
  • Exposure to population health analytics, healthcare coding standards (ICD-10, CPT, NDC, LOINC, NPI), HEDIS, risk adjustment, or value-based care metrics is preferred.

Benefits

  • Flexible, fully remote work environment with resources and support.
  • Opportunity to work on complex healthcare data challenges that affect patient-care decisions.
  • Exposure to senior leaders and a cross-functional, purpose-driven team.
  • Access to cutting-edge AI tools in an AI-first operating environment.
  • Opportunity to shape data-quality practices and healthcare data operations.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

(EG0078) Senior Adobe Launch and Web SDK Engineer - Talent Connection

Nortal 501-1000 Internet Software & Services

Nortal is building a Future Talent network for Senior Adobe Launch and Web SDK Engineers to support client projects involving digital analytics, consent-platform migrations, and compliant data collection.

Agile JavaScript
21 hours, 40 minutes ago

FBS Senior Analytics Engineer

Capgemini 5001+ Internet Software & Services

Join Farmers Business Services, through Capgemini as Employer of Record, as a Data Engineer to build scalable data pipelines, semantic data layers, and AI-enabled analytics products for the Service Analytics and AI organization.

Agile Apache Airflow CI/CD dbt Git Python Snowflake SQL SQL Server
1 day, 18 hours ago

FBS Associate Analytics Engineer

Capgemini 5001+ Internet Software & Services

Join Farmers Business Services’ Analytics Engineering team as a Data Engineer to build scalable data pipelines, semantic data layers, and AI-driven data products that support analytics and customer experience initiatives.

Agile Apache Airflow CI/CD dbt Python Snowflake SQL SQL Server
1 day, 18 hours ago

FBS Analytics Engineer

Capgemini 5001+ Internet Software & Services

Join Farmers Business Services’ Analytics Engineering team as a Data Engineer to build scalable data pipelines, semantic data layers, and AI-driven data products that support analytics and customer experience initiatives.

Agile Apache Airflow CI/CD dbt Git Python Snowflake SQL SQL Server
1 day, 18 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