Job Title:
Data Engineer / Data Warehouse Developer
Location:
Mumbai
Reports to:
Head of Engineering
Direct Reports:
N/A
Primary Purpose
To design, build, and maintain a scalable internal data repository that consolidates data from key business systems (operational platforms, finance, sales & marketing, and timesheets) into a secure, well-modelled cloud data warehouse to power analytics and self‑service reporting in Power BI
Main Responsibilities:
Technology
- Design, develop, and maintain robust data pipelines to ingest data from multiple internal systems via APIs, integration platforms, and batch processes into a central Snowflake data warehouse.
- Model and implement scalable data warehouse structures (staging, core, marts) to support analytics and reporting use cases across finance, sales & marketing, operations, and resourcing/timesheets.
- Collaborate with business stakeholders (Finance, Sales, Marketing, Operations, HR/Resourcing) to understand data requirements, map source systems, and define a consistent, joined‑up data model.
- Implement and maintain ELT/ETL processes using appropriate tools (e.g. integration platforms, orchestration tools, SQL, scripting) ensuring performance, reliability, and maintainability.
- Work closely with BI developers and analysts to expose clean, well‑documented datasets and semantic models optimised for Power BI.
- Ensure data quality and integrity through validation rules, reconciliation checks, and monitoring across the full data pipeline from source to reporting.
- Optimise compute, storage, and queries for cost‑efficiency and performance, including clustering, caching, and workload management.
- Maintain clear technical documentation for data models, data flows, lineage, and transformations to support collaboration and ongoing maintenance.
- Stay current with modern data engineering practices, tooling, and cloud data platform capabilities, proposing improvements to the data architecture and pipelines.
Process, Quality and Information Security
- Manage your own workload, delivering committed work within the iteration and to agreed definitions of done.
- Ensure all data pipelines and transformations are appropriately tested (unit, integration, regression) and integrated into the release process, supporting higher levels of deployment automation.
- Contribute to and adopt CI/CD practices for data and analytics assets (e.g. version control for SQL/scripts, automated deployment of data models and pipelines).
- Adhere to Information Security policies and implement “security by design” across data pipelines and platforms, including access control, encryption, and secure handling of PII/financial data.
- Collaborate with IT Operations, Information Security, and Software Engineering teams to align on infrastructure requirements, environments, and operational support models.
- Support change and release processes (including CAB where required), ensuring changes to data pipelines and warehouse structures are well‑planned and low risk
Professional skills/ experience:
· Strong experience as a Data Engineer / Data Warehouse Developer or similar role, ideally in a cloud‑native environment.
· Expert SQL skills with experience building and optimising complex queries and transformations.
· Hands‑on experience designing and implementing data warehouses or data lakehouses (star/snowflake schemas, dimensional modelling, slowly changing dimensions, etc.).
· Practical experience with cloud data warehouses, databases, roles, virtual warehouses, performance tuning, cost optimisation.
· Experience ingesting data from APIs and/or integration platforms (e.g. iPaaS tools, ETL/ELT orchestrators) and working with a variety of data formats (JSON, CSV, parquet, etc.).
· Familiarity with BI / visualisation tools, preferably Power BI, and how to structure data for efficient reporting and self‑service analytics.
· Understanding of data quality management, metadata, data lineage and data governance practices.
· Experience with cloud platforms (e.g. Azure, AWS, or GCP) and modern DevOps practices (version control, CI/CD, environment management).
· Scripting or programming experience (e.g. Python) for data processing and automation is highly desirable
- Knowledge of information security standards and regulatory requirements relating to data (e.g. ISO27001, GDPR) is a plus
Personal Qualities
· Strong problem solver who enjoys working with complex, messy data and turning it into reliable, usable assets.
· Able to build trust and rapport across Finance, Sales, Marketing, Operations, IT and Engineering teams.
· Clear and confident communicator, capable of explaining technical concepts to non‑technical stakeholders.
· Team player with a collaborative, flexible approach and a “can do” mindset
· Able to prioritise effectively, manage multiple data initiatives, and resolve issues quickly.
· High attention to detail with a focus on data accuracy, consistency, and reliability
