Data Analyst
Core
Ensure seamless migration of data between systems while maintaining data quality, integrity, and performance standards.
Role type
Data Analyst (Data Migration & BI)
Builds
Data migration pipelines, Power BI reports, and data quality documentation
Domain
Enterprise Resource Planning (ERP) / Customer Relationship Management (CRM)
Required skills
SQL, data profiling, source-to-target mapping, data cleansing, Power BI, Microsoft Fabric, data reconciliation
Preferred skills
Microsoft Dynamics CRM, Azure Synapse, SQL Server, Agile methodologies
Technologies
Microsoft Fabric, Power BI, SQL, Microsoft Dynamics CRM, Azure Synapse, SQL Server
Responsibilities
Analyse source and target systems to understand data structures and business meaning; Write SQL queries to analyse data and test transformation logic; Plan and run pre- and post-migration testing; Build Power BI reports to track migration progress and data quality; Reconcile source and target data using row counts and field-level comparisons; Handle sensitive and personal information in line with privacy policies.
Seniority
Mid-level, hands-on IC