Senior Data Engineer, AWS Lakehouse jobs in United States
cer-icon
Apply on Employer Site
company-logo

DOOR3 ยท 2 days ago

Senior Data Engineer, AWS Lakehouse

positionUnited States
timeFull-time
remoteRemote
senioritySenior Level
date5+ years exp

DOOR3 is building a modern data platform on AWS to unify data from various sources into a lakehouse architecture. The Senior Data Engineer will be responsible for the design, build, and operation of this platform, focusing on data ingestion, pipeline development, and ensuring data quality for BI delivery.

MobileSoftware
check
Diversity & Inclusion
check
H1B Sponsor Likelynote

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

Qualification

AWSDbtSQLApache IcebergPythonAthenaData pipelinesData quality testingBI tool optimizationUpper-Intermediate English

Required

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

Preferred

Experience with Salesforce and/or monday.com | The AI work platform data extraction
Infrastructure-as-code (Terraform, CloudFormation)
Cost optimization on AWS
Data governance and cataloging practices

Company

DOOR3

twittertwittertwitter
company-logo
DOOR3 is a digital agency that plans, designs and builds interactive enterprise applications for web, social and mobile media.
dateFounded in 2002
location
New York, New York, USA
people-size51-200 employees
web-link
http://www.door3.com

H1B Sponsorship

DOOR3 has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (1)
2020 (1)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Lawrence Lanzilli
Chief Revenue Officer
linkedin
Company data provided by crunchbase