Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the Microsoft BI team, developing and managing data solutions.
- Company: Join a dynamic company in London, focused on innovative data solutions.
- Benefits: Enjoy hybrid work options and a supportive corporate culture.
- Why this job: Be part of a cutting-edge team making impactful data-driven decisions.
- Qualifications: Proven experience as a Microsoft BI Developer with strong SQL skills required.
- Other info: Immediate start available; insurance domain knowledge is a plus.
The predicted salary is between 48000 - 72000 £ per year.
Role: Lead MSBI
Location: London, UK
Is it Permanent / Contract: Permanent
Is it Onsite/Remote/Hybrid: Hybrid
Start Date: Immediate
Job Description:
- Lead MSBI (Must have Lead Experience)
- Proven experience and hands-on as a Microsoft BI Developer (SSIS, SSAS, SSRS)
- Expert in SQL. Should be able to write complex, nested queries, stored procedures.
- Background in data warehouse design (e.g., dimensional modelling) and data mining
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
- AWS awareness
- Analytical mind with a problem-solving aptitude
- Added advantage: knowledge on Master data services and Power BI
- Excellent written and verbal communication. Insurance domain knowledge is recommended.
- Basic understanding of Agile process is good to have
Contact Detail:
Ampstek Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Lead
✨Tip Number 1
Familiarise yourself with the latest Microsoft BI tools and technologies, especially SSIS, SSAS, and SSRS. Being able to discuss recent updates or features during your interview can demonstrate your commitment and expertise in the field.
✨Tip Number 2
Brush up on your SQL skills, particularly complex queries and stored procedures. Consider working on sample projects or challenges that require you to solve real-world problems using SQL to showcase your abilities.
✨Tip Number 3
Gain a solid understanding of data warehouse design principles, especially dimensional modelling. You might want to create a small project or case study that illustrates your knowledge in this area, which you can discuss during your interview.
✨Tip Number 4
If you have experience in the insurance domain, be prepared to share specific examples of how your BI skills have positively impacted business decisions. If not, research common BI challenges in the insurance sector to show your interest and understanding.
We think you need these skills to ace Business Intelligence Lead
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Microsoft BI tools like SSIS, SSAS, and SSRS. Include specific examples of complex SQL queries you've written and any relevant projects that showcase your data warehouse design skills.
Craft a Compelling Cover Letter: In your cover letter, emphasise your leadership experience in Business Intelligence and your analytical problem-solving skills. Mention your familiarity with AWS and any knowledge of the insurance domain to stand out.
Showcase Relevant Skills: Clearly outline your technical skills related to database management systems, OLAP, and ETL frameworks. If you have experience with Master Data Services or Power BI, make sure to include that as well.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role in Business Intelligence.
How to prepare for a job interview at Ampstek
✨Showcase Your Technical Skills
Be prepared to discuss your experience with Microsoft BI tools like SSIS, SSAS, and SSRS. Bring examples of complex SQL queries you've written and be ready to explain your thought process behind them.
✨Demonstrate Your Analytical Mindset
During the interview, highlight your problem-solving skills by discussing specific challenges you've faced in previous roles. Use the STAR method (Situation, Task, Action, Result) to structure your responses.
✨Familiarise Yourself with the Insurance Domain
If you have experience in the insurance sector, make sure to mention it. If not, do some research on common data challenges in the industry to show your interest and understanding.
✨Communicate Clearly and Effectively
Since excellent communication is key for this role, practice articulating your thoughts clearly. Be concise and ensure you can explain technical concepts in a way that non-technical stakeholders can understand.
