Lead Data Platform Engineer

About the Organisation

We are one of India’s leading AMISP (Advanced Metering Infrastructure Service Providers), manufacturing over 5 Lac smart energy meters monthly, supported by in-house teams for Design, Development, Validation, Software Engineering, and Managed Software Services. With a turnover of ₹600 Cr and rising, we are expanding into smart water and gas metering solutions. This position is based in Kolkata and offers a unique opportunity to be part of a data-intensive product ecosystem at scale.

Position Overview

We are looking for a hands-on, technically mature **Lead Data Platform Engineer** who thrives on architecting and optimizing time-series and high-throughput data platforms. You will own the end-to-end database architecture and engineering function with a sharp focus on PostgreSQL (TimescaleDB), data lifecycle performance, and advanced query optimization. Candidates from high-scale, fast-paced environments such as e-commerce, travel-tech, or dynamic startups will find this role familiar and challenging in the right measure.

Suggested Designation

Lead Data Platform Engineer – PostgreSQL & Big Data Solutions

Key Responsibilities

• Design and optimize scalable PostgreSQL (Time Series) data architectures to manage billions of telemetry records.
• Develop and maintain high-performance data models, schemas, indexing strategies, and time-series data workflows.
• Ensure superior performance for time-bound analytics and search queries across large and partitioned datasets.
• Work with DevOps and cloud engineering teams to provision AWS-native or hybrid DB environments with cost efficiency.
• Collaborate closely with product and engineering teams to optimize DB interactions, ingestion pipelines, and data lifecycle policies.
• Champion coding standards, Postgre SQL practices, and peer reviews across the backend data layer.
• Act as the go-to expert for database architecture decisions and high-availability, failover strategies.
• Orchestrate & closely work with the Deployment & / or the Solutions teams for Optimisation of Resources as per the Project Needs.

Required Skills & Experience

• 5–7 years of strong PostgreSQL (TimescaleDB) development experience in data-heavy environments.
• Prior experience as a Database Architect designing data platforms handling high-volume ingestion and query loads.
• Hands-on expertise in query optimization, indexing, and partitioning strategies.
• Sound scripting knowledge in SQL, Python or Bash for automation and integration.
• 1–2 years’ experience working on AWS RDS, Aurora, or equivalent managed DB platforms.
• Exposure to ElasticSearch, Redis, Kafka, or other supporting high-throughput technologies is a plus.
• Strong grounding in techniques relevant to large data platforms.
• Proficiency in schema evolution, data archival techniques, and long-term retention architecture.
• Good understanding of security, access control, and encryption best practices in cloud-hosted environments.

Preferred Background

• Hands-on developer-oriented DBA, not just a database manager or administrator.
• Experience in companies like E-commerce, Travel, Logistics, Food Tech industries, allied-Startups etc.
• Flipkart, Amazon, MakeMyTrip, Yatra, or other high-scale startups preferred.
• Bachelor’s or Master’s degree in Computer Science, IT, or allied fields from a reputed institution.
• Values-driven individual with attention to data integrity, performance, and scalability.

Authority & Strategic Impact

• Own the data platform’s performance, uptime, and design direction.
• Make authoritative calls on data modeling, indexing, and schema management.
• Collaborate with software architects and customer IT teams for scalable DB strategies.
• Contribute to the cloud migration and optimization roadmap with cross-functional stakeholders.
• Mentor junior developers and database engineers within the platform team.