Senior Data Modeller

6 days ago

Edinburgh, Edinburgh, United Kingdom Royal London Group Full time

Job Title: Senior Data Modeller

Contract Type: Permanent

Location:  Wilmslow or Edinburgh or Glasgow

Working style: Hybrid 50% home/office based

 

The Group Data Office (GDO) is responsible for enhancing the effectiveness of how data is used across Royal London (RL).  The function provides Data Governance, Data Management, Data Strategy, Analytics/AI and Insight capabilities. It sets and oversees data related policies and standards, so data is collected, processed, and exploited in accordance with the Group's risk appetite. 

Role Overview

Royal London is seeking experienced data modellers with extensive data warehouse design skills to join a newly formed Core Engineering team who play a pivotal part in the data engineering, modelling and data structure design across Royal London's Enterprise Data Platform (EDP) which is being built on out Azure Databricks.

The EDP is a Data Lakehouse built using the Databricks Medalion architecture and consists of a relational core 'silver' layer with a variety of dimensional, de-normalised and relational structured data products being exposed for consumption through the 'Gold' layer.

This opportunity gives the right candidates a superb opportunity to be involved in the design of a strategic data platform leveraging all the hard-earned data modelling and design skills acquired on other platforms but brought right up to date with the latest cloud based data technologies.

About the Role
  • Hands on data modelling and data structure design role with the EDP Core Engineering team. A key member of the team providing design and delivery on a number of data modelling\design engagement across the EDP.
  • Applies expert data modelling knowledge at all levels (conceptual, logical and physical), plus physical warehouse\data lakehouse data structure design experience within an Agile development environment.
  • Working potentially over multiple projects at any one time, so ability to multi-task and balance competing priorities important.
  • Defines the data mapping and transforms from source to target entities in the data model, working closely with data engineers, source system SMEs and technical BAs.
About You
  • Data Modelling\Design Expertise: Demonstrable experience and expertise of all levels of data modelling – conceptual, logical and physical and the various data design techniques used in modern data platforms including as relational, dimensional, data-vault and de-normalised big table and the correct application of each approach. Must have the skill level required to support agile development teams building out data products using any of these techniques.
  • Proven Experience: Demonstrates a proven track record in data modelling for complex, multi-vendor programmes and matrix-led engagements.
  • Pragmatic approach: always focused on delivering business value and balancing the trade-offs between design purity and value delivery.
  • Excellent interpersonal skills: ability to clearly explain complex data modelling and data design concepts to others in the technical team and those in senior less technical roles.
  • Ability to work closely with third-party authorities and MSA suppliers\partners and has a good understanding of regulations and legislation within the financial services market.
  • Technical Proficiency: Skilled in building and maintaining data models using data modelling tools (Idera ER/Studio or similar).
  • Expert level SQL skills required.
  • Data engineering\data pipeline experience, with hands on experience on integration tools such as Azure Databricks Notebooks, Azure Data Factory or PySpark. Python extremely beneficial.

About Royal London

We're the UK's largest mutual life, pensions, and investment company, offering protection, long-term savings and asset management products and services.   

Our People Promise to our colleagues is that we will all work somewhere inclusive, responsible, enjoyable and fulfilling. This is underpinned by our Spirit of Royal London values; Empowered, Trustworthy, Collaborate, Achieve. 

We've always been proud to reward employees by offering great workplace benefits such as 28 days annual leave in addition to bank holidays, an up to 14% employer matching pension scheme and private medical insurance. You can see all our benefits here - Our Benefits  

Inclusion, diversity and belonging. 

