Postgres / SQL Data Engineer

GBIT (Global Bridge InfoTech Inc); Hyderabad; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

GBIT (Global Bridge InfoTech Inc) in Hyderabad, India seeks an experienced PostGress / SQL Data Engineer to build scalable, high‑performance DB queries and data pipelines. The role emphasizes optimizing PostgreSQL queries, developing ETL/ELT workflows, and collaborating with analysts to translate business logic into efficient SQL.

You will apply DAX, data modeling, and Power Query skills while contributing to CI/CD for BI in an Agile environment.

Qualifications

• 6–9 years of hands-on data engineering experience.
• Strong PostgreSQL and SQL skills with ability to write optimized queries.
• Experience with ETL/ELT pipelines and data integration.
• Familiarity with DAX, data modeling, and Power Query.
• Exposure to CI/CD pipelines for BI solutions.

Responsibilities

• Write complex SQL queries, window functions, CTEs, aggregations, and transformations.
• Design, develop, and maintain scalable data pipelines and ETL/ELT workflows from multiple sources.
• Optimize existing stored procedures and functions for performance and correctness.
• Implement PostgreSQL performance optimization techniques including index tuning.
• Write complex SQL objects (stored procedures, triggers, functions, views) to support reporting needs.
• Collaborate with product owners, analysts, and business users to understand data needs.
• Translate business logic into efficient SQL and maintain comprehensive documentation.
• Support analytics through advanced joins, CTEs, and window functions.
• Participate in sprint discussions, requirements finalization, and production validations.

Skills

Data Engineering

DAX

Data Modeling

Power Query

PostgreSQL

SQL

Stored Procedures

Performance Tuning

RLS

Dataflows

Tools

Git

VS Code

GitHub Copilot

Docker

Kubernetes

Job description

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.

Key Responsibilities

• 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.
• 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

• 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.
• 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
• 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.
• Knowledge of data governance, lineage, and cataloging tools.
• Experience in Agile/Scrum environments.
• Familiarity with containerization tools like Docker and Kubernetes.