Deputy Manager - Data Warehouse & Analytics

Role Overview

We are looking for an experienced Data Warehouse & Analytics professional to join the Technology / Data function of a mid-sized financial services organization. The role will play a key part in defining and implementing the organization's cloud-based Data Warehouse and Analytics platform, enabling the consolidation, transformation and collation of data from multiple internal ERP and business systems into a centralized repository.

The individual will work closely with Technology, Business, Finance, Risk, Operations and other stakeholders to establish a Single Source of Truth, automate management reporting and MIS, and enable near real-time dashboards and analytics. The role will also explore and implement AI-enabled capabilities for dashboard automation, reporting, data interpretation and business insights.

Key Responsibilities

1. Data Warehouse & Cloud Data Platform

Participate in defining the architecture, requirements and implementation roadmap for a cloud-based Data Warehouse / Data Lakehouse.

Design processes for data extraction, transformation, cleansing, validation and loading into the centralized repository; integrating with multiple systems.

Develop robust ETL/ELT pipelines and data transformation processes.

Establish data models, data marts and analytical datasets to support business reporting and analytics.

Ensure scalability, reliability, performance and security of the data platform.

Establish standardized data definitions, KPIs and reporting logic across functions.

Identify and resolve data quality, duplication, inconsistency and reconciliation issues.

Support development of a trusted Single Source of Truth (SSOT) for management and operational reporting.

2. Business Intelligence, Dashboards & MIS

Design and develop interactive dashboards and management reports for senior management and business teams.

Automate recurring MIS and management reporting processes, reducing dependency on manual Excel-based reporting.

Develop near real-time / frequent-refresh dashboards wherever business requirements demand.

Establish standardized dashboards and KPI frameworks across business functions.

3. AI-enabled Analytics & Reporting

Identify opportunities to leverage AI/ML and Generative AI to enhance reporting and analytics.

Explore AI-enabled automated generation of MIS, management summaries and business insights.

Develop capabilities for natural-language querying of business data and dashboards.

Required Qualifications & Experience

Bachelor's degree in Computer Science, Information Technology, Engineering, Data Science, Analytics or a related discipline.

Minimum 5 years of relevant experience in Data Warehousing, Business Intelligence, Analytics, MIS automation or Data Engineering.

Strong experience in understanding and documenting business intelligence and reporting requirements.

Proven experience in developing dashboards, MIS and management reporting solutions.

Hands-on experience in SQL, data transformation and data automation.

Working knowledge of Python and its application in data processing/automation.

Experience working with ETL/ELT processes and data integration across multiple source systems.

Experience with cloud-based data platforms / data warehouses is highly desirable.

Exposure to BI tools such as Power BI, Tableau, Qlik or equivalent.

Exposure to AI/ML, Generative AI or AI-enabled analytics will be an advantage.

Preferred Skills

Strong analytical and problem-solving capabilities.

Ability to understand both business requirements and underlying technology / data architecture.

Strong SQL and data analysis skills.

Good understanding of ERP and enterprise application data structures.

Strong communication and stakeholder management skills.

Ability to work independently as well as with cross-functional teams.

Experience in financial services / banking / NBFC / lending environment will be an advantage.