Summary: Urgent requirement for a Data Modeller / Architect to join a leading insurance company, focusing on reviewing and optimizing data mart models and architecture. The role involves defining standards and ensuring adherence across federated areas while leading a community of data modellers to enhance consistency and efficiency. The position is hybrid, requiring two days per week in London, and is classified as outside IR35.

Key Responsibilities:

• Review existing domain data mart models/architecture to ensure that they meet the needs of our data strategy and are optimised to support our key analytical use cases.
• Design and develop remediated designs/models and work with engineering and analytical stakeholders across the different domains to create backlogs for model standardisation and improvements.
• Ensure storage and consumption approaches/designs deliver maximum efficiency, with a focus on balancing storage and compute costs optimally.
• Produce and maintain modelling and design guardrails, standards and processes and integrate these with wider data management and engineering governance.

Key Skills:

• Data design patterns and optimisation across disparate mediums within a Cloud-based environment (preferably AWS) such as data warehouses, redshift, and lake house architecture.
• A strategic thinker who can define modelling patterns for various layers of a data environment balancing storage vs. compute costs, optimised for as broad a set of use cases as possible.
• Extensive data modelling experience, from conceptual to physical.
• Expertise in different modelling methodologies such as 3NF, Dimensional, Data Vault.
• Expertise in building cloud data warehouses using Kimball, preferably using AWS Redshift.
• Knowledge/experience of building queries and MI outcomes utilising data visualisation technologies (e.g., Tableau).
• Qualifications in RDMBS design and/or administration and in AWS architecture (at least one of these).
• Awareness of data governance and data ethics in the production of automated modelling.
• Proven track record of delivery of modelling designs/approaches in large scale data environments.
• Evidence of broad stakeholder management from senior business level down to analyst.
• Experience in, or extensive exposure to MI/BI use cases, data exploration and analysis. Experience within predictive modelling/Data Science would be an advantage.
• Experience in defining and delivering data monitoring across a large platform as well as establishing governance forums, processes and guardrails to ensure compliance with standards.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT