[Hiring] Senior Data Engineer @Adoreal

Role Description

We are seeking a Senior Data Engineer to be the most experienced engineer on our data team. This is a hands-on role by design. You will pair with the team daily, set the standards the data function works to, and take the lead on the architecture decisions that shape what we build next.

• Own the target design for the warehouse and the curated layer.
• Define the semantic layer for business metrics.
• Establish standards for naming, lineage, and data quality.
• Ensure practices can see the patient journey clearly.
• Transition migration from skilled manual work to repeatable platform processes.

Our warehouse is Amazon Redshift running a medallion model, fed from PostgreSQL by Python pipelines and from marketing sources by Fivetran, with Power BI on top. You will own the recommendation on where that architecture goes next, and then you will build it.

We also build with AI as a default rather than as an experiment. Coding agents draft quickly here, so the skill we hire for and level on is knowing what to build and recognizing what is wrong with a draft.

Qualifications

• 8+ years in data engineering, including end-to-end ownership of a warehouse or lakehouse architecture.
• Deep SQL and Python, with production experience on a modern cloud warehouse.
• Hands-on experience building a semantic or metrics layer using dbt or an equivalent tool.
• Production experience with orchestration and infrastructure as code on AWS (e.g., Airflow and Terraform).
• Experience designing and maintaining dimensional or Data Vault models in production.
• Data quality testing and observability built into the pipeline.
• AI applied inside a data platform, such as LLM classification of unstructured records.
• Experience with regulated data, such as healthcare or financial data.

Requirements

• Architecture and Modeling
• Own the target architecture for the warehouse and the curated layer.
• Design the semantic layer as a single metric repository.
• Set the standard for naming, labeling, and lineage.
• Build the configuration model for practice-specific business rules.
• Building With the Team
• Pair with the data engineers daily and review their work.
• Build the gold layer and a baseline report library for new practices.
• Extend infrastructure as code and CI across the warehouse and its pipelines.
• Bring unstructured clinical records into the warehouse in structured form.
• Automation and AI in the Data Platform
• Deepen automation around migration profiling and data quality checks.
• Put AI to work inside the pipelines for enrichment and anomaly detection.
• Make the warehouse safe and useful for AI.
• Migrations and Partnership With Engineering
• Take migration from skilled manual work to repeatable processes.
• Partner with engineering teams on platform changes.
• Work directly with product and commercial leadership on metrics.

Benefits

• Healthcare coverage for you and your family.
• 401k Plan.
• Paid time off (PTO) and paid holidays.
• Company equity opportunities.
• Fully remote work environment with flexible schedules.
• Collaborative and thriving team culture guided by Adoreal’s core values.