Location: Pune

Experience: 5–7 Years

About The Role

We are seeking a Data Engineer with solid expertise in PostgreSQL, SQL, data pipelines, and data modeling. The role focuses on building reliable data platforms and reusable data assets that support enterprise analytics, querying, APIs, feature engineering, and real-time and analytical consumption.

Job Description

The role involves designing, developing, and supporting data pipelines that securely acquire, aggregate, refine, and move data from source systems to target platforms. The candidate will develop production-grade SQL and optimize PostgreSQL performance through query tuning, indexing, partitioning, statistics management, and concurrency handling.

The position also requires designing logical and physical data models, establishing data contracts, managing schema evolution, and implementing resilient data processing with error handling, retries, idempotency, and reprocessing capabilities. The candidate will collaborate with data scientists, data wranglers,



and technical development teams to deliver high-quality data solutions.

Key Responsibilities

Design, build, and support reliable data pipelines for enterprise data platforms.
Develop and maintain reusable data assets for analytics, querying, APIs, and feature engineering.
Write production-grade PostgreSQL SQL using CTEs, window functions, and set-based processing.
Optimize PostgreSQL performance through query tuning, execution plan analysis, indexing, partitioning, and statistics management.
Use EXPLAIN ANALYZE and BUFFERS to diagnose slow queries and identify I/O and execution bottlenecks.
Design effective indexes including B-tree, Hash, GiST, and GIN, aligned with filtering, joins, and sorting requirements.
Implement resilient pipelines with error handling, retry logic, idempotency, reprocessing, and backfill capabilities.
Design and maintain logical and physical data models using normalized and dimensional modeling approaches.
Define and maintain

📌 Specialist - Data Engineering (Pune)
🏢 Vivantify Technology Solutions India
📍 Pune