Sr Data Engineer AWS Lambda & PostgreSQL

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Data Engineer
AWS Lambda
PostgreSQL
Looker dashboard

Job Details

Hi We have an immediate Openings with Our Direct Client for a Long-term contract position

Job Title: Sr Data Engineer AWS Lambda & PostgreSQL Location: Hempstead NY or Basking Ridge NJ or Columbus OH or Dallas TX Duration: 12 months

Role Overview:
We are seeking a skilled Sr Data Engineer to design and implement scalable data pipelines using AWS Lambda that push structured and semi-structured data into a PostgreSQL data store. The role also requires experience in data modeling, Looker dashboard development, and strong SQL/database expertise to support reporting and analytics needs across the organization.

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

Required Skills:
Overall 15+ 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

Good to Have:
Experience integrating third-party APIs or webhooks into Lambda functions
Familiarity with data warehousing concepts (e.g., Snowflake, Redshift, or BigQuery)
Exposure to CI/CD for data pipelines using tools like GitLab or Jenkins
Understanding of modern data stack tools (Fivetran, dbt, Airflow, etc.)

If interested, Please share below details with update resume:

Full Name:
Phone:
E-mail:
Rate:
Location:
Visa Status:
Availability:
SSN (Last 4 digit):
Date of Birth:
LinkedIn Profile:
Availability for the interview:
Availability for the project:

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.