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 ERS Syndicate 218, the UK's largest specialist motor insurer.
- Benefits: Enjoy 25 days holiday, bonuses, and professional development support.
- Why this job: Make a real impact in the insurance sector with cutting-edge BI technologies.
- Qualifications: Experience in T-SQL, ETL processes, and a passion for data analysis.
- Other info: Great career growth opportunities in a supportive and innovative environment.
The predicted salary is between 45000 - 55000 £ per year.
Responsibilities:
- Actively support, improve and deliver high quality BI reporting solutions as part of the Central BI Team.
- Actively participate in the team to help develop other members and support delivery of the team objectives.
- Perform operational support activities to ensure the Central BI solution meets business SLAs, including occasional out-of-hours 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.
- Contribute to daily support activities, ensuring scheduled processes run correctly, consistently, and that any issues are raised for investigation and resolution in a timely manner.
- Conduct data analysis tasks, profile 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 procedures, views, functions and queries as the underlying dataset grows.
- Contribute to the management and continuous improvement of the 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.
Business Support:
- Work directly with, but not limited to, 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.
Technical Skills:
- T-SQL Development (MS SQL Server 2019 onwards)
- MS Integration Services (SSIS) – development of full DW ETL solutions
- MS Analysis Services (SSAS) – complex cube reporting solutions
- MS Reporting Services (SSRS) – development of complex reports
- Power BI Report Development
- Kimball Dimensional Modelling Methodology
Preferred Additional Technical Skills:
- Fabric
- Microsoft Azure
Preferred Systems Experience:
- Team Foundation Server
- Azure DevOps
- Power BI Administration and/or support
Preferred Business Experience:
- Insurance sector (Lloyds Syndicate, Underwriting, Broking), degree educated in a relevant field or long-standing technical experience.
Company Information:
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.
Benefits:
- 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
SQL Developer in Swansea employer: IQUW Group
Contact Detail:
IQUW Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Developer in Swansea
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in BI. You never know when a casual chat could lead to your next big opportunity.
✨Show Off Your Skills
Don’t just talk about your experience; demonstrate it! Create a portfolio showcasing your SQL projects, BI reports, or any data analysis work you've done. This will give potential employers a clear picture of what you can bring to the table.
✨Ace the Interview
Prepare for those tricky interview questions by practising your responses. Focus on how your skills align with the job description, especially around T-SQL, ETL processes, and BI solutions. Confidence is key, so rehearse until you feel ready to shine!
✨Apply Through Our Website
Make sure to apply directly through our website! It not only shows your interest but also helps us keep track of your application. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace SQL Developer in Swansea
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the SQL Developer role. Highlight your T-SQL development experience and any BI reporting solutions you've worked on. We want to see how your skills align with our needs!
Showcase Your Projects: Include specific examples of projects where you've designed ETL processes or improved data quality. This helps us understand your hands-on experience and how you can contribute to our team right away.
Be Clear and Concise: When writing your application, keep it straightforward. Use bullet points for key achievements and avoid jargon unless it's relevant. We appreciate clarity as much as we appreciate technical skills!
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. We can’t wait to hear from you!
How to prepare for a job interview at IQUW Group
✨Know Your Tech Inside Out
Make sure you brush up on your T-SQL, SSIS, SSAS, and SSRS skills. Be ready to discuss specific projects where you've used these technologies, as well as any challenges you faced and how you overcame them.
✨Understand the Business Context
Familiarise yourself with the insurance sector, especially if you have experience in Lloyds Syndicate or similar environments. Being able to relate your technical skills to business needs will show that you can bridge the gap between tech and business.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical problems related to BI reporting or data extraction. Practise articulating your thought process clearly, as this will demonstrate your analytical maturity and problem-solving skills.
✨Show Team Spirit
Since the role involves supporting and developing team members, be prepared to discuss how you've contributed to team success in the past. Share examples of how you've collaborated with others to achieve common goals, especially in a BI context.