At a Glance
- Tasks: Design and maintain scalable data solutions for motor insurance risk assessment and pricing.
- Company: Join a leading insurance company focused on innovation and data-driven decision making.
- Benefits: Enjoy hybrid working, generous leave, bonuses, and exclusive discounts.
- Other info: Collaborative environment with opportunities for mentorship and career growth.
- Why this job: Make a real impact in the insurance industry with cutting-edge data engineering.
- Qualifications: Proficient in SQL and Python, with experience in cloud platforms and data orchestration tools.
The predicted salary is between 55000 - 65000 £ per year.
Data Engineer
Department
[SBISL] Data Engineering
Employment Type
Permanent - Full Time
Location
Bristol
Compensation
- Description
- SBG are currently seeking a
Data Engineer to support the underwriting function by designing, building and maintaining scalable data solutions that enhance risk assessment, pricing accuracy and operational efficiency across the motor insurance portfolio.
The role combines hands-on data engineering expertise with developing leadership capability and strong underwriting domain knowledge, helping to drive the evolution of data and analytics capabilities across the business.
Working closely with Underwriting, Pricing, Data Science and Technology teams, the Data Engineer will deliver reliable, high-quality data products that enable data-driven decision making, improve portfolio performance and support strategic business objectives.
What you’ll be responsible for
- Design, develop and maintain scalable data pipelines, platforms and data assets that support underwriting models, pricing capabilities and portfolio risk analytics.
- Manage and enhance existing production data assets while delivering new data products to meet evolving analytical and business requirements.
- Drive high standards of data quality, integrity and governance through the implementation of automated validation, cleansing, monitoring and anomaly detection processes.
- Integrate, transform and harmonise data from a wide range of internal and external sources, including policy, claims, telematics and third-party datasets, to create reliable and analytics-ready data solutions.
- Develop and maintain data marts, reporting layers and semantic models that provide actionable insights into underwriting performance, loss ratios, portfolio health and key business metrics.
- Apply data architecture principles, data modelling standards and engineering best practices to ensure solutions are scalable, secure and fit for purpose.
- Collaborate closely with Underwriting, Pricing and wider business stakeholders to understand data requirements and translate complex business challenges into effective data solutions.
- Define, monitor and continuously improve key performance metrics to support data-driven decision making and business performance management.
- Contribute to the development and evolution of the organisation's data engineering capability, promoting consistency, innovation and continuous improvement across the data estate.
- Mentor and support junior team members, providing guidance, knowledge sharing and code or design reviews to maintain high standards of quality, performance and reliability.
- Participate in Agile delivery processes, including sprint planning, backlog refinement, estimation and retrospectives, ensuring data engineering priorities are aligned to business and strategic objectives.
- Work cross-functionally with Data Science, Analytics, Technology and Business teams to deliver robust, scalable and value-driven data solutions that support organisational growth and performance.
What you’ll need
- Strong proficiency in SQL and Python, with the ability to develop robust data solutions, automate processes and support advanced analytical requirements.
- Experience working with cloud-based data platforms, ideally Microsoft Azure, with exposure to AWS or Google Cloud Platform considered advantageous.
- Knowledge of data orchestration and workflow management tools, such as Azure Data Factory, to support the efficient movement and transformation of data.
- Strong understanding of data warehousing concepts, data architecture principles and dimensional data modelling techniques.
- Experience implementing and supporting CI/CD practices, version control frameworks and collaborative development methodologies, including Git.
- Proven experience working with Databricks, including data ingestion, transformation and optimisation of large-scale data processing workloads.
- Understanding of data governance, metadata management and data quality frameworks, including experience with tools such as Great Expectations or similar data validation solutions.
- Knowledge of Unity Catalog, including data lineage, permissions management, governance controls and data asset tagging.
- Strong analytical and problem-solving skills, with the ability to translate complex business requirements into scalable data solutions.
- Understanding of Generalised Linear Models (GLMs) and Gradient Boosting Models (GBMs), including the data and feature requirements associated with insurance pricing models.
- Knowledge of insurance products, underwriting processes and motor insurance data would be advantageous.
- Ability to communicate complex technical concepts effectively to both technical and non-technical stakeholders.
- Experience working in Agile delivery environments, collaborating with cross-functional teams to deliver high-quality data products and solutions.
- Strong attention to detail, commitment to data accuracy and a proactive approach to continuous improvement.
- Our Benefits
- Hybrid working – 2 days in the office and 3 days working from home
- 25 days annual leave, rising to 27 days over 2 years’ service and 30 days after 5 years’ service. Plus bank holidays!
- Discretionary annual bonus
- Pension scheme – 5% employee, 6% employer
- Flexible working – we will always consider applications for those who require less than the advertised hours
- Flexi-time
- Healthcare Cash Plan – claim cashback on a variety of everyday healthcare costs
- Electric vehicle – salary sacrifice scheme
- 100’s of exclusive retailer discounts
- Professional wellbeing, health & fitness app - Wrkit
- Enhanced parental leave, including time off for IVF appointments
- Religious bank holidays – if you don’t celebrate Christmas and Easter, you can use these annual leave days on other occasions throughout the year.
- Life Assurance - 4 times your salary
- 25% Car Insurance Discount
- 20% Travel Insurance Discount
- Cycle to Work Scheme
- Employee Referral Scheme
- Community support day
- #J-18808-Ljbffr
Data Engineer employer: Somerset Bridge
Join a forward-thinking company in Bristol that values innovation and employee growth, offering a dynamic work culture where data-driven decisions shape the future. As a Senior Analyst in the Data Enrichment team, you'll enjoy hybrid working, generous annual leave, and a range of benefits including a healthcare cash plan and enhanced parental leave, all while contributing to impactful projects that enhance commercial performance and customer value.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Somerset Bridge!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Somerset Bridge.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Somerset Bridge.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Somerset Bridge, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Somerset Bridge, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Somerset Bridge. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Somerset Bridge
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Somerset Bridge!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
