Data Analyst- ERP

Beauti-Tone Paint and Home Products; Ontario; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Be part of a proudly Canadian company as a Data Analyst- ERP, supporting the implementation of Microsoft Dynamics 365. You'll analyze and cleanse data, ensuring quality migration from legacy systems. With competitive salaries, bonuses, and a supportive team culture, this is an opportunity to grow your career in a collaborative environment.

Benefits

Competitive earnings opportunity

Annual Incentive/Bonus Program

Comprehensive Benefits Program

Defined Contribution Pension Plan

Employee Discount Program

Competitive vacation time

Home & Auto Insurance discounts

Qualifications

• 3-5 years of experience in data analysis and mapping.
• Expertise in data cleansing and validation.
• Strong understanding of D365 modules and data integrity.

Responsibilities

• Conduct data analysis and mapping legacy data sources to D365 targets.
• Ensure data cleansing & mapping aligns with business processes.
• Support change management efforts to assist in user adoption.

Skills

Data analysis

Data cleansing

Data migration

Collaboration

Problem-solving

Education

Degree in Computer Science, Information Technology, or Data Management

Tools

SQL

Excel

Power Query

Python

Azure Data Factory

Power Automate

Job description

Welcome Home!

We’re more than Canada’s largest independent hardware and building supplies retailer—we’re part of communities across the nation.

Shape the Future of Data

As the Data Analyst- ERP, you support the successful implementation of Microsoft Dynamics 365 by ensuring accurate, high quality data migration from legacy systems to D365. Led by the Director, ERP – ETL and Data Governance, this opportunity will best suit someone who enjoys working in a collaborative environment and bridging the gap between business and technical teams.

Ready to make an impact? Here’s how:

• Conduct data analysis and mapping legacy data sources to D365 targets, and document.
• Conduct data profiling, cleansing, migration and quality management activities as well as validation checks to ensure clean data for D365 and downstream consumption by user community.
• Ensure data cleansing & mapping aligns with business processes & D365 module requirements.
• Assist in extracting, transforming & loading data from legacy systems into D365.
• Provide reporting on data quality metrics & migration progress when required.
• Work with business stakeholders and others to understand data requirements and define data quality standards.
• Collaborate with members of the implementation team as well as others to ensure seamless data migration and cleansing.
• Support change management efforts to assist in user adoption.

We’re looking for:

• Degree in Computer Science, Information Technology, Data Management with 3-5 years of experience.
• Expertise in analyzing and mapping data from legacy systems (e.g., CRM, custom databases) to D365 entities, ensuring data integrity and compatibility.
• Proficiency in data cleansing, transformation, and validation, including identifying and resolving data quality issues (e.g., duplicates, inconsistencies) to meet D365 standards.
• Strong understanding of D365 modules (e.g., Finance, Supply Chain), data models, entities, and relationships to support accurate data migration.
• Experience with ETL processes and integration tools (e.g., Azure Data Factory, Power Automate) for efficient data extraction and loading.
• Ability to collaborate with stakeholders to gather requirements, align data mapping with business processes (e.g., retail, finance), and document specifications clearly.
• Proficiency in data analysis tools (e.g., Excel, Power Query, SQL, Python) and familiarity with D365 Data Management Workspace or Azure DevOps.
• Excellent communication and analytical skills to troubleshoot discrepancies, work with cross-functional teams, and ensure compliance with business rules.
• Familiarity with Agile/Waterfall/Hybrid methodologies and basic project management skills to track migration tasks and coordinate with teams or vendors.
• The ability to be onsite three days a week at our corporate office in St. Jacobs, to accommodate our hybrid working model.

How we’ll make you feel at Home

Our Team Members enjoy life at Home with our strong culture of support and inclusion, excellent benefits, and a team that always has your back. You will receive:

• Competitive earnings opportunity.
• Annual Incentive/Bonus Program.
• Comprehensive Benefits Program including:
• Health, Dental, Vision, Paramedical, Disability coverage, Out of Country Travel Insurance, Life Insurance, Employee Family Assistance Program.
• Defined Contribution Pension Plan with Company Match, and choice of contribution level.
• Group RRSP.
• Discounts from our corporate retail stores.
• Home & Auto Insurance discounts.
• Competitive vacation time.
• Personal and sick time.
• Employee Discount Program through Venngo WorkPerks.

Bring your unique skills, thrive with interesting and challenging work, and experience what it’s like at Home. Apply today - this is a great opportunity to join a proudly Canadian company that is 100% ready to help you build your future.

Home Hardware recognizes the value of a diverse team. We believe that different perspectives, backgrounds, and experiences make us stronger as an organization. Applicants representing the full diversity of communities in Canada are encouraged to apply with confidence. Please let us know if you require accommodation during the recruitment process.

Canadians call us Home Hardware. We call it Home.