Postgres / SQL Data Engineer

Job Summary:

We are looking for an experienced PostGress / SQL Data Engineer who possesses strong SQL/PostgreSQL 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 [HIDDEN TEXT]

Key Responsibilities:

PostgreSQL / 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 PostgreSQL performance optimization techniques including index tuning,
• Write complex, high-performance SQL queries, stored procedures, triggers, functions, and views in PostgreSQL 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 / PostgreSQL

• 5+ years SQL experience, specifically PostgreSQL.
• 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 (GitHub 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/PostgreSQL: 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 NoSQL databases (MongoDB, Cassandra, DynamoDB).
• Knowledge of data governance, lineage, and cataloging tools.
• Experience in Agile/Scrum environments.
• Familiarity with containerization tools like Docker and Kubernetes.