Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead a team in developing and managing Microsoft BI solutions.
- Company: Join a dynamic company at the forefront of data intelligence in London.
- Benefits: Enjoy hybrid work options and a supportive corporate culture.
- Why this job: Be part of a team that drives impactful data solutions and innovation.
- Qualifications: Proven experience in Microsoft BI tools and strong SQL skills required.
- Other info: Immediate start available for the right candidate.
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
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 updates or features during your interview can demonstrate your passion and commitment to 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 discuss specific projects where you applied these skills. Highlighting your analytical mindset and problem-solving abilities will resonate well with the hiring team.
✨Tip Number 4
Since knowledge of the insurance domain is recommended, try to gather insights about industry-specific challenges and how BI can address them. This will help you stand out as a candidate who understands the business context of the role.
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 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 instances where you tackled challenges in data management or analysis, highlighting your thought process and the outcomes.
✨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, especially if you have insurance domain knowledge.
✨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 you’ve applied them in previous projects or how you would integrate them into your work.
