Business Intelligence Analyst

As a recruitment company, DCG understands that every business is powered by experienced professionals. Our management style and partnership approach enable us to meet your needs and provide continuous support. Due to our ongoing growth and the large number of recruitment projects we undertake for our partners, we are currently looking for:

Business Intelligence Analyst

Responsibilities:

• Design, build and maintain accessible Power BI reports, dashboards and reporting outputs for corporate impact KPIs
• Develop robust Power Query transformations, semantic data models, relationships, calculations and DAX measures
• Clean, process and model quantitative and qualitative data from multiple sources, including survey responses and stakeholder feedback
• Develop data-quality checks, validation rules, exception reporting and reconciliations to improve accuracy, completeness and consistency
• Apply agreed KPI definitions, calculation logic, metadata, ownership and governance controls within reporting solutions
• Integrate reporting processes with SharePoint, Teams, Microsoft Forms and Power Automate, supporting automation of repeatable reporting activities
• Work with the Business Analyst and stakeholders to understand reporting questions, translate requirements into useful visualisations and iterate solutions through feedback
• Support testing, deployment, access management, refresh monitoring, issue resolution and transition into business-as-usual support
• Produce clear technical documentation, data dictionaries, report specifications, test evidence, user guidance and handover materials
• Contribute analytical evidence to the stakeholder and organisational engagement data discovery and future investment roadmap

Requirements:

• Minimum 4-5 years of relevant experience developing Power BI solutions, including Power Query, DAX, data modelling and visualisation
• Experience connecting and preparing data from SharePoint and Microsoft 365 sources, and working with Teams, Microsoft Forms and Power Automate
• Experience cleaning, processing and modelling a range of quantitative and qualitative data, including survey responses
• Practical understanding of data governance, data quality assurance, validation, reconciliation and controlled reporting
• Ability to analyse business processes and translate stakeholder needs into clear, usable reporting and insight products
• Strong stakeholder management, communication, problem-solving and technical documentation skills
• Experience developing, testing, deploying and supporting repeatable reporting solutions rather than producing one-off dashboards
• Fluent English

Nice to have:

• Experience supporting global operational functions or working in a large, matrix organisation
• Corporate performance, impact, compliance, assurance or audit reporting experience
• Estates or facilities reporting experience
• Reporting automation design and integration across the Microsoft Power Platform
• Power BI optimisation, performance tuning and refactoring of existing reports and models

Offer:

• Constant support of dedicated consultant
• Employee referral program