Lead Data Modeler, Vice President

Royal Bank of Scotland; Gurugram District; On-site; INR 2,500,000 - 5,000,000; Full time

Job summary

Royal Bank of Scotland is seeking a Lead Data Modeler to define and realise data architecture across franchises, building scalable data structures and ensuring alignment with strategy. You will manage analysis, capture requirements, and maintain strong stakeholder relationships with internal teams and external suppliers.

The role emphasizes expertise in data modelling, data lineage, and metadata, with hands-on work on modern data platforms and cloud warehouses.

Qualifications

• Experience creating conceptual, logical, and physical data models for enterprise data platforms.
• Strong knowledge of dimensional modelling, Data Vault, and star/snowflake schemas.
• Ability to translate business requirements into scalable data structures with stakeholders.

Responsibilities

• Create and maintain documentation and support QA for stakeholders and suppliers.
• Identify and support cutover and implementation tasks.
• Trace business requirements to future state design.
• Create and execute test scenarios and scripts to validate design.
• Facilitate UAT and support business users during testing.

Skills

Data modeling

SQL

Stakeholder management

Cloud data platforms

Education

BAX

CPRE

CBAP

Tools

AWS

ETL/ELT pipelines

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 principals. 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.

• 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.

• 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

Hours

45

Job Posting Closing Date

09/09/2026