GAIN - Central IT - Data Warehouse Developer

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