Lead Data Modeler, Vice President

NatWest Group; Gurugram District; On-site; INR 2,500,000 - 5,200,000; Full time

Job summary

NatWest Group is seeking a Lead Data Modeler to drive data modeling across enterprise platforms. You will manage analysis of complex requirements, translating them into scalable data structures and robust data architectures, while collaborating with stakeholders and suppliers across functions.

The role emphasizes data modeling expertise, metadata management and strong SQL capabilities to support cloud-based data warehouses and lakehouse environments (AWS preferred).

Qualifications

• Proven experience developing conceptual, logical and physical data models for enterprise-scale data platforms.
• Strong knowledge of dimensional modeling, Data Vault, star/snowflake schemas for cloud data warehouses.
• Ability to translate business requirements into robust data structures with stakeholders.
• Experience defining metadata, data lineage, reference data standards and data quality rules.
• Strong SQL skills and experience with ETL/ELT pipelines and analytical data ecosystems.

Responsibilities

• Manage analysis of cross-franchise and pan-bank requirements and document business and system requirements.
• Build, maintain and manage positive stakeholder relationships and with third-party suppliers.
• Create and maintain documentation, controls and QA for key stakeholders and suppliers.
• Identify cut-over and implementation tasks and support delivery.
• Trace requirements to future state design and validate solution design.

Skills

Data modeling

Dimensional modeling

Data Vault

SQL

Stakeholder management

Cloud data warehouses

Education

BA/BAA or BA/CBAP/CPRE/BAX certifications

Tools

AWS

Snowflake

Job description

Join us as a Lead Data Modeler

• Take on a critical role defining and realising fantastic solutions, processes, benefits and new opportunities to deliver to our stakeholders
• You'll be working in a vibrant, forward looking team and helping us to shape the future of our business
• It’s a great chance to hit the ground running and make a tangible impact on our function
• We're offering this role at vice president level

What you'll do

In your new role, you’ll be managing the analysis of complex cross franchise and pan bank requirements, while capturing, validating and documenting business and system requirements and making sure that they are in line with key strategic principles. In the course of your work, we’ll also look to you to build, manage and maintain a positive working relationship with stakeholders and third party suppliers across multiple franchises and functions.

You’ll also:

• Create and maintain documentation, as well as support controls and quality assurance for key stakeholders and suppliers
• Identify and support cut-over and implementation tasks
• Trace and link business requirements to future state design
• Create and execute test scenarios and test scripts at various stages of the project in order to validate the solution design
• Facilitate user acceptance testing and support business users in executing the user acceptance testing

The skills you'll need

You’ll need to hold an appropriate business analyst certification, such as BAX, CPRE and CBAP. Additionally, you’ll have an analytical mindset, with strong organisational skills and the ability to prioritise your work.

You’ll also need:

• Proven experience developing conceptual, logical, and physical data models for enterprise-scale data platforms using industry-standard modelling techniques
• Strong knowledge of dimensional modelling, Data Vault, star/snowflake schemas, and designing models for cloud-based data warehouses and lakehouse environments (AWS preferred)
• Ability to work with business, product, and technology stakeholders to translate business requirements into robust and scalable data structures
• Experience defining business and technical metadata, data lineage, reference data standards, and data quality rules to support trusted data assets
• Strong SQL skills and hands-on experience working with modern data platforms, ETL/ELT pipelines, and analytical data ecosystems
• Strong stakeholder management skills