Data Analyst - Microsoft 365 Migration
Constant Recruitment Ltd
Orpington, United Kingdom
1 day ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.adzuna.co.uk
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
2 years minimum
Compensation
£40,000 - £50,000
Working hours
Regular working hours
Languages
English
Job source
Tech stack
Microsoft Excel
Microsoft Windows
Audit Trail
Big Data
Microsoft Online Services
Microsoft Office
Pivot Tables
Windows PowerShell
Power BI
Test Data
Enterprise Software Applications
Microsoft InTune
+2 more
Powerquery
Information Technology
Job description
- 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, 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.
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.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.adzuna.co.uk
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…