Data Conversion Lead

IKO North America; Mississauga; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

Long-term Disability

RRSP Match

Paid Vacation

Floating Days

Employee Assistance Program

Tuition reimbursement

Service Awards

Employee Perks & Discounts

Job summary

IKO Industries Ltd. in Mississauga is seeking a Global Data Conversion Lead to guide data migration for ERP deployments, partnering with stakeholders to cleanse, map, transform and load master and transactional data.

You will collaborate with ERP project leadership, MDM, data engineering and IT management to ensure data quality across implementations. This is a hybrid role with three days onsite and about 10% travel within North America and Europe.

Qualifications

• University degree required.
• Minimum 5 years’ experience with ERP software.
• Experience with Oracle JD Edwards EnterpriseOne; Dynamics 365 or SAP also considered.
• Minimum 2 years’ experience as Master Data Management Lead/Consultant on large projects.
• Knowledge of ETL tools such as SSIS, Azure Data Factory, Qlik Replicate or Oracle EDQ.
• Strong relational database knowledge (SQL Server or Oracle).
• Advanced Microsoft Excel skills.
• SharePoint experience is a plus.
• Ability to travel ~10% within NA and Europe.

Responsibilities

• Develop standards, guidelines, and processes for converting data from legacy ERP systems into enterprise ERP platforms.
• Establish standardized processes, procedures, and tools for data conversion activities.
• Perform data mapping between ERP platforms.
• Cleanse and normalize master and transactional data.
• Perform data duplication checks and cross-referencing.
• Prepare master and transactional data load files.
• Manually input data changes into ERP systems when required.
• Monitor recurring exception reports and initiate data cleanup opportunities.
• Track, report, and measure data conversion activities and results.
• Work with end users to identify data standardization opportunities.
• Leverage ERP knowledge to identify process efficiencies.
• Collaborate with ERP project leadership, BPOs, BAs, MDM, Data Engineering, Integration teams, and IT Management.
• Support data quality initiatives throughout ERP deployment projects.
• Additional duties as assigned.

Skills

ERP data migration

Data cleansing

Data mapping

Stakeholder collaboration

SQL

Excel

Communication

Education

University degree

Tools

Oracle JD Edwards EnterpriseOne

Microsoft Dynamics 365

SAP

Microsoft SQL Server

Job description

IKO Industries Ltd. is a market leader in the manufacturing of roofing and building materials. IKO is a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and trustworthiness are the values that underlie this success, and we have built this company by hiring people who hold these values. People like you!

Job Description

Role

Global Data Conversion Lead

Job Summary

Reporting to the Global Director, IT Strategy and M&A, the successful candidate will be responsible for supporting ERP deployment projects by working directly with key business stakeholders to cleanse, extract, transform, and load master data and selected transactional data. The source and destination ERP platforms may vary depending on the project.

The Global Data Conversion Lead will collaborate closely with ERP project leadership, Business Process Owners, Business Analysts, the Master Data Management team, Data Engineering, Integration teams, and IT Management to ensure a high standard of data quality throughout ERP implementations.

This is a hybrid position requiring three days per week onsite at the Mississauga office. Approximately 10% business travel within North America and Europe may be required.

Compensation

Benefits

• Health Insurance (includes Virtual Health, and HCSA)
• Dental Insurance
• Vision Insurance
• Life Insurance
• Long-term Disability
• Short-term Disability
• RRSP Match
• Paid Vacation
• Floating Days
• Employee Assistance Program
• Employee Engagement Events
• Awards and Recognition
• Tuition reimbursement
• Service Awards
• Employee Perks & Discounts

Job Responsibilities

• Develop standards, guidelines, processes, and expertise for converting data from legacy ERP systems into enterprise ERP platforms
• Establish standardized processes, procedures, and tools for data conversion activities
• Perform data mapping between ERP platforms
• Cleanse and normalize master and transactional data
• Perform data duplication checks and cross-referencing
• Prepare master and transactional data load files
• Manually input data changes directly into ERP systems where required
• Monitor recurring exception reports and initiate data clean-up opportunities
• Track, report, and measure data conversion activities and results
• Work with end users to identify data standardization opportunities
• Leverage ERP system knowledge to identify and develop process efficiencies
• Collaborate with ERP project leadership, Business Process Owners, Business Analysts, MDM, Data Engineering, Integration teams, and IT Management
• Support data quality initiatives throughout ERP deployment projects
• Additional duties as assigned

Qualifications

• University degree required
• Minimum 5 years’ experience working with Enterprise Resource Planning (ERP) software
• Strong preference for Oracle JD Edwards EnterpriseOne experience; Microsoft Dynamics 365 or SAP experience will also be considered
• Minimum 2 years’ experience as a Master Data Management Lead, Consultant, or similar role on large and complex technology projects
• Knowledge and experience with ETL tools such as Microsoft SSIS, Azure Data Factory, Qlik Replicate, or Oracle EDQ
• Knowledge and experience with relational database management systems such as Microsoft SQL Server or Oracle
• Advanced Microsoft Excel skills
• SharePoint experience is considered an asset
• Strong understanding of data cleansing, normalization, mapping, validation, duplication checking, and data conversion processes
• Detail-oriented with the ability to review large and complex datasets to identify patterns, discrepancies, and data quality issues
• Strong analytical and critical-thinking skills
• Ability to analyze varying stakeholder concerns and work effectively with diverse groups to build consensus
• Ability to communicate complex information clearly and concisely to different levels of the organization
• Excellent verbal and written communication and presentation skills, including experience with Microsoft PowerPoint
• Ability to manage multiple priorities and adjust direction as business and project requirements change
• Ability to travel approximately 10% within North America and Europe

Benefits of Employment

IKO recognizes that its success is due to the strength of its employees. A primary goal of IKO is to promote individual employee’s sense of accomplishment and contribution so that employees enjoy their association with IKO. The Company invests in its employees so that they are the most knowledgeable in the industry, and undertakes great efforts to nurture loyalty to, and teamwork at, IKO. We are pleased to offer competitive compensation, health care, a progressive and challenging workplace and a commitment to teamwork and integrity.

Diversity and Equal Opportunity Employment

IKO Industries Ltd. is an equal opportunity employer. We are committed to diversity and inclusion and are pleased to consider all qualified applicants for employment without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status or disability. IKO Industries Ltd. encourages and welcomes applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.