6 months ago
Base Salary
$160k - $185k/yr
Responsibilities
- Author, review, maintain, and optimize DBT models using SQL, Spark, and Apache Hudi.
- Troubleshoot data issues and create DBT tests, volume monitors, and data quality monitors.
- Define and apply clinical and claims validation rules across silver and gold data layers.
- Triage source-level and transformation-layer data quality issues and identify root causes.
- Conduct data quality reviews for connector installations and promotions from UAT to production.
- Partner with Data Engineering on Hudi table design, partitioning, incremental patterns, and ingress anomalies.
- Own the ticket queue for data quality, attribution, hierarchy, and customer-specific issues.
- Coordinate with the Measure Implementation Team when data quality issues affect quality measure scores.
- Contribute to and enforce data modeling standards across teams.
- Explain data models, assumptions, limitations, and quality findings to clients and stakeholders.
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, YAML documentation, and incremental strategies.
- Working knowledge of healthcare claims and clinical EHR data and common data quality dimensions.
- Ability to distinguish source data issues from transformation issues and design systematic validation checks.
- Clear communication skills for translating technical findings to clients and non-technical stakeholders.
- Experience with Spark SQL and 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.
- Knowledge of ICD-10, CPT, NDC, LOINC, and NPI healthcare data standards 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.
- Opportunity to use AI tools and participate in an AI-first working environment.
- Mission-driven work improving healthcare data quality and operations.
- Membership in a diverse, energized, and purpose-driven company community.
Tech Stack
Categories
Data Engineering
About Arcadia
Arcadia builds a utility data and energy management platform used by enterprises, energy providers, and climate-tech applications, and operates software for community solar program management. Its business model combines SaaS data services and APIs with program operations and analytics across carbon, cost, and reliability. Headquartered in Washington, DC and privately held, Arcadia was founded in 2014 and expanded its data footprint by acquiring Urjanet in 2022.