Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support and enhance BI reporting solutions while collaborating with various business teams.
- Company: Join the UK's largest specialist motor insurer with a strong reputation since 1946.
- Benefits: Enjoy competitive salary, generous holiday, bonuses, and professional development support.
- Other info: Be part of a supportive team focused on continuous improvement and innovation.
- Why this job: Make a real impact in a dynamic environment while advancing your career in BI.
- Qualifications: Experience in T-SQL, SSIS, SSAS, and SSRS is essential; insurance knowledge is a plus.
The predicted salary is between 50000 - 60000 £ per year.
About us 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 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 Swansea employer: Starr
Contact Detail:
Starr Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior SQL Developer in Swansea
✨Tip Number 1
Network like a pro! Reach out to current employees at ERS Syndicate or in the BI field on LinkedIn. A friendly chat can give you insider info and might just get your foot in the door.
✨Tip Number 2
Show off your skills! Prepare a portfolio of your best SQL projects or BI reports. When you land that interview, having tangible examples will make you stand out from the crowd.
✨Tip Number 3
Be ready for technical questions! Brush up on T-SQL, SSIS, and PowerBI. Practising common interview questions can help you feel more confident and ready to impress.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the team at ERS Syndicate.
We think you need these skills to ace Senior SQL Developer in Swansea
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 and the impact they had.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about the role and how you can contribute to our Central BI Team. Keep it engaging and personal – we want to get to know you!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets to us quickly and efficiently. Plus, you’ll find all the details you need about the role there!
How to prepare for a job interview at Starr
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills, especially with MS SQL Server 2019. Be prepared to discuss your experience with ETL processes and how you've used SSIS, SSAS, and SSRS in past projects. They’ll likely want to see how you can apply these skills to enhance their BI reporting solutions.
✨Showcase Your Problem-Solving Skills
Be ready to share specific examples of how you've tackled complex data issues in the past. Think about times when you had to troubleshoot ETL processes or improve data quality. This will demonstrate your analytical maturity and ability to contribute to the team’s objectives.
✨Understand the Business Context
Familiarise yourself with the insurance sector, particularly Lloyds Syndicate operations. Knowing how underwriting and claims work will help you relate your technical skills to their business needs, making you a more attractive candidate.
✨Prepare Questions for Them
Interviews are a two-way street! Prepare insightful questions about their BI strategy and how they envision the role evolving. This shows your genuine interest in the position and helps you assess if it’s the right fit for you.