Find a job 
Featured Companies 
Featured Universities 
For Companies 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: Competitive salary, 25 days holiday, bonus scheme, and professional development support.
- Other info: Enjoy a supportive environment with opportunities for career growth and learning.
- Why this job: Make a real impact in the insurance sector with innovative data solutions.
- Qualifications: Experience in T-SQL, SSIS, SSAS, and PowerBI is essential.
The predicted salary is between 50000 - 60000 £ 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
- Business Intelligence Team
- 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.
- 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 reports
- PowerBI Report Development
- 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
- PowerBI Administration and/or support
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 SQL Developer in London employer: Starr International
Contact Detail:
Starr International Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior SQL Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work at Lloyds or in similar roles. A friendly chat can sometimes lead to job opportunities that aren't even advertised.
✨Tip Number 2
Prepare for interviews by practising common SQL-related questions and scenarios. We recommend setting up mock interviews with friends or using online platforms to get comfortable with the format and types of questions you might face.
✨Tip Number 3
Showcase your skills! Create a portfolio of your best BI reporting solutions and SQL projects. This will not only impress potential employers but also give you a chance to discuss your work in detail during interviews.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Senior SQL Developer in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior SQL Developer role. Highlight your T-SQL development experience and any relevant BI projects you've worked on. We want to see how your skills match what we're looking for!
Showcase Your Projects: Include specific examples of your work with MS SQL Server, SSIS, and PowerBI. We love seeing real-world applications of your skills, so don’t hold back on sharing your achievements in BI reporting solutions.
Be Clear and Concise: When writing your application, keep it clear and to the point. Use bullet points where possible to make it easy for us to read through your experience and qualifications. We appreciate a well-structured application!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Starr International
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills, especially with MS SQL Server 2019 and beyond. Be prepared to discuss your experience with ETL processes using SSIS and how you've tackled complex reporting with SSRS. They’ll likely want to see your problem-solving skills in action!
✨Showcase Your BI Knowledge
Familiarise yourself with the BI tools mentioned in the job description, like PowerBI and SSAS. Be ready to share examples of how you've used these tools to deliver impactful reporting solutions. Highlight any experience you have with data warehousing and dimensional modelling as well.
✨Understand the Business Context
Since this role is within the insurance sector, it’s a good idea to do some research on Lloyds and the specific challenges they face. Being able to speak knowledgeably about the industry will show that you’re not just technically skilled but also understand the business needs.
✨Prepare Questions for Them
Interviews are a two-way street! Prepare thoughtful questions about the Central BI Team's current projects or future strategies. This shows your genuine interest in the role and helps you assess if the company is the right fit for you.