Senior Data Engineer, AWS Lakehouse

Posted 77ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Data Engineer developing a modern data platform on AWS for lakehouse architecture. Overseeing design, build, and operation from ingestion to BI delivery.

Responsibilities:

  • Build and maintain a medallion architecture (landing/integrated/reporting) on S3 using Apache Iceberg
  • Develop and operate data pipelines using dbt-core running against Athena
  • Implement ingestion patterns using AWS AppFlow, DMS, and custom Lambda functions
  • Design incremental load and merge logic for CDC data streams
  • Optimize query performance for BI consumption (partitioning, aggregation, file compaction)
  • Build orchestration workflows using Step Functions
  • Establish data quality testing, monitoring, and alerting
  • Support PowerBI integration and troubleshoot refresh issues
  • Document data models and maintain lineage

Requirements:

  • 5+ years working with cloud data platforms (AWS strongly preferred)
  • Production experience with dbt (dbt-core or dbt Cloud)
  • Strong SQL skills including window functions, CTEs, and incremental/merge patterns
  • Hands-on experience with at least one modern table format (Iceberg, Delta, or Hudi)
  • Familiarity with Athena, Glue, or similar serverless query engines
  • Experience with CDC pipelines and handling SaaS data sources
  • Working knowledge of Python for custom ingestion and tooling
  • Understanding of BI tool requirements and how to optimize serving layers for reporting
  • Upper-Intermediate/B2 English across all four skills

Benefits:

  • Opportunity to work remotely
  • Overlap with EST working hours