About the role
About the Role
As a Senior Data Engineer, you will own the data foundation of Zinnov’s GCC Intelligence Platform—building reliable multi-tenant pipelines and KPI-ready datasets across Finance and Hiring domains. Your work enables downstream dashboards and AI agents to operate on clean, reconciled, governed data.
What You’ll Do
Data Pipelines & Medallion Architecture
- Build andmaintainingestion pipelines from source systems (e.g., Dynamics, Workday, Airtable, SFTP feeds).
- Design and implement Medallion pipelines (Bronze → Silver → Gold) across Finance and Hiring data.
- Build reconciliation and gating logic to ensure only validated data reaches Gold.
Multi-tenant Data Modeling
- Design multi-tenant PostgreSQL schemas with row-level security (RLS) for tenant isolation.
- Implement SCD2 patterns for historical tracking of hiring/finance records.
- Build cross-domain enrichment pipelines (e.g., Finance + Hiring joins for cost-per-FTE and related KPIs).
APIs & Platform Integration
- Build and maintain Fast API endpoints consumed by the UI and AI layers.
- Partner closely with DevOps to deploy orchestrated pipelines on Azure (e.g., Prefect).
What You Bring
Qualifications & Experience
- 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.
Key Skills
- Data governance mindset—treat pipelines andGoldoutputs as platform contracts.
- Strong debugging, performance tuning, and reliability orientation.
- Comfort building for scale and reuse in a multi-tenant environment.
What Success Looks Like – Globalization Excellence (GE)
- Data pipelines runpredictably—highreliability, clean promotions to Gold, minimal rework.
- Tenant isolation is robust—RLS works consistently and safely at scale.
- KPIs are reconcilable—Finance and Hiring views are accurate and auditable.
- Downstream teams move faster—AI and UI features ship with confidence due to strong data foundations.
If you enjoy building multi-tenant data foundations, designing pipeline contracts that scale, and enabling AI + dashboards with governed data — this role offers both impact and progression.