FDM is a global business and technology consultancy seeking a Microsoft BI Stack Developer to design, build, and support end‑to‑end business intelligence and analytics solutions using the Microsoft data and analytics ecosystem. This is initially a 3 month contract with potential to extend and will be a hybrid role based in London
The role will focus on transforming complex data into trusted, actionable insights through semantic models, dashboards, and reporting solutions aligned to business and stakeholder needs. You will work closely with data engineers, analysts, and business stakeholders to deliver scalable, secure, and high‑performing BI solutions, often within regulated or public sector environments.
Responsibilities:
BI and Analytics Delivery:
- Design, develop, and maintain Power BI dashboards and reports that provide clear, actionable insights to senior stakeholders.
- Build and optimise semantic data models using Power BI (Import, DirectQuery, and Composite models).
- Translate business requirements into technical BI solutions, including KPIs, metrics, and visual narratives.
- Ensure reports are intuitive, performant, accessible, and aligned to UX best practices.
Data Modelling and Analytics:
- Develop robust data models using star and snowflake schemas.
- Write and optimise complex SQL queries, views, and stored procedures.
- Implement and maintain DAX measures and calculated columns in Power BI.
- Ensure data accuracy, consistency, and reconciliation across sources.
Microsoft and Azure Data Stack:
- Work with Microsoft data services such as:
- Azure SQL Database / SQL Server
- Azure Synapse Analytics
- Azure Data Factory
- Azure Data Lake
- Support ingestion, transformation, and orchestration of data pipelines (in collaboration with data engineers where applicable).
Governance, Security and Performance
- Implement row-level security (RLS) and comply with data protection and governance standards.
- Optimise Power BI models and reports for performance and scalability.
- Support BI governance, deployment pipelines, and workspace management.
- Contribute to documentation, standards, and reusable BI assets.
Stakeholder Engagement:
- Engage with technical and non‑technical stakeholders to understand data needs.
- Support users with Power BI adoption, training, and best practices.
- Provide insight and recommendations based on data trends and analysis.