[Remote] Lead Analytics Engineer - Data Modeling & Quality

Note: The job is a remote job and is open to candidates in USA. Arcadia is dedicated to transforming healthcare through data-driven solutions. As a Lead Analytics Engineer — Data Modeling & Quality, you will oversee the SQL and dbt layer that converts raw clinical and claims data into reliable datasets, ensuring data quality and integrity while collaborating across teams to enhance operational efficiency.ResponsibilitiesAuthor, review, and maintain dbt models using Spark/Hudi from ingest through bronze and silverHelp clients understand their data model, assumptions, and limitations through intentional validationTroubleshoot and fix issues, then write dbt tests to catch issues proactivelyOptimize SQL performance for slow-running jobsPartner with Data Engineering on Hudi table design, partition strategy, and incremental patternsTriage and classify data quality alerts, distinguishing source-level issues from transform-layer failuresDesign and maintain volume monitors and DQ monitors (null rate, distribution, future-date checks)Author and apply clinical DQ rules (entity volume, field coverage, LOINC coverage, referential integrity) and claims validation rules across silver and gold layersConduct quality reviews for connector promotions — evaluating silver entity coverage, validation rule pass rates, and bronze-to-silver transformation correctnessOwn the ticket queue for DQ, attribution, hierarchy, and customer-specific data quality issues, writing clear customer-facing findingsLead data quality reviews during connector installation and promotion (UAT → PRD), including claims validation playbooks and null analysisPartner with Data Engineering on root-cause triage for errors, ingress anomalies, and silver table issues surfaced through data quality monitoringCoordinate with the Measure Implementation Team (MIT) when data quality issues affect quality measure scoresContribute to and enforce data modeling standards across teamsSkillsBachelor's or Master's degree in Computer Science, Statistics, Business, Economics, or a related fieldAdvanced SQL: window functions, complex CTEs, aggregation patterns, performance tuning on columnar databasesDbt: hands-on experience authoring models, tests, macros, and yml documentation; familiarity with incremental strategiesHealthcare data literacy: working knowledge of claims data (professional, institutional, pharmacy), clinical data (EHR entities), and common quality dimensions (member months, coverage rates, null patterns)Data quality mindset: ability to differentiate source data issues from transform issues, design systematic validation checks, and communicate data quality findings clearlyClear communicator — able to translate technical findings for clients and non-technical stakeholdersStrong analytical judgment — you can look at a distribution and know when something is wrongAbility to manage several projects simultaneously, leveraging AI tooling to stay organized and efficientGenuine desire to learn and apply AI tools for operational efficiencyExperience with Spark SQL and Hudi table formatFamiliarity with data quality monitoring toolsComfortable operating in an AI-first environment using Claude to build/verify various day-to-day workflowsExposure to population health analytics concepts: HEDIS measures, risk adjustment, value-based care metricsPython scripting for data investigation and automationExperience with Argo Workflows or similar orchestration platformsHealthcare data standards: ICD-10, CPT, NDC, LOINC, NPIBenefitsFlexible, fully remote work environment with the resources and support to do your best workExposure to senior leadersBe on the front lines of AI adoption — use cutting-edge tools to accelerate your work and shape how the team operates in an AI-first environmentMake a meaningful impact on healthcare data operations by improving the quality, reliability, and trustworthiness of data that drives patient care decisionsBe a part of a mission driven company that is transforming the healthcare industryBecome a member of the talented, energized, diverse and purpose-driven Arcadian CommunityCompany OverviewHealthcare data analytics platform It was founded in 2007, and is headquartered in Boston, Massachusetts, USA, with a workforce of 201-500 employees. Its website is https://arcadia.io.Company H1B SponsorshipArcadia has a track record of offering H1B sponsorships, with 1 in 2026, 1 in 2023, 1 in 2020. Please note that this does not guarantee sponsorship for this specific role.