Contract Data Processing Analyst

Fortress Recruit Limited; Poole; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

Fortress Recruit Limited is seeking an experienced Contract Data Processing Analyst to support a major ERP transformation. Based in Poole with remote flexibility, the role will involve cleansing, consolidating and migrating large data sets from multiple legacy sources into Infor.

You will use SQL and Excel for data extraction and validation, collaborate with data owners, and help ensure data quality across BOMs, parts, stock and POs.

Qualifications

• Strong experience in data analysis, data cleansing or data migration.
• Excel skills at an advanced level.
• Good working knowledge of SQL and ability to query multiple datasets.
• Experience with large volumes of business data.
• Attention to detail and methodical data quality approach.
• Ability to identify patterns and anomalies in complex datasets.
• Experience working independently and managing a data workstream.
• Excellent communication with stakeholders across functions.
• Knowledge of manufacturing data including BOMs, routings, stock and POs.
• Power BI experience is beneficial though not primarily a dashboard role.
• ERP implementation experience would be highly advantageous.

Responsibilities

• Reviewing and rationalising large volumes of existing business data.
• Identifying duplicate, conflicting, incomplete and inconsistent records.
• Comparing data across legacy databases and systems.
• Cleansing and standardising data for migration into Infor.
• Identifying data restructuring or reformatting needs for the new system.
• Using SQL to extract, interrogate and reconcile data where appropriate.
• Working with Excel and other data sources to collate information.
• Supporting data mapping and migration preparation.
• Collaborating with Process Data Owners to resolve data issues.
• Reviewing data related to BOMs, parts, routings, stock, suppliers, customers, orders, finance and HR.
• Supporting data held behind PLM/engineering systems (SolidWorks, Creo, Windchill).
• Identifying missing data and defining requirements before migration.
• Providing clean datasets to support ERP implementation teams.
• Supporting reconciliation and validation as the project progresses.

Skills

Data analysis

Data cleansing

Data migration

Excel

SQL

Power BI

Tools

Infor

Windchill

SolidWorks

Job description

Fortress Recruit is supporting a leading engineering and manufacturing business in their search for an experienced Contract Data Processing Analyst to support a major ERP transformation programme. This is an Outside IR35 opportunity for 6-12 months supporting the migration from multiple legacy data sources into a new ERP system.

Key responsibilities will include:

• Reviewing and rationalising large volumes of existing business data


• Identifying duplicate, conflicting, incomplete and inconsistent records


• Comparing data across multiple legacy databases and systems


• Cleansing and standardising data ready for migration into Infor


• Identifying data that requires restructuring or reformatting for the new system


• Using SQL to extract, interrogate and reconcile data where appropriate


• Working with Excel and other data sources to collate and prepare information


• Supporting data mapping and migration preparation


• Working with Process Data Owners across the business to identify and resolve data issues


• Reviewing data relating to BOMs, parts, routings, stock, suppliers, customers, sales and purchase orders, engineering, manufacturing, finance and HR


• Supporting data held behind PLM and engineering systems, including databases associated with SolidWorks, Creo and Windchill


• Identifying missing data and defining what is required before migration


• Providing clean and structured datasets to support the wider ERP implementation team


• Supporting reconciliation and validation activities as the implementation progresses

To be successful in this role, you will have:

• Strong experience in data analysis, data cleansing or data migration


• Excellent Microsoft Excel skills


• Good working knowledge of SQL, including the ability to write queries and interrogate multiple datasets


• Experience working with large volumes of business data


• Strong attention to detail and a methodical approach to data quality


• The ability to identify patterns, inconsistencies and anomalies within complex datasets


• Experience working independently and managing a defined data workstream


• Strong communication skills and the ability to work with stakeholders across different business functions


• A good understanding of manufacturing data, ideally including BOMs, routings, parts, stock and purchase orders


• Power BI experience would be beneficial, particularly the ability to work with and understand existing reports and datasets, although this is not primarily a dashboard development role.


• Experience supporting an ERP implementation would be highly advantageous. Experience working within engineering, manufacturing, aerospace, defence or another industrial environment would also be particularly relevant.

This is an Outside IR35 contract opportunity based in Poole, supporting a major ERP transformation programme. The role offers remote flexibility, with onsite presence required at key stages of the implementation.