Business Data Consultant

Mphasis Ltd; Greater London; On-site; GBP 50,000 - GBP 70,000; Full time

Job summary

A leading tech consulting firm in Greater London is seeking a skilled Data Migration Specialist. Responsibilities include analyzing data for migration, managing hybrid Exchange environments, and collaborating with security teams to ensure compliance. The ideal candidate has extensive experience with Microsoft 365 services, including SharePoint and OneDrive, as well as proficiency in PowerShell scripting. This role is crucial for the successful execution of large-scale migration projects and requires strong stakeholder engagement skills.

Qualifications

• Experience with data migrations to Microsoft 365 workloads.
• Strong analytical and problem-solving skills.
• Understanding of permissions mapping and access control.

Responsibilities

• Analyse data from various sources to identify ROT content.
• Map file server structures to Microsoft 365.
• Conduct validation checks during migrations.
• Collaborate with security teams for compliance.
• Automate migration processes using scripts.

Skills

SharePoint Online experience

PowerShell scripting

Data cleansing

Migration tools proficiency

Excellent problem-solving skills

Stakeholder engagement

Tools

ShareGate

AvePoint

Microsoft Teams

OneDrive for Business

Azure AD Connect

Job description

• Analyse data from various sources (OneDrive, SharePoint, Teams channels etc. ) to identify redundant, obsolete, and trivial (ROT) content.
• Map file server structures and Exchange configurations to Microsoft 365 destinations, ensuring alignment with best practices.
• Conduct pre- and post-migration validation checks including data integrity, permissions mapping, access verification, and mail flow validation.
• Configure and manage hybrid Exchange environments and coexistence models where required (e.g., ADFS, Azure AD Connect, Hybrid Configuration Wizard).
• Collaborate with security and compliance teams to ensure migrations meet organizational and regulatory requirements (e.g., GDPR, ISO 27001).
• Engage with business stakeholders and change management teams to drive user readiness and adoption.
• Automation scripts for discovery, reporting, and pre/post-migration validation.
• Migrating unstructured data from on-premises file servers and network shares to OneDrive for Business, SharePoint Online, and Microsoft Teams.
• Provide technical guidance and escalation support during critical migration phases and post-migration hypercare.
• Lead technical design and implementation of migration processes using tools such as ShareGate, AvePoint, Quest, Metalogix, BitTitan, Binary Tree, or native Microsoft tools (Mover, Migration Manager, HCW, PST import/export).
• Data cleansing, profiling, mapping and mining of portfolio data.
• Ensure client data used for portfolio delivery is stored in consistent format and in line with treaty arrangements.
• Liaison with internal clients to understand data content to maximise the benefits to the business, uncovering possible weaknesses and working for their correction.
• Forecasting experience is beneficial for predicting trends and supporting business planning
• Use machine learning models and statistical analysis to extract insights from data
• Collect and analyse data from various sources to identify patterns, trends, and correlations
• Collaborate with business partners to understand their needs and identify opportunities for data-driven decision making
• Identify and implement data quality improvements

Required Skills and Experience:

• Experience with SharePoint Online, Microsoft Teams, and OneDrive for Business.
• Proficiency with migration tools like ShareGate.
• Strong skills in PowerShell for scripting and automation.
• Experience with data cleansing, information architecture, and taxonomy.
• Excellent technical, analytical, and problem-solving skills.
• Detailed pre-migration assessments, including data profiling, permissions analysis, and Exchange infrastructure review.
• Directory synchronization technologies (Azure AD Connect, ADFS).
• Proven experience delivering large-scale data and mailbox migration projects to Microsoft 365 workloads (OneDrive, SharePoint Online, Teams, Exchange Online).
• Microsoft 365 services and information architecture.
• Migration tools such as ShareGate, AvePoint, Metalogix, Quest, BitTitan, Binary Tree, Mover, or Migration Manager.
• Proficiency in PowerShell scripting for automation and reporting tasks across file and Exchange migrations.
• Solid understanding of permissions mapping, data integrity validation, mail flow, and access control models in M365.
• Excellent problem-solving skills, troubleshooting, and technical documentation capabilities.
• Strong communication and stakeholder engagement skills to liaise effectively with technical teams and business users.
• Understanding of Insurance / Reinsurance Business