Data Modeler

Yorkshire Building Society Group; Leeds; On-site; GBP 35,000 - 50,000; Full time

Job summary

Join a leading company as a Data Modeler, where you'll analyze data requirements and design database structures to support business needs. This role offers a supportive environment with flexible working options and a focus on professional development. Enjoy competitive benefits including a generous pension contribution and health plans.

Benefits

25 days holiday plus Bank Holidays

Bonus of up to 15% of eligible pay

Pension contribution of up to 11%

Private medical insurance

Access to self-service benefits portal

Qualifications

• Experience as a Data Analyst or Data Modeller.
• Proven track record with data modelling tools.
• Knowledge of data management and database design.

Responsibilities

• Oversee database design and data analysis across projects.
• Identify and document data requirements.
• Design dimensional tables for data warehouse.

Skills

Database Design

Data Analysis

SQL

Data Governance

Entity-Relationship Modelling

Education

Relevant Degree in Data Science or IT

Tools

Erwin

Job description

As our next Data Modeler (known internally as Data Design Analyst), you’ll analyse data requirements, design database structures and profile data to support our portfolio for change. You’ll utilise database design and data governance tools to document and design data solutions in our enterprise repositories, supporting business ownership of data. You’ll join a likeminded team in our Leeds-based Enterprise Data Technical Solutions function.

If you’ve got a solid background in database design (relational and dimensional data modelling) and you want to develop a career in an empowering, respectful and supportive business then why not join us?

About the role

You’ll oversee database design and data analysis work across a number of projects and contribute to our standards. With a proactive approach to work, you will have experience of normalised and dimensional database design, as well as writing SQL to identify source data and data transformations. Your typical activities will include:

• Identifying and documenting data requirements

• Carrying out entity-relationship modelling in line with best practices (fully normalised, conceptual, logical and physical design)

• Designing dimensional or denormalised tables for our data warehouse

• Creating data mappings for data integration components

• Being responsible for delivering designs in-line with data architecture standards, patterns, principles and challenging where necessary.

About you

• You have experience working in a similar role - Data Analyst, Data Modeller or similar, working with Business Stewards and Data Architects to understand enterprise requirements

• You have a proven track record of using data modelling and data governance tools such as Erwin or similar

• You have knowledge of data management and database design

• You have demonstrable experience of profiling data and writing SQL.

About us

At YBS we don’t have shareholders, we have members. We care about people and that includes you. So here, you’ll be respected for who you are, you’ll be able to bring your whole self to work, and you’ll have everything you need to build a long and rewarding career.

Flexibility. We offer a range of flexible working options without unsocial hours, which can help you find a healthy work-life balance. Whether it’s finishing early for an appointment or fitting your studies and hobbies in around your working hours, we can help make it work for you. We’re happy to talk flexible working and you can reach out to us anytime to discuss this during the recruitment process.

Development. We want you to feel challenged here. Whatever your ambitions, we’re committed to helping you develop your skills and move ahead in your career journey. From day one, we’ll set you up for success with a brilliant induction and full training plan, all designed to get you up to speed quickly.

Inclusivity. We’re passionate about creating an inclusive environment where everyone is welcome and able to be themselves. If you’ll go the extra mile to help our members, you’ll fit right in and feel you belong here.

About our Benefits

We offer lots of fantastic rewards that you can make the most of in and out of work, including:

• Holiday. You’ll get 25 days plus Bank Holidays, as well as the option to buy up to a further 5 days.
• Bonus. At YBS we work collaboratively and share in our success together, so when we reach our goals were all rewarded with an on target bonus of 7% of eligible pay (with the opportunity to earn up to a maximum 15%).
• Pension. We know how important it is to save towards the future, that’s why we’ll contribute up 11% into your YBS pension.
• Healthcare. Health and wellbeing are an important part of life at YBS, when you join us you’ll have access to a range of health benefits to suit your life including private medical insurance, dental and healthcare plans.
• My Benefits. When you join YBS you’ll have access to our self-service benefits portal, where you can access a range of retail, hospitality and health discounts.

Ready to apply?

If you’re excited about this role and want to be part of the YBS team, click apply now to send us your application.

Want more information?

If you have any questions about this role, please contact Holly Gallagher at [e-mail]

Please note: This advert will close 2nd June 2025.