At a Glance
- Tasks: Design and develop data models for innovative pricing solutions in the insurance sector.
- Company: Global recruitment specialist with a focus on cutting-edge data solutions.
- Benefits: Competitive pay rate, flexible working days, and opportunities for professional growth.
- Other info: Exciting opportunity to work in a collaborative environment with excellent career prospects.
- Why this job: Join a dynamic team and shape the future of data in the insurance industry.
- Qualifications: Strong data modelling skills and experience with Azure Databricks preferred.
The predicted salary is between 63000 - 77000 £ per year.
We are a Global Recruitment specialist that provides support to the clients across EMEA, APAC, US and Canada. We have an excellent job opportunity for you.
- Role Title: SL Transformation- Data Designer
- 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
- **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 Py Spark 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.
- **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.
Data Modeler in City of London employer: eTeam
As a Global Recruitment specialist, we pride ourselves on fostering a collaborative and innovative work culture in Manchester, where our Service Designers can thrive. With a focus on employee growth, we offer opportunities for professional development and the chance to work on impactful projects across diverse regions. Our commitment to work-life balance, with a flexible onsite schedule, ensures that our team members can excel both personally and professionally.
StudySmarter Expert Advice🤫
We think this is how you could land Data Modeler in City of London
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like eTeam before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like eTeam.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like eTeam.
We think you need these skills to ace Data Modeler in City of London
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at eTeam, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to eTeam, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab eTeam’s attention and show the tangible impact of your work.
How to prepare for a job interview at eTeam
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at eTeam.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at eTeam.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at eTeam.