Data Modeller / Architect - Outside IR35

Data Modeller / Architect

Length: 6 months

Location: Hybrid - 2 days per week in London

IR35 Status: Outside

Urgent requirement for a Data Modeller / Architect to join a leading insurance company. The role will focus on reviewing the current state of our data mart models & architecture, defining standards & guardrails then working with federated areas to ensure adherence to these. The resource will spearhead the community of data modellers across the business to drive consistency in our modelling strategy, reducing inefficiencies and enabling simpler structures to drive quicker time to insights across the business.

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

Carbon60, Lorien & SRG - The Impellam Group STEM Portfolio are acting as an Employment Business in relation to this vacancy.