Postgres / sql data engineer

Job Summary:

We are looking for an experienced Post Gress / SQL Data Engineer who possesses strong SQL/Postgre SQL expertise, and can build scalable, high‐performance DB Queries. The ideal candidate should be able to understand complex stored procedure logic, write optimized SQL queries, create advanced DAX calculations.

Interested? Please send your updated resumes at reetha@

Key Responsibilities:

Postgre SQL / SQL Development

Write complex SQL queries, window functions, CTEs, aggregations, and transformations. Design, develop, and maintain scalable data pipelines and ETL/ELT workflows to ingest, transform, and deliver data from multiple sources. Understand, validate, and optimize existing stored procedures and functions. Apply Postgre SQL performance optimization techniques including index tuning, Write complex, high-performance SQL queries, stored procedures, triggers, functions, and views in Postgre SQL to support business logic and reporting needs. EXPLAIN/ANALYZE, partitioning, minimizing sequential scans, optimizing analytical queries. Work with product owners, analysts, and business users to understand reporting and data needs. Convert business logic into efficient SQL Maintain documentation for SQL scripts, DAX logic, data models, and development standards. Implement and maintain complex joins (inner, outer, cross, self), CTEs, window functions, and advanced aggregations to support analytical use cases. Participate in sprint discussions, requirement finalizations, and production validations.

Required Skills

Data engineer

7+ years hands‐on experience as a Data Engineer Strong skills in DAX, data modeling, Power Query, and performance tuning. Experience with RLS, and dataflows.

SQL / Postgre SQL

5+ years SQL experience, specifically Postgre SQL. Ability to interpret and improve complex stored procedure logic. Expertise in SPs, UDFs, analytical queries, and performance tuning.

Tools & Practices

Experience with Git/version control. Familiar with AI‐assisted development (Git Hub Copilot in VS Code) and writing effective prompts.

Other Skills

Strong analytical and problem‐solving abilities. Good communication and documentation skills. Experience working in Agile/Scrum settings.

Years of Experience

Overall Experience: 6 to 9 years SQL/Postgre SQL: 5+ years

Good‐to‐Have Skills

Knowledge of Microsoft Fabric components. Familiarity with ETL/ELT processes. Exposure to CI/CD pipelines for BI solutions. Experience with streaming data technologies such as Apache Kafka or AWS Kinesis. Exposure to No SQL databases (Mongo DB, Cassandra, Dynamo DB). Knowledge of data governance, lineage, and cataloging tools. Experience in Agile/Scrum environments. Familiarity with containerization tools like Docker and Kubernetes.