Data Modeller

Project overview

Data Modeller

Requirements

• At least five years of data modelling experience in large or complex organisations.
• Demonstrable experience creating conceptual, logical and physical data models.
• Strong practical understanding of relational modelling and third normal form (3NF).
• Practical dimensional modelling experience, including facts, dimensions, conformed dimensions, surrogate keys, slowly changing dimensions and clearly defined grain.
• Hands-on Data Vault 2.0 modelling experience, including raw vault and business vault patterns.
• Experience designing integrated and historised data structures that support multiple downstream consumers.
• Experience with metadata-driven or automated data modelling and delivery processes, with appropriate governance, validation and human approval controls.
• Experience producing physical models and implementation-ready specifications for cloud data platforms and data warehouse technologies.
• Working knowledge of SQL, data definition language, data types, XML and JSON.
• Ability to analyse source structures, profile available data, identify business keys and assess data quality or completeness issues.
• Experience with source-to-target mapping, data lineage and end-to-end data flow documentation.
• Ability to communicate modelling decisions clearly to both technical and non-technical stakeholders.
• Ability to manage multiple priorities and work effectively in an environment of changing requirements and delivery constraints.

Nice to have

What's Next

If you are ready to take the next step, apply now! Successful applicants will be contacted directly by a recruiter to discuss the role more.

We are committed to creating an inclusive recruitment experience. If you require support or adjustments to the recruitment process, our Adjustment Concierge Service is here to help. Please feel free to contact us at (see below) to discuss how we can support you.

This position is being recruited on behalf of our client through our Outsourcing service line. Resource Solutions Limited, trading as Robert Walters, acts as an employment business and agency, partnering with top organizations to help them find the best talent. We welcome applications from all candidates and are committed to providing equal opportunities.

• Insurance industry data, including policy, coverage, claim, party, broker and organisation concepts.
• Industry-standard information models and open data standards, particularly the ACORD Information Model and messaging standards.
• Databricks or a comparable modern cloud lake house platform.
• Data modelling tools such as Erwin Data Modeler.
• Data governance, metadata management, master and reference data management, and enterprise data architecture.
• Python or similar Scripting experience used to validate metadata, automate repeatable modelling tasks or generate controlled technical artefacts.
• Agile delivery and collaboration with distributed engineering, architecture and business teams.

Project details

London

Contract: 6 months

Work Setup: 1-2 days per week, the rest remote working

Salary: £600.00 PAYE per day

Who We Are

Robert Walters is the world's most trusted talent solutions business. Across the globe, we deliver recruitment, outsourcing, and talent advisory services for businesses of all sizes, opening doors for people with diverse skills, ambitions, and backgrounds.

The Role

Our client is a professional services organisation providing business and operational support across various functions, helping ensure efficient processes, effective management and the smooth running of day-to-day activities.

The successful candidate will be a seasoned Data Modeller who can provide project-level data modelling expertise across operational, integration, analytical and reporting use cases. The role will work with business analysts, product owners, data engineers, architects and governance teams to define data requirements, model data structures and ensure that implemented solutions conform to agreed modelling standards and enterprise data principles.

It requires practical experience of modern cloud data ecosystems, layered Bronze, Silver and Gold architectures, and the appropriate use of relational, dimensional and Data Vault modelling techniques.

• Start: flexible
• Location: London, UK, GB