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
Business Intelligence Lead employer: Ampstek
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 developments 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 dimensional modelling, be ready to discuss specific projects where you applied these concepts. This will help illustrate your hands-on experience and understanding of the role's requirements.
✨Tip Number 4
Since knowledge of the insurance domain is recommended, try to gather insights about how BI impacts decision-making in this sector. Being able to relate your BI skills to industry-specific scenarios can set you apart from other candidates.
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 as a Microsoft BI Developer, particularly with 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 Master Data Services and Power BI, as these are advantageous for the role.
Showcase Relevant Experience: When detailing your work history, focus on roles where you led BI projects or teams. Highlight your understanding of OLAP and ETL frameworks, and if applicable, include any experience you have in the insurance domain.
Proofread Your Application: Before submitting, carefully proofread your application to ensure there are no spelling or grammatical errors. A well-written application reflects your communication skills, which are essential for this role.
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. Share specific instances where you tackled data-related challenges, particularly in data warehouse design or ETL processes.
✨Communicate Clearly
Since excellent communication is key for this role, practice articulating your thoughts clearly. Be ready to explain technical concepts in a way that non-technical stakeholders can understand.
✨Familiarise Yourself with Agile Methodologies
While not mandatory, having a basic understanding of Agile processes can set you apart. Brush up on Agile principles and be prepared to discuss how they can apply to BI projects.
