Data Modeler

Senior Data Modeler / Data Designer (Risk Data & BI)

Location: Pune/Nagpur

Experience: 8+ Years

Domain: Banking & Financial Services

Role Overview

We are seeking an experienced Senior Data Modeler / Data Designer to lead the design, development, and governance of enterprise data models with a strong focus on Risk Data Management. The ideal candidate will translate complex business, risk, and regulatory requirements into scalable conceptual, logical, and physical data models while enabling enterprise reporting through SQL Server Analysis Services (SSAS) and Power BI.

This role requires deep expertise in enterprise data modeling, risk data domains, regulatory reporting, and Microsoft BI technologies to support strategic decision-making across the organization.

Key Responsibilities

Enterprise Data Modeling

• Design, develop, and maintain conceptual, logical, and physical enterprise data models across data warehouses, data marts, and analytical platforms.
• Develop scalable dimensional models (Star & Snowflake Schemas) and normalized data structures to support enterprise analytics and reporting.
• Define and enforce enterprise data modeling standards, metadata management, naming conventions, and documentation.
• Perform data profiling, source-to-target mapping, impact analysis, and data validation.
• Collaborate with Data Architects, ETL Developers, Data Engineers, and Business Analysts to ensure accurate implementation of data models.

Risk Data Management

• Design enterprise data models supporting Credit Risk, Market Risk, Operational Risk, and Liquidity Risk domains.
• Develop fit-for-purpose data structures supporting regulatory reporting requirements including Basel III/IV, IFRS 9, BCBS 239, and Central Bank of UAE reporting.
• Partner with Risk, Finance, and Compliance teams to ensure high-quality, governed, and traceable risk data.
• Support enterprise Data Governance initiatives including data lineage, business glossaries, metadata management, and data quality frameworks.

Business Intelligence & Analytics

• Design, develop, and optimize SQL Server Analysis Services (SSAS) Tabular and Multidimensional models.
• Develop and maintain enterprise Power BI semantic models, dashboards, datasets, and executive reports.
• Build and optimize DAX/MDX calculations, partitions, aggregations, and security models.
• Implement Row-Level Security (RLS), Incremental Refresh, deployment pipelines, and Power BI governance best practices.
• Monitor and optimize report performance, scalability, and user adoption.

Leadership & Stakeholder Management

• Act as the subject matter expert for enterprise data modeling and BI solutions.
• Work closely with business stakeholders to translate complex business and regulatory requirements into scalable data solutions.
• Mentor junior Data Modelers, BI Developers, and Analysts.
• Participate in architecture reviews, solution governance, and vendor evaluations.
• Present technical concepts and recommendations to senior business and technology leadership.

Required Skills & Experience

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline (Master's preferred).
• 8+ years of experience in Data Modeling, Data Warehousing, Business Intelligence, and Enterprise Data Architecture.
• Proven experience within Banking or Financial Services, with strong exposure to Risk Data Management.
• Hands-on expertise in conceptual, logical, and physical data modeling using tools such as ERwin, ER/Studio, PowerDesigner, or similar.
• Strong experience supporting Credit Risk, Market Risk, Operational Risk, Liquidity Risk, and regulatory reporting.
• Advanced expertise in SQL Server Analysis Services (SSAS) (Tabular and/or Multidimensional), including DAX and MDX.
• Strong knowledge of the Microsoft BI stack, including SQL Server, SSIS, SSRS, and Power BI.
• Advanced SQL programming, query optimization, and performance tuning skills.
• Solid understanding of Data Warehousing, Data Governance, Metadata Management, and Data Quality principles.

Preferred Qualifications

• Experience working with Basel III/IV, IFRS 9, BCBS 239, or other banking regulatory frameworks.
• Microsoft certifications in Power BI, Azure Data, or SQL Server are an added advantage.
• Experience working within enterprise-scale banking data platforms.

Key Competencies

• Strong analytical and problem-solving abilities.
• Excellent stakeholder management and communication skills.
• Ability to manage multiple priorities in a fast-paced regulatory environment.
• Strong attention to detail with a quality-first mindset.
• Leadership, mentoring, and cross-functional collaboration skills.
• Ownership mindset with the ability to drive initiatives independently.