Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead a team in Microsoft BI development and manage complex data projects.
- Company: Join a dynamic company at the forefront of data solutions in London.
- Benefits: Enjoy hybrid work flexibility and opportunities for professional growth.
- Why this job: Be part of an innovative culture that values analytical skills and problem-solving.
- Qualifications: Proven experience in MSBI, SQL, and data warehousing is essential.
- Other info: Immediate start available; insurance domain knowledge is a plus.
The predicted salary is between 43200 - 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 Leader - Remote employer: Ampstek
Contact Detail:
Ampstek Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Leader - Remote
✨Tip Number 1
Make sure to showcase your leadership experience in MSBI during networking events or industry meetups. Engaging with professionals in the field can help you gain insights and potentially get referrals.
✨Tip Number 2
Join online forums or groups focused on Microsoft BI and data warehousing. Participating in discussions can help you stay updated on industry trends and connect with others who might know about job openings.
✨Tip Number 3
Consider reaching out to current or former employees at StudySmarter via LinkedIn. They can provide valuable information about the company culture and what they look for in candidates.
✨Tip Number 4
Brush up on your SQL skills by working on real-world projects or contributing to open-source initiatives. Demonstrating your technical expertise can set you apart from other candidates.
We think you need these skills to ace Business Leader - Remote
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 and data warehouse design projects you've worked on.
Craft a Compelling Cover Letter: In your cover letter, emphasise your leadership experience in MSBI and your analytical skills. Mention any relevant experience in the insurance domain and your understanding of Agile processes to stand out.
Showcase Relevant Skills: Clearly outline your technical skills related to database management systems, OLAP, and ETL frameworks. If you have knowledge of 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 and excellent communication skills, which are crucial for this role.
How to prepare for a job interview at Ampstek
✨Showcase Your Technical Skills
Be prepared to discuss your hands-on 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 complex data challenges. 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. Brush up on Agile principles and be prepared to discuss how you've applied them in previous roles or how you would approach projects in an Agile environment.
