Analytics Engineer, Data Platform

Recruiting From Scratch LLC
Columbus, United States of America
18 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 157K

Job location

Remote
Columbus, United States of America

Tech stack

Adaptable Database Systems
Data analysis
Business Logic
Big Data
Command-Line Interface
Cloud Computing
Continuous Integration
Data Validation
Data Governance
Data Infrastructure
ETL
Data Mart
Data Warehousing
Database Queries
Dimensional Modeling
Python
Operational Databases
Raw Data
Standard Sql
Software Engineering
SQL Databases
Strategies of Testing
Scripting (Bash/Python/Go/Ruby)
Business Intelligence Development Studio
Warehouse Management Systems
Data Ingestion
Sysadmin
Information Technology
Data Lineage
Looker Analytics
Data Pipelines

Job description

We are building the data foundation that will power AndHealth's self-service analytics organization. As an Analytics Engineer, Data Platform, you will own a critical piece of that foundation from raw data ingestion to curated data products that analysts, clinicians, and business stakeholders can trust and use independently. You will work closely with Data and Software Engineering on ETL pipelines, build and maintain dbt models that encode domain-specific business logic, and help stand up the semantic layer and BI tooling (we use Omni) that enables self-service across the organization. This is a full-stack data role: you are equally comfortable in the weeds of SQL and dbt as you are thinking about how a metric should be defined for a care operations team. This role sits within a small, growing Analytics Engineering team and is an opportunity to shape the platform from the ground up. What you'll do in the role:

  • Design, build, and maintain dbt models that transform raw clinical, pharmacy, billing, and care operations data into clean, reliable, domain-specific data marts.
  • Partner with Data and Software Engineering on ETL pipeline design, data ingestion, and raw-to-staging transformations by ensuring data arrives in a form that AE can work with.
  • Develop and own the semantic layer in Omni by defining governed metric definitions, curated datasets, and self-service data products that analysts and stakeholders can consume directly.
  • Build a thorough testing suite across the data platform: schema tests, data quality checks, anomaly detection, and SLA monitoring to ensure stakeholders can trust what they see.
  • Implement and maintain data governance practices including lineage documentation, cataloging, access control, and column-level documentation in dbt.
  • Become a domain expert in your assigned area (pharmacy operations, billing, or care operations) by deeply understanding the business logic and translating it into accurate, scalable data models.
  • Work closely with analysts to understand their data needs, accelerate their workflows, and reduce time spent on ad hoc data prep - enabling them to focus on higher-order analysis and strategy.
  • Contribute to platform-level decisions: warehouse organization, modeling conventions, CI/CD for dbt, and tooling standards across the AE team.
  • Proactively identify data quality issues, gaps in coverage, and opportunities to improve the reliability and usability of the data platform.

Requirements

  • Bachelor's degree in Computer Science, Economics, Engineering, Mathematics, or a related quantitative field, or equivalent practical experience., * Strong SQL proficiency: comfortable writing complex queries, CTEs, window functions, and performance-optimized transformations across large datasets.
  • Hands-on experience with dbt (Core or Cloud): you understand the modeling layer, ref() dependencies, tests, macros, and how to structure a well-organized dbt project.
  • Solid understanding of data warehouse concepts: dimensional modeling, mart layers, slowly changing dimensions, and how to think about the staging / intermediate / mart separation.
  • Experience working with ETL/ELT pipelines and partnering with data or software engineers on data ingestion.
  • Comfort with the command line: run scripts, manage files, and troubleshoot basic shell operations. You don't need to be a sysadmin, but you're not afraid of a terminal.
  • Strong analytical instincts: able to interrogate data, identify anomalies, trace root causes, and communicate findings clearly to both technical and non-technical audiences.
  • Comfort working in ambiguous, fast-moving environments with competing priorities.

Preferred

  • Experience with a semantic layer or BI tool such as Omni, Looker, Metabase, or similar - especially defining metrics, dimensions, and governed data products.
  • Familiarity with healthcare data: clinical, pharmacy, billing, or claims data from EHRs, TPAs, or pharmacy operating systems.
  • Experience with data quality frameworks, testing strategies, or anomaly detection in a production data environment.
  • Exposure to data governance tooling: data catalogs, lineage tracking, or column-level documentation.
  • Python or another scripting language for data tasks or pipeline work.

Benefits & conditions

Here's what we'd like to offer you:

  • Equal investment and support for our people and patients.
  • A fun and ambitious start-up environment with a culture that takes on big things, takes risks, and learns quickly.
  • The ability to demonstrate creativity, innovation, and conscientiousness, and find joy in working together.
  • A team of highly skilled, incredibly kind, and welcoming employees, every one of whom has something unique to offer.
  • We know that the overall success of our business is a collaborative effort, and we strive to provide ongoing opportunities for our employees to learn and grow, both personally and professionally.
  • Full-time employees are eligible to participate in our benefits package which includes Medical, Dental, Vision Insurance, Company, and Paid time off, Short- and Long-Term Disability, and more.

We are an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability, or veteran status. Powered by JazzHR, + $137,000-157,000 per year Who is Recruiting from Scratch: Recruiting from Scratch is a talent firm that focuses on placing the best candidate for our clients. Our team is 100% remote and we work with teams …

  • 1 month ago

About the company

AndHealth is on a mission to radically improve access and outcomes for the most challenging chronic health conditions, with the goal of making world-class specialty care accessible and affordable to all. We partner with health systems, community health centers, plans, and employers to remove barriers to care to ensure all people have access to the care they deserve., © 2026 Careerjet All rights reserved

Apply for this position