Senior Data Engineer

Astrodata; United States; Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Remote work with annual team offsite

US health coverage

401k with employer matching

Job summary

Astrodata is seeking a Senior Data Engineer to design and implement scalable data pipelines and robust data architectures for a diverse client base. You will work on ingestion, transformation, and downstream delivery, leveraging dbt, Airflow, and modern data stack tools.

The role focuses on building end-to-end data solutions, optimizing batch and streaming workflows, and collaborating with analysts and engineers to deliver analytics-ready datasets. Remote work within the US is supported.

Qualifications

• 5+ years of experience as a Data Engineer.
• Strong SQL data transformations and Python pipelines.
• Experience with dimensional modeling (Kimball).
• Experience designing end-to-end data warehouses (Snowflake).
• Experience with batch and streaming architectures; Airflow or Prefect.
• Experience with git and agile teams.

Responsibilities

• Design, implement, and maintain scalable data pipelines using dbt and Airflow.
• Architect and optimize batch and streaming workflows (Snowflake, Kafka, AWS).
• Lead development and orchestration of ETL/ELT frameworks with testing and data quality.
• Proactively implement monitoring, logging, CI/CD, and alerting for production pipelines.
• Collaborate with client teams to design shared data models and analytics datasets.

Skills

5+ years experience

SQL

Python

Dimensional modeling

Tools

dbt

Airflow

Snowflake

Kafka

AWS (S3, Lambda, ECS Fargate)

Job description

# Senior Data EngineerFull-timeRemote (US)CompetitivePosted July 2026## OverviewWe’re looking for a driven, thoughtful, and intellectually curious Senior Data Engineer to join our core team at Astrodata. In this role, you’ll focus on designing and implementing data solutions that support ingestion, transformation, orchestration, and downstream delivery - serving a wide range of clients and technology partners.## Responsibilities* Design, implement, and maintain scalable and modular data pipelines using tools like dbt and Airflow, ensuring reliable ingestion, transformation, and delivery across diverse client environments.* Architect and optimize batch and streaming workflows using platforms such as Snowflake, MotherDuck, Kafka, and AWS-native services (e.g., S3, Lambda, ECS Fargate), balancing performance, cost, and maintainability.* Lead the development and orchestration of robust ETL/ELT frameworks, with a focus on reusability, observability, and testing practices (e.g., data contracts, dbt tests, test coverage, enabling teams to employ robust data quality and testing practices).* Proactively implement monitoring, logging, CI/CD practices, and alerting strategies to ensure pipeline health and resilience in production.* Serve as a strategic technical partner to client stakeholders across operations, finance, product, and executive teams - translating ambiguous needs into actionable data solutions.* Guide client teams on data best practices, system design tradeoffs, and how to leverage the modern data stack effectively.* Collaborate with client-side analysts, data scientists, and engineers to design shared data models, semantic layers, and analytics-ready datasets.* Define and enforce data validation and automated quality checks across pipelines and layers of the stack.* Support client data classification, access controls, and security best practices for protecting sensitive data in both transit and at rest.* Establish and maintain metadata, documentation, and lineage tracking systems to ensure transparency and stewardship across evolving data ecosystems.* Provide technical leadership within project teams, mentoring junior engineers and championing high standards in code quality, testing, and review processes.* Stay current on evolving data tools and patterns; proactively propose new architectures and workflows to meet emerging client needs.* Lead or contribute to internal tooling, templates, and process improvements that strengthen the consultancy’s data engineering practice.## Requirements* 5+ years of experience as a Data Engineer (or similar role)* Significant experience designing and implementing data warehouse solutions end-to-end (e.g. Snowflake architecture and platform delivery) - from data ingestion and data lake design patterns, to release of data marts* Strong SQL experience, especially writing data transformations via dbt* Strong Python experience, especially authoring data pipelines and API integrations* Experience dimensional modeling (e.g. especially Kimball, others like Data Vault helpful)* Experience scaling batch and streaming analytics architectures* Experience working with Python-based workflow orchestration for tools (e.g. Airflow, Prefect) for data ingestion and/or other data orchestration processes.* Experience using git for version control, and working within agile (e.g. Scrum) teams.### Nice to Have* Experience developing a semantic layer, and releasing semantic models to production* Experience with containerization: Docker development and orchestration (e.g. ECS Fargate, Kubernetes) patterns* Experience productionizing data architecture serving downstream embedded analytics or AI applications* Experience with additional data warehouse & platform technologies (e.g. Databricks, ClickHouse, DuckDB)* Experience with streaming event analytics pipelines and platforms (e.g. Snowplow)* Experience working with ML teams productionizing ML / AI workloads* Experience working in healthcare or health technologies* Experience working on marketing attribution data challenges, especially data-driven attribution and marketing mix modeling (MMM).## Benefits & Perks* Remote work with at least annual team offsite* Great health, dental, and vision coverage (US only)* 401k benefits with employer matching contribution (US only)* The chance to help build out our practice, helping form our service offerings and strategy* Ability to learn rapidly amongst an extremely talented and collaborative team* An awesome, empathetic community of co-workers## Apply Now