Data Modeller

6 months ago


Leeds, United Kingdom Direct Line Group Full time

**About us**

Fuelled by our passion for using data to solve customer problems, we’re working to be the top-tier data-driven organisation in the UK’s General Insurance market. With Analysts, Engineers and Developers working together in an agile environment, our Data Enabling Tribe is at the heart of our mission. Building a new, enterprise-scale, cloud-hosted, secure and trusted analytics platform, we’re using the economics of big data, cloud elasticity, machine learning and AI automation. And we’re turning information into business insights to provide even greater customer support.

**The Data Chapter**

Our team is at the heart of this mission, and we are looking for people passionate about using data to solve customer problems and making the organisation data driven. We are working with our teams to build our new enterprise-scale, cloud hosted, secure and trusted analytics platform. The platform uses the economics of big data, cloud elasticity, machine learning (ML)/Artificial Intelligence (AI) automation and to turn information into business insights so that we can support our customers better.

**Who you’ll be working with**

You will be working closely with data engineers, analysts, and other stakeholders to understand their data requirements and provide the necessary data infrastructure and support. You will be reporting into Data Chapter Lead.

**What you’ll need**:

- Experience in insurance domain
- Experience with data modelling (star, snowflake, etc schemas) and performance optimisation of data tables
- Experience with data warehousing solutions (e.g., Redshift, Snowflake) and data lake architecture.
- Proficiency in data modelling tools and languages (e.g., ERwin, ErStudio, UML, SQL, etc.).
- Experience with working with internal customers to understand their use cases and ensure architecture conforms to their needs.
- Experience with both analytical and transactional processing databases
- Experience building enterprise grade data pipelines (ETL and ELT)
- Experience with Cloud-native data services, such as AWS Athena, Redshift,
- Strong knowledge of database management systems, including SQL, PL/SQL, and NoSQL databases.
- Experience with Data Architecture around GDPR compliance
- Experience on an Agile Environment, familiarity with Jira, Confluence and Git
- Experience interlocking with a Data Governance programme of work.
- Technical knowledge on dbt and Airflow
- Strong problem-solving skills, attention to detail, and the ability to work in a fast-paced, collaborative environment.
- Excellent communication and teamwork skills, with the ability to explain complex technical concepts to non-technical stakeholders.

**What you'll be doing**:
As a Senior Data Modeller you will be responsible for the below:
**Data Modelling**: Develop, maintain, and enhance data models using industry-standard tools such as Erwin, ER/Studio, or similar, to support various data domains, including policyholder information, claims data, underwriting data, and financial data.

**Requirements Analysis**: Collaborate with business analysts and stakeholders to understand data requirements, business objectives, and user needs. Translate these into effective data models using data modelling languages and techniques (e.g., UML, Entity-Relationship Diagrams)

**Data Architecture**: Contribute to the design and implementation of a robust data architecture utilizing database management systems

**Database Development**: Work with Data engineers to implement data models in the company's database management systems, using dbt and schedule via Airflow

**Performance Optimization**: Monitor and optimize data models for query performance, using tools like SQL Profilers and performance tuning techniques.

**Data Governance**: Ensure that data models adhere to industry best practices and standards, promoting data governance within the organization, and using data modelling tools for version control and documentation.

**Documentation**: Maintain comprehensive documentation of data models, data dictionaries, and data lineage for reference and future development, utilizing documentation and collaboration platforms like Confluence

**Collaboration**: Champion and collaborate with cross-functional teams, including data engineers, data analysts, and business stakeholders, to drive data projects to successful completion, using collaboration tools like JIRA/Teams.

**What we’ll give you in return**:
We wouldn’t be where we are today without our people and the wide variety of perspectives and life experiences they bring. That’s why we offer excellent benefits to suit your lifestyle and a flexible working model combining the best parts of home and office-working, varying with the nature of your role. Core benefits include:

