Job Description
Introduction
At RSA, we believe insurance is about people, not things. We provide our inspiring colleagues the support and opportunity to grow together, shape the future, and win as a team. We are going through a transformation journey, providing our people with opportunity to be integral to improving our service and delivering better products to brokers and customers. We are a proud member of the Intact family, we feel part of something bigger, with a presence in North America, the UK and Europe.
We have a bold ambition to become the best Commercial Lines business in the UK, demonstrated by our recent acquisition of NIG and Farmweb, allowing us to scale by leveraging our combined financial strength and importantly ensure our people feel the benefits of our joint capabilities.
We are currently recruiting for an Enterprise Data Modeller to join our established and experienced Chief Information Office team here at RSA on a hybrid basis.
Your Role
RSA is undergoing a bold transformation to become the UK's leading commercial lines insurer, and data is at the heart of this ambition. As part of the enterprise data strategy, we are building a connected, managed data architecture that enables smarter decision-making, operational efficiency and business value.
This role focuses on the Enterprise Data Model and Canonical Data Model as key enablers in our strategic data architecture. These artefacts ensure that our important data is consistently defined, well-connected and aligned across the value chain, enabling interoperability between systems and maximizing business value.
As Enterprise Data Modeller, you will lead the documentation of enterprise data needs across multiple projects and engage with a wide range of business, data and technology stakeholders. You will also define canonical data formats for seamless data exchange across strategic platforms, ensuring consistency and scalability across the enterprise.
About You
The responsibilities of the Enterprise Data Modeller include:
Enterprise Data Model (EDM) Development
Stakeholder Engagement: Strong communication and collaboration skills, with the ability to work effectively across functions and seniority levels.
Enterprise Data Modelling Expertise:
At RSA we put our people first. We have adopted hybrid working as standard, to give you a better work/life balance and an excellent flexible working mindset. That is on top of a comprehensive range of benefits, including pension contributions of up to 11% looking after you now, and in the future.
We will give you countless opportunities to continuously develop, alongside a diverse and passionate community of experts, the best the industry has to offer. You will be empowered to be your best self, do your best work, and make a meaningful impact. Our employee promise allows you to shape the future, win as a team, and grow with us.
About Us
We celebrate individuality and it is important to us that we have a culture where our people feel respected and valued for who they are. We pride ourselves on being accessible and encourage inclusive environments where our people can always give and show the very best of themselves.
We understand that home life is a priority and are happy to consider reduced hours or job shares.
If you think you would be a great fit for us, but do not meet all the requirements of the role, please contact us as we would love to discuss how RSA could be the next step in your career journey.
As a Disability Confident employer, we will ensure that a fair and proportionate number of disabled applicants that meet the minimum criteria for this position will be offered an interview.
If you wish to be considered under the scheme then please answer yes to the question Do you wish to be considered under the Disability Confident Scheme? in RSAs application form
Please let us know if there are any changes we could make to the application process to make it easier and more comfortable for you. Contact our recruitment team so we can work with you to support you throughout your application.
At RSA, we believe insurance is about people, not things. We provide our inspiring colleagues the support and opportunity to grow together, shape the future, and win as a team. We are going through a transformation journey, providing our people with opportunity to be integral to improving our service and delivering better products to brokers and customers. We are a proud member of the Intact family, we feel part of something bigger, with a presence in North America, the UK and Europe.
We have a bold ambition to become the best Commercial Lines business in the UK, demonstrated by our recent acquisition of NIG and Farmweb, allowing us to scale by leveraging our combined financial strength and importantly ensure our people feel the benefits of our joint capabilities.
We are currently recruiting for an Enterprise Data Modeller to join our established and experienced Chief Information Office team here at RSA on a hybrid basis.
Your Role
RSA is undergoing a bold transformation to become the UK's leading commercial lines insurer, and data is at the heart of this ambition. As part of the enterprise data strategy, we are building a connected, managed data architecture that enables smarter decision-making, operational efficiency and business value.
This role focuses on the Enterprise Data Model and Canonical Data Model as key enablers in our strategic data architecture. These artefacts ensure that our important data is consistently defined, well-connected and aligned across the value chain, enabling interoperability between systems and maximizing business value.
As Enterprise Data Modeller, you will lead the documentation of enterprise data needs across multiple projects and engage with a wide range of business, data and technology stakeholders. You will also define canonical data formats for seamless data exchange across strategic platforms, ensuring consistency and scalability across the enterprise.
About You
The responsibilities of the Enterprise Data Modeller include:
Enterprise Data Model (EDM) Development
- Design and maintain the RSA EDM as a strategic asset, including subject areas, glossary and best practices.
- Support enterprise data architects with technical tasks such as reverse engineering and productivity automation as well as with data modelling methodologies (relational, dimensional) and effort management.
- Manage EDM/CDM versioning, governance and change control processes to maintain integrity and traceability. Maintain change log on all updates and ensure change approvals are in place.
- Help communicate updates to EDM/CDM structure and guidelines to the solution data teams.
- Facilitate structured workshops with business and IT SMEs to understand and validate enterprise data needs.
- Ensure the EDM and CDM accurately reflect real-world business processes and data structures.
- Maintain metadata, reference data and lineage within the deliverables.
- Integrate with the enterprise data governance platform / data catalogue (Microsoft Purview).
- Partner with solution data architects and other roles to reflect solution needs in EDM and CDM.
- Support Data Architecture initiatives, e.g. contribute to solution data architecture reviews to ensure alignment, and ensure that the mapping to EDM / CDM has been performed correctly.
Stakeholder Engagement: Strong communication and collaboration skills, with the ability to work effectively across functions and seniority levels.
Enterprise Data Modelling Expertise:
- Proven hands-on experience in designing and integrating conceptual, logical, and physical data models, using both relational and dimensional modelling techniques
- Proven experience working on Enterprise Data Models and Canonical Data Models.
- Extensive hands-on experience with data modelling tools such as Erwin (required)
- Experience with enterprise application integration methods and tooling (required)
- Exposure to data quality and data management tools (beneficial).
At RSA we put our people first. We have adopted hybrid working as standard, to give you a better work/life balance and an excellent flexible working mindset. That is on top of a comprehensive range of benefits, including pension contributions of up to 11% looking after you now, and in the future.
We will give you countless opportunities to continuously develop, alongside a diverse and passionate community of experts, the best the industry has to offer. You will be empowered to be your best self, do your best work, and make a meaningful impact. Our employee promise allows you to shape the future, win as a team, and grow with us.
About Us
We celebrate individuality and it is important to us that we have a culture where our people feel respected and valued for who they are. We pride ourselves on being accessible and encourage inclusive environments where our people can always give and show the very best of themselves.
We understand that home life is a priority and are happy to consider reduced hours or job shares.
If you think you would be a great fit for us, but do not meet all the requirements of the role, please contact us as we would love to discuss how RSA could be the next step in your career journey.
As a Disability Confident employer, we will ensure that a fair and proportionate number of disabled applicants that meet the minimum criteria for this position will be offered an interview.
If you wish to be considered under the scheme then please answer yes to the question Do you wish to be considered under the Disability Confident Scheme? in RSAs application form
Please let us know if there are any changes we could make to the application process to make it easier and more comfortable for you. Contact our recruitment team so we can work with you to support you throughout your application.
About RSA