[Hiring] Senior Data Engineer @CodeRoad

Role Description

We are looking for a Mid-to-Senior Data Engineer to architect, build, and operate cloud-native data pipelines on AWS. In this role, you will anchor the flow of data from diverse source systems—including relational databases, SaaS applications, and event streams—into a central Snowflake data platform modeled in dbt Cloud. You will be responsible for ensuring technical excellence across our data infrastructure by writing production-grade Python, utilizing modern AI coding assistants like GitHub Copilot and Claude, and managing infrastructure as code via Terraform.

This role is critical to shaping and defending our core data architecture, optimizing platform performance, and delivering curated, analytics-ready datasets for downstream BI and reporting. As a key contributor on a fully remote team, your autonomy, ownership mindset, and clear written communication will directly impact our ability to scale data solutions and maintain full historical accuracy using advanced dimensional modeling techniques.

Key Responsibilities

• Design and own the architectural evolution of data pipelines and platform components, leading design reviews and defending technical decisions with evidence-based reasoning.
• Build and maintain robust ingestion pipelines leveraging AWS DMS, Amazon AppFlow, and Amazon EventBridge to land data seamlessly into AWS S3 and Snowflake.
• Optimize and model analytics datasets within dbt Cloud, applying strict dimensional modeling (Kimball techniques) and implementing SCD Type 2 logic.
• Lead performance tuning and cost optimization efforts across the Snowflake ecosystem, proactively implementing monitoring, alerting, and root-cause analysis.
• Collaborate with cross-functional teams to prepare curated datasets for Power BI, while mentoring peers through rigorous code reviews and engineering enablement.

Qualifications

• 5+ years of professional experience in Data Engineering roles.
• Proficiency with Python (including AWS Lambda), advanced SQL, dbt Cloud, Snowflake, Terraform (IaC), and Docker.
• Deep hands-on experience with core AWS data services (S3, Glue, Athena, EventBridge, AppFlow, DMS).
• Solid grasp of dimensional modeling (star schemas, fact/dimension design) and practical implementation of SCD Type 2.
• High autonomy, ownership mindset, discipline to raise risks early, and comfort utilizing AI-assisted development tools (GitHub Copilot, Claude).
• Advanced English (written and spoken) is mandatory for seamless remote collaboration.

Nice to Have

• AWS Certified Data Engineer – Associate (DEA-C01) or equivalent certification.
• Experience with change-data-capture (CDC) and near-real-time ingestion patterns.
• Exposure to workflow orchestration tools such as Apache Airflow, Dagster, or Prefect.
• Familiarity with data observability frameworks (Great Expectations, Monte Carlo) and open table formats like Apache Iceberg.

Benefits

• 100% Remote
• Holidays off
• Paid Time Off
• Health insurance assistance
• Competitive USD compensation
• Growth opportunities