Senior Data Engineer

The role

You will own the data foundation of Zinnov's GCC Intelligence Platform. You will build reliable multi-tenant pipelines and KPI-ready datasets across Finance and Hiring domains, which downstream dashboards and AI agents will use.

What you will do

• Build and maintain ingestion pipelines from source systems such as Dynamics, Workday, Airtable and SFTP feeds.
• Design and implement Medallion pipelines (Bronze, Silver, Gold) across Finance and Hiring data.
• Build reconciliation and gating logic so only validated data reaches Gold.
• Design multi-tenant PostgreSQL schemas with row-level security (RLS) for tenant isolation.
• Implement SCD2 patterns for historical tracking of hiring and finance records.
• Build cross-domain enrichment pipelines, such as Finance and Hiring joins for cost-per-FTE and related KPIs.
• Build and maintain FastAPI endpoints consumed by the UI and AI layers.
• Work closely with DevOps to deploy orchestrated pipelines on Azure (e.g., Prefect).

Required qualifications

• 4+ years building production-grade data pipelines.
• Strong PostgreSQL: schema design, RLS, triggers, window functions.
• Strong Python for pipelines, transformations and APIs.
• Experience with orchestration tooling (Prefect, Airflow or similar).
• Hands-on exposure to Medallion architecture and SCD2 in practice.
• Data governance mindset: treat pipelines and Gold outputs as platform contracts.
• Strong debugging, performance tuning and reliability orientation.
• Comfort building for scale and reuse in a multi-tenant environment.

About the company

Zinnov is a global management consulting firm that helps organizations make data-led decisions. It has 450+ professionals across 10 global offices and works across industries including Digital Services, ER&D, Enterprise Software, Semiconductors, Healthcare, BFSI, Automotive, Media & Telecom and Private Equity.