ERP Data Migration Developer

United States Digital Space LLC; Mississauga; On-site; CAD 90,000 - 140,000; Full time

Benefits offered by this job

Subsidized cafeteria

Gym access

RRSP contributions

Employee Assistance Program

Free parking

EV charging

Flynn Fest

Sports Sponsorship Program

Rogers Preferred Program

Perkopolis discounts

Job summary

Flynn is seeking an ERP Data Migration Developer to join the Mississauga ERP project team and support a major enterprise ERP implementation. You will work with stakeholders and ERP teams to convert data from legacy systems into the target ERP solution.

This role focuses on extracting, cleansing, transforming, validating and loading master, reference and transactional data across ERP systems, with emphasis on data quality and process automation.

Qualifications

• 7+ years in ERP data conversion, ETL, or BI/Data Warehouse roles.
• 5+ years ERP experience with Dynamics or similar ERP platforms.
• Strong SQL skills with SQL Server/Oracle or equivalent.

Responsibilities

• Partner with Business SME, ERP BA and application teams on mappings, rules and dependencies.
• Translate conversion requirements into reliable mapping, transformation rules and data load solutions.
• Develop and support repeatable ERP data conversion processes for extraction, transformation, validation and loading.
• Build and optimize transformations, procedures, pipelines, reports and validation routines.
• Support master, reference and transactional data conversion across ERP systems.

Skills

ERP data conversion

Data ETL

SQL

Azure Data Factory

Python

Data governance

Documentation

Stakeholder comms

Education

Bachelor's degree in Computer Science

Tools

Azure DevOps

Boomi

Workato

Power BI

Job description

At Flynn, it's not just a job, it's a career

Flynn is seeking an ERP Data Migration Developer to join the ERP project team at our Mississauga office and support a major enterprise ERP implementation. Reporting to the ERP Data Migration Lead, this newly created role will work closely with business stakeholders, ERP functional teams, and Project Managers to support data conversions.

This role will focus on converting data from legacy systems into the target ERP solution by extracting, cleansing, transforming, validating, and loading master, reference, and transactional data.

What we offer:

• Subsidized in-house cafeteria and gym
• Dental and supplemental medical plan
• RRSP contributions
• Employee and Family Assistance Program
• Free parking and EV Charging facility
• Family Events and Flynn Fest
• Sports Sponsorship Program
• Rogers Preferred Program
• Perkopolis Retailer Discounts

Responsibilities:

• Partner with Business SME, ERP BA and application teams on mappings, rules, and dependencies.
• Translate conversion requirements into reliable mapping, transformation rules, and data load solutions. Collaborate with various Business SME / Data Champions to document data conversion business rules.
• Develop and support repeatable ERP data conversion processes for extraction, transformation, validation, and loading.
• Build and optimize transformations, procedures, pipelines, reports, and validation routines.
• Support master, reference, and transactional data conversion across ERP’s and connected systems.
• Develop load files and support batch, near-real-time, API, and middleware load patterns.
• Prepare and validate load files across mock and implementation of conversion cycles.
• Support mock conversions, migration testing, cutover rehearsals, go-live readiness, and stabilization.
• Monitor exceptions, resolve load errors, and support data clean-up with business SMEs.
• Perform profiling, reconciliation, duplication checks, validation, and cross-referencing for accurate migration.
• Support data quality metrics, issue tracking, trend monitoring, and remediation follow-up.
• Document designs, mappings, transformation logic, validation rules, procedures, and standards.
• Support large scale, multi-entity ERP implementation spanning across North America.

What we are Seeking:

Experience

• 7+ years in ERP data conversion, Data ETL and Integration or related BI / Data Warehouse technical role.
• 5+ years large scale ERP experience with leading solutions such as Dynamics SL, IFS Global, INFOR, and Dynamics 365.
• Strong SQL skills with SQL Server, Oracle, or similar relational databases.
• Hands-on experience with ETL tools, pipelines, batch loads, and near-real-time data movement.
• Experience reconciling, validating, profiling, cleansing, and troubleshooting data.
• Experience working with the construction and/or building industries is desired.
• Knowledge of ERP data domains such as finance, procurement, inventory, projects, service, or manufacturing would be an asset.
• Ability to work with business SMEs, ERP teams, data teams, application teams, and technical stakeholders.
• Strong documentation, communication, analytical, and problem-solving skills.
• Able to work independently, manage priorities, and communicate with technical and non-technical audiences.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• Hands on experience in Microsoft Cloud technologies – Fabric, Azure Data Factory, Data Pipelines, Azure Dev Ops, Purview.
• Familiarity with CI/CD, GitHub, version control, and automated testing for data workflows.
• Experience with Python, APIs, cloud data platforms, or integration of middleware such as Boomi and Workato.
• Proficiency on data visualization tools is an asset (e.g. Power BI, QlikView, etc.)
• Solid knowledge of medallion architecture and data governance, data analysis and data catalog tools (e.g. Ataccama, Collibra, Microsoft Purview, Oracle eDQ, Qlik Talend etc.)
• Proficiency in database management systems (e.g. SQL DB, Oracle DB etc.).
• Data governance certifications (CDGP, CDMP) would be an asset.
• 5% estimated travel across North America during ERP implementation.

#LI-AD1#LI-AD1

the company is the leading trade contractor in North America that works on virtually every aspect of a building’s outer layer, including Roofing, Glazing, Waterproofing, and Architectural Metals. The foundation of our award winning success is having the right people on our team.Disclosure: We use an AI-powered system to initially screen resumes. However, all applications/resumes are also reviewed by our team of Human Resources and Talent Acquisition Professionals to ensure a fair and thorough evaluation in determining a candidate’s potential fit for a role they applied to.This posting is for an existing vacancy within the organization.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.