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 Exp)
- 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 trends and tools in Microsoft BI, especially SSIS, SSAS, and SSRS. Being able to discuss recent updates or features during your interview can demonstrate your passion and expertise in the field.
✨Tip Number 2
Brush up on your SQL skills, particularly complex queries and stored procedures. Consider preparing a few examples of how you've used SQL to solve real-world problems, as this will showcase your practical experience.
✨Tip Number 3
If you have experience in data warehouse design or data mining, be ready to share specific projects where you applied these skills. Highlighting your hands-on experience will set you apart from other candidates.
✨Tip Number 4
Since knowledge of the insurance domain is recommended, do some research on industry-specific challenges and how BI can address them. This will help you connect your skills to the company's needs during discussions.
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 list your technical skills related to the job description, such as ETL processes, OLAP, and any experience with Power BI or Master Data Services. This will demonstrate your fit for the role.
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 Business Intelligence Lead.
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 approach to data warehouse design and ETL processes.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your analytical thinking and problem-solving skills. Prepare to share specific scenarios where you successfully tackled challenges in data management or analysis.
✨Communicate Clearly
Since excellent communication is key for this role, practice articulating your thoughts clearly and concisely. Be ready to explain technical concepts in a way that non-technical stakeholders can understand.
✨Familiarise Yourself with the Insurance Domain
If you have experience in the insurance sector, highlight it during the interview. If not, do some research on industry-specific challenges and trends to demonstrate your interest and willingness to learn.
