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.
- Benefits: Enjoy hybrid work flexibility and a permanent position with growth opportunities.
- Why this job: Be part of a collaborative culture that values innovation and problem-solving.
- Qualifications: Proven experience in MSBI, SQL, and data warehouse design required.
- Other info: Knowledge of the insurance domain and Agile processes 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
BI (Business Intelligence) LEAD | Remote employer: Ampstek
Contact Detail:
Ampstek Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI (Business Intelligence) LEAD | Remote
✨Tip Number 1
Make sure to showcase your leadership experience in BI projects during networking opportunities. Connect with professionals in the field on platforms like LinkedIn and engage in discussions about MSBI and data warehousing.
✨Tip Number 2
Join relevant online forums or communities focused on Microsoft BI tools. Participating in these groups can help you stay updated on industry trends and may lead to job referrals.
✨Tip Number 3
Consider attending webinars or workshops related to BI and data analytics. This not only enhances your skills but also expands your professional network, which can be beneficial when looking for job opportunities.
✨Tip Number 4
If you have experience with AWS, make sure to highlight it in conversations with potential employers. Understanding cloud technologies is increasingly important in BI roles, and demonstrating this knowledge can set you apart.
We think you need these skills to ace BI (Business Intelligence) LEAD | Remote
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 BI roles. Discuss your analytical mindset and problem-solving skills, and mention any familiarity with AWS and Power BI to stand out.
Showcase Relevant Experience: When detailing your work history, focus on your hands-on experience with ETL processes and OLAP systems. If you have insurance domain knowledge, make sure to highlight this as it is recommended for the role.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. Clear and effective communication is key, so ensure your writing reflects your excellent verbal skills.
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
During the interview, highlight specific instances where you've tackled challenging data-related problems. Use the STAR method (Situation, Task, Action, Result) to structure your responses and showcase your analytical mindset.
✨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. Be prepared to discuss how you've worked in Agile environments before and how it has influenced your approach to BI projects.
