Sr. Data Engineer - AWS Lambda & PostgreSQL

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., * 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

Hybrid working model. Bold is MUST have., 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.)