MSBI Lead

FalconSmartIT; Greater London; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

A reputable IT consulting firm in London is seeking a Lead MSBI to spearhead Microsoft BI projects. The ideal candidate should have hands-on experience with Microsoft BI tools, particularly SSIS, SSAS, and SSRS, along with strong SQL skills for complex querying. Knowledge of data warehouse design and the insurance domain is advantageous. This role is permanent and offers a hybrid work arrangement, ideal for professionals seeking immediate opportunities.

Qualifications

• Proven experience as a Microsoft BI Developer (SSIS, SSAS, SSRS).
• Ability to write complex SQL queries and stored procedures.
• Experience in data warehouse design and data mining.
• Understanding of OLAP and ETL frameworks.

Skills

Microsoft BI (SSIS, SSAS, SSRS)

SQL Expertise

Data Warehouse Design

Database Management Systems

Problem-Solving Aptitude

Communication Skills

Tools

Power BI

AWS Awareness

Job description

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