Data Analyst – Microsoft 365 Migration in Bromley Town

Data Analyst – Microsoft 365 Migration

Remote – must be UK based

Salary £40k–£50k DOE

Have you worked with Microsoft 365 or Entra ID data and used PowerShell and Microsoft Graph to pull it together?

Can you reconcile large datasets from different sources and build Power BI dashboards that show where the gaps are?

Would you like to use those skills to work out which applications a global business depends on before it moves to a single Microsoft 365 environment?

We’re recruiting for a growing Microsoft 365 consultancy that needs a Data Analyst to support a global tenant consolidation programme. You’ll work alongside a Technical Business Analyst to identify which applications are in use, how people access them and what those applications depend on before the migration goes ahead.

Most of the discovery work will come from technical data. You’ll piece together evidence from sign-in logs, endpoint inventories and platform exports, then use it to help regional IT teams validate the findings. Once discovery is complete, you’ll help prepare for testing and check that users, groups and application assignments have migrated correctly.

What you’ll be doing

• 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 so the team can see applications that may only be used at those points.

• Build an application inventory, use sign-in and usage data to identify dependencies across regions, and review endpoint and proxy data to find applications that sit 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.

What you’ll need

• 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.

• An 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.

If this sounds like your kind of role, apply with your CV. We’d be interested to hear about a project where you brought data from several sources together to answer a technical question.