How your CV stacks up
Upload your CV to see how well it fits this job role
?%
SL Transformation- Data Designer
Location: London
Duration: 31/12/2026
Sector: Insurance
Days on site: 2-3
Pay Rate: £438 per day all inc. (PAYE through Umbrella)
Role Description:
The role will be responsible for designing conceptual, logical, and physical data models that support business pricing capabilities and analytical use cases. The successful candidate will work within a Medallion Architecture (Bronze, Silver, Gold) implemented on Azure Databricks and Azure Data Factory, ensuring data products are scalable, governed, reusable, and aligned to enterprise standards.
Key Responsibilities
Data Modelling & Design
- Lead the development and maintenance of enterprise conceptual, logical, and physical data models for Pricing Data Products.
- Establish and promote data modelling standards, patterns, and best practices across the programme.
- Own modelling artefacts and ensure consistency, quality, traceability, and compliance with enterprise data architecture principles.
- Define business entities, relationships, hierarchies, reference data structures, and business rules across pricing and insurance domains.
- Provide expert guidance on modelling approaches, including 3NF, dimensional, canonical, and domain-oriented data models.
- Review and approve modelling deliverables produced by designers and engineering teams.
- Mentor junior data modellers and contribute to capability development within the data community.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Data Product Design
- Design data structures across bronze, silver, and gold layers within a Medallion Architecture.
- Define reusable data assets and data products that support pricing, commercial, and financial reporting use cases.
- Ensure data products support scalability, performance, data quality, and lineage requirements.
- Collaborate with Product Owners and Data Architects to align data models with business outcomes.
Azure Databricks & Data Engineering Collaboration
- Work closely with Data Engineers to implement data models using Azure Databricks and Delta Lake.
- Create transformation logic specifications suitable for PySpark implementation.
- Review data pipelines and transformations to ensure compliance with approved data models.
- Support optimization of data structures for performance and analytical consumption.
Data Governance & Quality
- Define data quality rules, validation checks, and reconciliation requirements.
- Ensure metadata, lineage, and business glossaries are maintained.
- Support data governance frameworks and master/reference data standards.
- Contribute to data catalogue and metadata management activities.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Required Skills
- Strong experience in conceptual, logical, and physical data modelling.
- Experience designing enterprise-scale data products and analytical data models.
- Proficiency with data modelling methodologies and best practices.
- Experience creating source-to-target mappings and transformation specifications.
- Excellent communication and stakeholder management skills.
- Experience with data governance and metadata management tools.
- Advanced SQL skills.
- Understanding of data profiling, reconciliation, and validation techniques.
- Experience analysing complex datasets and resolving data quality issues.
- Good understanding of Medallion Architecture.
- Good understanding of Data Mesh principles.
- Good understanding of Lakehouse architectures.
- Good understanding of Master and Reference Data Management.
- Good understanding of Data Governance frameworks.
- Experience with data modelling tools (ERwin, ER/Studio, etc.).
- Understanding of Azure Data Services, Databricks, and ADF is desirable.
- Past insurance data domains experience is desirable.
If you are interested in this position and would like to learn more, please send through your CV and we will get in touch with you as soon as possible. Please note, candidates are often Shortlisted within 48 hours.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location