- 9% employer contributed pension
- 50% off home, motor and pet insurance plus free travel insurance and Green Flag breakdown cover
- Up to 10% annual bonus
- 25 days holiday (rising by 1 each year to 28)



  • Leeds, Leeds, United Kingdom Lloyds Banking Group Full time

    About this opportunityThis is an exciting chance to be part of the Model Risk and Validation team within Lloyds Banking Group.The team covers valuation models for Lloyds Banking Group, with a focus on pricing models for derivative instruments.As a Data Modeling Quantitative Analyst, you'll work in an independent code library using C++ or Python to develop...


  • Leeds, Leeds, United Kingdom Leeds Building Society Full time

    Join a dynamic team at Leeds Building Society as a SQL Data Modeler and ETL Developer.We are seeking an experienced professional to focus on SQL data modeling and ETL development into the Data Warehouse.This role is perfect for an individual with advanced SQL skills and knowledge of modern RDBMS.You will be responsible for requirements gathering and must...


  • Leeds, United Kingdom ASDA Full time

    About the RoleWe are seeking a skilled Data Engineer to join our team at ASDA Head Office. This role offers an exciting opportunity to work with complex data science models and deliver business value across various key processes.Key Responsibilities:Collaborate with our data team to develop and implement data-driven solutions that drive business growth and...


  • Leeds, Leeds, United Kingdom MERJE Full time

    MERJE is partnering with a leading Building Society to find a talented Financial Modelling Manager.We are excited to announce an opportunity for a Lead Manager - Financial Modelling (Asset & Liability Management) to join our team in Financial Modelling.In this role, you will lead the review and redevelopment of Asset and Liability Management (ALM) models to...

  • Wastewater Modeller

    2 months ago


    Leeds, United Kingdom CV-Library Full time

    Wastewater Modeller Leeds Salary up to £45k We are currently in the market to recruit multiple Wastewater (Hydraulic) Modellers / Catchment Planners for a variety of major long-term frameworks across the UK for an industry leading Consultancy. In addition to a range of long-term programmes across the UK water industry, our client have successfully...


  • Leeds, Leeds, United Kingdom MERJE Ltd Full time

    MERJE are excited to partner with a leading Building Society in their search for a talented Financial Modelling Manager.This role offers a unique opportunity for a Lead Manager - Financial Modelling to join our team and lead the review and redevelopment of Asset and Liability Management (ALM) models.Key responsibilities include:Embedding the ALM Model suite...


  • Leeds, United Kingdom CV-Library Full time

    MERJE are delighted to be partnered with a leading Building Society in their search for a talented Financial Modelling Manager.  Are you a passionate about making a difference, using your technical skills collaboratively to deliver real change? If so, then this may have the role for you! We are thrilled to announce an incredible opportunity for...


  • Leeds, Leeds, United Kingdom Yorkshire Building Society Group Full time

    We are excited to announce an opportunity for a Financial Modelling Expert to join our team in Finance Modelling at the Yorkshire Building Society Group.The role is based in Leeds, UK and requires a minimum of one day a week onsite presence in our central office.Job Description:In this role, you will design, develop and deliver new models or model...


  • Leeds, Leeds, United Kingdom MERJE Ltd Full time

    We're excited to partner with a leading Building Society to find a skilled Financial Modelling Manager.This role involves leading the review and redevelopment of Asset and Liability Management (ALM) models to meet the requirements of the ALM team and internal governance processes.The successful candidate will design, develop, and maintain key ALM models and...


  • Leeds, Leeds, United Kingdom InterQuest Group Full time

    Risk Modelling ExpertWe are seeking a highly skilled Senior Analytics Consultant to join our client's team as a Senior Analyst. In this role, you will be responsible for developing and maintaining credit risk decision models using SAS, R, and Python.Main Responsibilities:Model Deployment: Deploy credit risk decision models to support lending decisions,...


  • Leeds, United Kingdom MERJE Full time

    MERJE are delighted to be partnered with a leading Building Society in their search for a talented Financial Modelling Manager. Are you a passionate about making a difference, using your technical skills collaboratively to deliver real change? If so, then this may have the role for you!We are thrilled to announce an incredible opportunity for a Lead...


  • Leeds, Leeds, United Kingdom Direct Line Group Full time

    Key AccountabilitiesPricing and Underwriting Support* Work closely with other areas of pricing and underwriting to set risk prices across Direct Line Group, and manage and maintain the geographic risk models, data, and associated intelligence.Project Delivery* Support prioritised projects within pricing and underwriting as required, focusing on projects...


  • Leeds, United Kingdom Merje Full time

    MERJE are delighted to be partnered with a leading Building Society in their search for a talented Financial Modelling Manager. Are you a passionate about making a difference, using your technical skills collaboratively to deliver real change? If so, then this may have the role for you! We are thrilled to announce an incredible opportunity for a Lead...


  • Leeds, United Kingdom Direct Line Group Full time

    Key Accountabilities Work with other areas of pricing and underwriting and the wider business to set both risk prices across Direct Line Group and manage and maintain the geographic risk models, data and associated intelligence. Support prioritised projects within pricing and underwriting as required, focusing on projects involving use of GIS technology...


  • Leeds, United Kingdom MERJE Full time

    MERJE are delighted to be partnered with a leading Building Society in their search for a talented Financial Modelling Manager. Are you a passionate about making a difference, using your technical skills collaboratively to deliver real change? If so, then this may have the role for you!We are thrilled to announce an incredible opportunity for a Lead...

  • Data Scientist

    2 weeks ago


    Leeds, Leeds, United Kingdom Direct Line Group Full time

    About Direct Line GroupWe are a customer-obsessed market powerhouse, combining decades of industry experience with talented people in every field. Our vision is to be an insurance company of the future.Job DescriptionAs a Data Scientist - Pricing Model Developer, you will contribute to the development of the pricing strategy for Personal Lines through...


  • Leeds, Leeds, United Kingdom MERJE Ltd Full time

    We are seeking a highly skilled Financial Modelling Manager to join our team in the Building Society. In this role, you will lead the review and redevelopment of Asset and Liability Management (ALM) models to meet the requirements of the ALM team and the internal governance processes, while supporting the team with their wider deliverables.Key...


  • Leeds, Leeds, United Kingdom SmartResilience Full time

    Lead Physical Risk ModellerAt SmartResilience, we empower organisations to mitigate and adapt to the growing challenges posed by climate change. Our climate risk and resilience technology services deliver climate strategies, risk management frameworks, and solutions that reduce the cost of damages and business interruptions.We collaborate with prominent FTSE...

  • Wastewater Modeller

    3 weeks ago


    Leeds, United Kingdom Calibre Search Full time

    Wastewater ModellerLeedsSalary up to £45kWe are currently in the market to recruit multiple Wastewater (Hydraulic) Modellers / Catchment Planners for a variety of major long-term frameworks across the UK for an industry leading Consultancy.In addition to a range of long-term programmes across the UK water industry, our client have successfully won a £100...


  • Leeds, Leeds, United Kingdom Direct Line Group Full time

    Actuarial Pricing Analyst Role DescriptionAbout Direct Line Group:We are a leading insurance company with a strong focus on customer satisfaction. Our team is committed to delivering exceptional results, and we're looking for talented individuals to join us in shaping the future of insurance.The Role:We are seeking an Actuarial Pricing Analyst to join our...