At a Glance
- Tasks: Support and enhance BI reporting solutions while collaborating with a dynamic team.
- Company: Join the UK's largest specialist motor insurer with a strong reputation.
- Benefits: Enjoy competitive salary, generous holiday, and professional development opportunities.
- Other info: Be part of a team that values continuous improvement and career growth.
- Why this job: Make a real impact in data quality and reporting within a supportive environment.
- Qualifications: Experience in T-SQL, ETL processes, and a degree or relevant experience.
The predicted salary is between 60000 - 75000 £ per year.
ERS Syndicate 218 at Lloyds is managed by Starr. We are the UK’s largest specialist motor insurer with an A+ rating and have been making motoring passions and livelihoods possible since 1946. We work exclusively with motor insurance brokers to help get under the skin of the most difficult insurance risks, helping build products to meet their customer’s needs.
Role Purpose
To support, improve and deliver high quality BI reporting solutions as part of the Central BI Team. Actively participate within the Central BI Team to help develop other team members and support the delivery of the team objectives. Perform operational support activities to ensure the Central BI solution meets the business SLA’s, including occasional OOH activities. Support the team lead in developing and managing future strategy decisions. Take ownership of key initiatives that enhance data quality, reporting capability and analytical maturity across the business.
Key responsibilities
- Contribute to daily support activities, ensuring scheduled processes are running correctly, consistently and any issues are raised for investigation and resolution in a timely manner.
- Conduct data analysis tasks, profiling work requests to scale effort and complexity, to feed into the team backlog for future development.
- Design and deliver data extraction processes from new and existing sources, to integrate into an established data warehouse.
- Maintain and enhance existing ETL processes, ensuring reliability, accuracy and performance, including fine tuning of stored procs, views, functions and queries as the underlying dataset grows.
- Contribute to the management and continuous improvement of BI technical environment to ensure expected service levels are met and known service issues are resolved.
- Participate in BI and business meetings and take ownership of relevant action points throughout the escalation process to achieve satisfactory results.
Wider BI Business Support
- Work directly with, but not limited to, the Underwriting, Claims, Finance and Central MI business representatives to identify and document business requirements.
- Provide technical support and guidance to the business teams to enable them to achieve their own reporting goals.
The above duties and responsibilities are not an exhaustive list, and you may be required to undertake other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.
Essential qualifications, skills and experience
- T-SQL Development (MS SQL Server 2019 onwards)
- MS Integration Services (SSIS) including development of full DW ETL Solutions
- MS Analysis Services (SSAS) for complex cube reporting solutions
- MS Reporting Services (SSRS) including development of complex report
- Kimball Dimensional Modelling Methodology
Experience of the following would also be advantageous to support potential future strategies:
- Fabric
- Microsoft Azure
Experience of the following systems would also be advantageous:
- Team Foundation Server
- Azure Dev Ops
Experience of the following business areas would be advantageous:
- Insurance sector (Lloyds Syndicate, Underwriting, Broking)
Qualifications:
- Degree educated in relevant field or long-standing technical experience
Benefits
- Competitive Benchmarked Salary
- 25 days holiday
- Discretionary bonus scheme
- Employee assistance programme
- Annual holiday buy (up to 3 extra days)
- Salary sacrifice benefits
- Annual benefits reviews
- The option for professional qualifications and study support
Senior Data Engineer employer: ERS Administration Services
At Lloyds, we pride ourselves on being the UK’s largest specialist motor insurer, offering a dynamic work environment that fosters collaboration and innovation. As a Senior Data Engineer, you will not only contribute to high-quality BI reporting solutions but also have access to professional development opportunities, competitive benefits, and a supportive culture that values employee growth. Join us in our mission to enhance data quality and analytical maturity while enjoying a generous holiday allowance and a discretionary bonus scheme.
Contact Details:
ERS Administration Services Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Senior 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 ERS Administration Services!
✨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 Senior Data Engineer at ERS Administration Services.
✨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 ERS Administration Services.
✨Apply Directly through Our Website
When you find a suitable opening like Senior Data Engineer at ERS Administration Services, 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 Senior 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 ERS Administration Services, 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 ERS Administration Services. 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 ERS Administration Services
✨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 ERS Administration Services!
✨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.
