Overview
Skills
Job Details
Sr. Data Engineer AWS Lambda & PostgreSQL
Location: Hempstead NY or Basking Ridge NJ or Columbus OH or Dallas TX
Experience: 13+ years
Key Responsibilities:
Design, develop, and deploy serverless data ingestion pipelines using AWS Lambda
Write and optimize Lambda functions to clean, transform, and push data into PostgreSQL
Develop and maintain scalable, efficient data models supporting analytical workloads
Create LookML models and build dashboards in Looker to enable self-service analytics
Maintain database integrity, indexing, and performance optimization
Collaborate with product, engineering, and analytics teams to understand data needs
Build robust error-handling, logging, and retry mechanisms for data pipelines
Ensure data governance, quality, and security best practices are followed
Ideal Profile:
Overall 13+ years of experience
3 5 years of experience in Data Engineering or Backend Engineering roles
Strong experience with AWS Lambda and serverless data architecture
Proficient in Python or Node.js for writing Lambda functions
Solid experience with PostgreSQL schema design, optimization, and advanced SQL
Proven expertise in data modeling for analytics and reporting
Hands-on experience with Looker (LookML, dashboards, data exploration)
Familiarity with AWS services like S3, CloudWatch, API Gateway, and IAM
Excellent debugging, problem-solving, and communication skills