Data Analyst

Job Title: Contract Data Analyst

Location: Hybrid, Occasional visits to North London Office

Contract Duration: 3 months

Company Overview: A medical equipment services organisation in the UK & Ireland, committed to delivering innovative solutions and exceptional service to our clients. We seek a skilled Data Analyst to join our team on a contract basis to support our ERP implementation project, migrating to Microsoft Dynamics 365.

Job Description:

Role Overview: The Data Analyst will help model and prepare data for migration to new systems. This will include the modelling of master data. The role will involve taking the lead with data cleansing.

The ideal candidate will have a strong background in data modelling, data cleansing, and de-duplicating data. This role will involve carrying out data migration as part of our ERP and Finance systems projects.

The business operates a medical equipment and consumables operation that includes sales, training, installation, and field service.

The company is growing rapidly and is currently in the (Apply online only) people range.

The project scope is to replace the current Field Service solution with D365 Field Service and implement D365 Business Central for Finance and Operations. Further project phases are under consideration for Commercial, Sales and Training.

Key Responsibilities:

• Perform data modelling to structure and organise data effectively.
• Cleanse and de-duplicate data to ensure accuracy and consistency.
• Execute data migration tasks for ERP and Finance systems.

• Mapping data sets to master data + cleansing/enriching/transformation

• Build and optimise SQL queries for data extraction and manipulation.
• Utilize Excel and Access to manipulate and analyse data.
• Understand and work with relational databases.
• Use tools to automate data cleansing processes.

Skills and Experience:

• 3+ years of proven experience as a data analyst or in a similar role.
• Ability to extract data from SQL Databases
• Proficiency in SQL for building and optimising queries.
• Advanced skills in Excel and Access for data manipulation.
• Strong understanding of relational databases.
• Experience with data migration in ERP and Finance systems.
• Familiarity with tools for automating data cleansing.
• Apply a structured approach to data modelling and quality
• Strong communication and teamwork abilities.

Preferred Qualifications:

• Experience with specific ERP systems (e.g. Dynamic 365, Oracle & SAP).
• Knowledge of data governance and best practices.
• Certification in data management or related fields.