Job Title: Sr Data Engineer – AWS Lambda & PostgreSQL - Need locals Location: NY or Columbus OH Onsite Duration: 12 months Role Overview: We are seeking a skilled S r 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 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.)