Business data consultant

iXceed Solutions; Camden Town; On-site; GBP 45,000 - 65,000; Full time

Job summary

A data management consultancy in the UK is looking for an experienced data migration specialist to lead migration projects to Microsoft 365. You will analyze various data sources, ensure compliance with regulations, and leverage migration tools such as ShareGate. Candidates should have at least 3 years experience with Microsoft products and strong skills in data cleansing and PowerShell scripting.

Qualifications

• 3+ years of work experience with Microsoft Products.
• 2+ years of work experience with ShareGate.
• Strong skills in PowerShell for scripting and automation.
• Excellent technical, analytical, and problem-solving skills.

Responsibilities

• Analyze data from varied sources to identify ROT content.
• Conduct validation checks, including data integrity and permissions mapping.
• Collaborate with teams to ensure compliant migrations.
• Lead design and implementation of migration processes using various tools.

Skills

Data cleansing

Data analysis

PowerShell scripting

Stakeholder engagement

Migration tools expertise

Machine learning models

Tools

ShareGate

AvePoint

Metalogix

Quest

BitTitan

Microsoft 365

Job description

Responsibilities

• 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).
• Develop data transformation scripts to produce portfolio data.
• 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.
• 3+ years of work experience with Microsoft Products.
• 2+ years of work experience with ShareGate.
• 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.