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 10 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 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.)