We're an Inclusive employer. We celebrate and value different backgrounds and cultures across Royal London. Our diverse people and perspectives give us a range of skills which are recognised and respected – whatever their background. 

  • Senior Modeller

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom AtkinsRéalis Full time

    Job DescriptionAtkinsRéalis is one of the largest engineering and design consultancies in the UK, one of the largest engineering and design consultancies in Europe and one of the largest design firms in the world.Our Networks and Drainage team is one of the largest in the UK with clients including high-profile utility companies, local authorities and...

  • Senior Modeller

    6 days ago

    Edinburgh, Edinburgh, United Kingdom AtkinsRéalis Full time

    Job DescriptionAtkinsRéalis is one of the largest engineering and design consultancies in the UK, one of the largest engineering and design consultancies in Europe and one of the largest design firms in the world.Our Networks and Drainage team is one of the largest in the UK with clients including high-profile utility companies, local authorities and...

  • Chief Data Scientist

    4 days ago

    Edinburgh, Edinburgh, United Kingdom Smart Data Foundry Full time

    About Smart Data FoundrySmart Data Foundry has a purpose to unlock the power of financial data as a force to improve people's lives.What we doWe enable the research ecosystem to flourish through the provision of research-ready real financial data.We create data-driven insights based on real financial data, that identify areas to inform policy change and...

  • Financial Modeller

    4 weeks ago

    Edinburgh, Edinburgh, United Kingdom Imultiply Resourcing Ltd Full time

    iMultiply are working in partnership with a leading Accountancy Firm based in Edinburgh to recruit for a Financial Modeller.The CompanyA leading Accountancy Firm based in the heart of Edinburgh that offers Audit, Tax and Advisory services to a wide-ranging client base across Scotland and beyond. The Firm has experienced considerable growth in recent times....

  • Senior Data Manager

    1 week ago

    Edinburgh, Edinburgh, United Kingdom Lloyds Banking Group Full time

    JOB TITLE: Senior Data Manager - CurationSALARY: £83,411 - £98,130LOCATION(S): Edinburgh, Halifax, LeedsHOURS: Full-timeWORKING PATTERN: Our work style is hybrid, which involves spending at least two days per week, or 40% of our time, at one of our office sites.About this opportunityRisk Division is central to Lloyds Banking Group and data is a key enabler...

  • Model Risk Manager

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom NatWest Full time

    Join us as a Model Risk ManagerIf you can demonstrate good knowledge of model risk and the controls environment and are passionate about driving effective risk management practices, then this could be the ideal role for youYou'll be applying decision making capability, anticipating and assessing the potential impacts of risk across the business, supporting...

  • Senior Data Manager

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom Lloyds Banking Group Full time

    End DateMonday 24 March 2025Salary Range£0 - £0We support flexible working – click here for more information on flexible working optionsFlexible Working OptionsHybrid Working, Job ShareJob Description Summary.Job DescriptionJOB TITLE: Senior Data Manager - CurationSALARY: £83,411 - £98,130LOCATION(S): Edinburgh, Halifax, LeedsHOURS: Full-timeWORKING...

  • Senior Data Manager

    1 week ago

    Edinburgh, Edinburgh, United Kingdom Lloyds Banking Group Full time

    End DateMonday 24 March 2025Salary Range£0 - £0We support flexible working – click here for more information on flexible working optionsFlexible Working OptionsHybrid Working, Job ShareJob Description Summary.Job DescriptionJOB TITLE: Senior Data Manager - CurationSALARY: £83,411 - £98,130LOCATION(S): Edinburgh, Halifax, LeedsHOURS: Full-timeWORKING...

  • Data Architect

    2 days ago

    Edinburgh, Edinburgh, United Kingdom Blue Astral Consulting Full time

    We have a great opportunity with our client, a rapidly expanding healthcare provider renowned for its specialisation in the care home sector. Currently overseeing the management of approximately 250 care homes and a select number of hospitals across the United Kingdom, our client stands at the forefront of innovation and excellence.The successful individuals...

  • Urban Drainage Modellers

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom AtkinsRéalis Full time

    Job DescriptionCardiff, Belfast, Birmingham, Bristol, Derby, Edinburgh, Epsom, Glasgow, Leeds, Liverpool, Manchester, Newcastle, Peterborough, Sheffield. Work with AtkinsRéalis to make the world's outlook brighter and healthier.You might know us for the great work we do across our wide variety of projects. We're proud to say it's thanks to our people's...

  • Energy Systems Modelling Engineer

    4 weeks ago

    Edinburgh, Edinburgh, United Kingdom Green Cat Hydrogen Ltd Full time

    Please note Green Cat Hydrogen are unable to offer any form of visa sponsorship.Green Cat Hydrogen Limited, Job Advertisement – Energy Systems Modelling EngineerJob Title: Energy Systems Modelling EngineerTerm: Full time employmentSalary: On application and dependent on experienceLocation: Glasgow (80 St Vincent Street) or Edinburgh (Stobo House,...

  • Energy Systems Modelling Engineer

    3 weeks ago

    Edinburgh, Edinburgh, United Kingdom Green Cat Hydrogen Ltd Full time

    Please note Green Cat Hydrogen are unable to offer any form of visa sponsorship.Green Cat Hydrogen Limited, Job Advertisement – Energy Systems Modelling EngineerJob Title: Energy Systems Modelling EngineerTerm: Full time employmentSalary: On application and dependent on experienceLocation: Glasgow (80 St Vincent Street) or Edinburgh (Stobo House,...

  • Senior Data Manager

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom Lloyds Banking Group Full time

    End DateSunday 23 March 2025Salary Range£80,206 - £94,360We support flexible working – click here for more information on flexible working optionsFlexible Working OptionsHybrid Working, Job ShareJob Description SummaryRisk Division is central to Lloyds Banking Group and data is a key enabler in satisfying the needs of our internal and external customers....

  • Senior Data Engineer

    4 weeks ago

    Edinburgh, Edinburgh, United Kingdom Peaple Talent Full time

    Senior Data Engineer Fabric | Edinburgh | £60,000 - £70,000 Peaple Talent have partnered with a specialist data consultancy delivering services across data engineering, data strategy, data migration, BI & analytics. As a trusted Microsoft Partner, my client are leaders in the industry, with a diverse portfolio of clients and projects.Due to exciting growth...

  • Data Scientist

    3 weeks ago

    Edinburgh, Edinburgh, United Kingdom MBN Solutions Full time

    Data ScientistUp to £80,000 + 10% Pension + BenefitsEdinburgh | HybridJoin a Growing Data Science Team in Financial ServicesMBN Solutions is excited to be working with a leading UK financial institution as they establish a brand-new data team in the UK. As part of this expansion, they are hiring two Data Scientists to play a key role in designing and...

  • Data Scientist

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom MBN Solutions Full time

    Data ScientistUp to £80,000 + 10% Pension + BenefitsEdinburgh | HybridJoin a Growing Data Science Team in Financial ServicesMBN Solutions is excited to be working with a leading UK financial institution as they establish a brand-new data team in the UK. As part of this expansion, they are hiring two Data Scientists to play a key role in designing and...

  • Data Scientist

    4 days ago

    Edinburgh, Edinburgh, United Kingdom MBN Solutions Full time

    Data Scientist - Edinburgh (hybrid)Up to £80,000 + 10% Pension + BenefitsEdinburgh | HybridJoin a Growing Data Science Team in Financial ServicesMBN Solutions is excited to be working with a leading UK financial institution as they establish a brand-new data team in the UK. As part of this expansion, they are hiring two Data Scientists to play a key role in...

  • Model Risk Governance Analyst

    2 days ago

    Edinburgh, Edinburgh, United Kingdom NatWest Full time

    Join us as a Model Risk Governance AnalystIn this key role, you'll support the management and continuous improvement of model risk governance across NatWest BoxedWe'll look to you to support the creation and maintenance of policy, standards and procedures for model risk management which are aligned to internal and external requirementsYou'll work with...

  • Hydraulic/Wastewater Modeller

    2 weeks ago

    Edinburgh, Edinburgh, United Kingdom Waterman Aspen Remote Work Freelance Full time

    Cont, Perm, SalHydraulic/Wastewater Modeller UK wide Type: Contract, Permanent, SalariedAn introduction to our unique company Waterman Aspen welcomes engineers and technical specialists to make their mark by working on some of the biggest infrastructure projects or in delivering professional services across the UK on a secondment basis. Our diverse client...

  • Hydraulic/Wastewater Modeller

    6 days ago

    Edinburgh, Edinburgh, United Kingdom Waterman Aspen Remote Work Freelance Full time

    Cont, Perm, SalHydraulic/Wastewater Modeller UK wide Type: Contract, Permanent, SalariedAn introduction to our unique company Waterman Aspen welcomes engineers and technical specialists to make their mark by working on some of the biggest infrastructure projects or in delivering professional services across the UK on a secondment basis. Our diverse client...