About this role
Salary: £40,000 - 50,000 per year
Requirements
- At least two years experience as a Data Analyst and two years experience building and deploying custom Power BI dashboards.
- Hands-on experience working with Microsoft 365 or Entra ID data, plus PowerShell scripting skills, including Microsoft Graph PowerShell.
- Understanding of Entra enterprise applications, service principals, guest accounts and sign-in logs.
- Strong Power BI skills, including Power Query, M and DAX, and advanced Excel skills, including pivot tables, formulas and lookups.
- Experience combining and reconciling large datasets and maintaining management information reports.
- Clear communication in English, strong documentation skills and close attention to detail.
- Experience in IT infrastructure, tenant migrations or application inventory projects would be useful, as would experience preparing test data or tracking defects.
Responsibilities
- Extract and reconcile data from Entra ID, Exchange Online, Intune, Power BI and Power Platform using PowerShell, Microsoft Graph and admin centre exports.
- Maintain Entra sign-in and audit log exports across month-end and year-end to identify applications that may only be used at those times.
- Build an application inventory, use sign-in and usage data to identify dependencies across regions, and review endpoint and proxy data to find applications outside Entra sign-in.
- Build and maintain Power BI dashboards showing inventory coverage, gaps, testing progress and defects.
- Prepare data for regional IT reviews and client testing, then compare records before and after each cutover.
Technologies
- DAX
- Excel
- Support
- Microsoft 365
- Power BI
- Power Query
- PowerShell
- Office 365
More
Were recruiting for a growing Microsoft 365 consultancy seeking a Data Analyst to support a global tenant consolidation programme. Youll work alongside a Technical Business Analyst to identify applications in use, how people access them and what they depend on before migration to a single Microsoft 365 environment. The role involves collaborating with regional IT teams to validate discovery findings and supporting preparation and checks for testing and cutovers. It is remote, but you must be based in the UK. Salary is £40,000–£50,000, depending on experience. Apply with your CV and tell us about a project where you brought together data from several sources to answer a technical question.
last updated 46 week of 2026