Jr. Business Analyst – ERP Data & Process Support

Legrand; Mississauga; On-site; CAD 55,000 - 65,000; Full time

Benefits offered by this job

Health benefits

401K match

Paid time off

Bonus opportunities

Job summary

Legrand in Mississauga, ON, is seeking a Jr. Business Analyst to support ERP master data management, data uploads and process improvements within our Odoo ERP environment.

Ideal for someone with 1–2 years of experience who enjoys data, problem solving and learning new technologies, including automation and AI tools. Salary range is $55,000–$65,000 annually.

Qualifications

• 1–2 years in an ERP, data analyst, business analyst or data coordination role.
• Odoo ERP experience is preferred but not required.
• Strong Excel skills including formulas, lookups, filtering and data manipulation.
• Ability to handle large volumes of structured data accurately.
• Strong analytical and problem-solving abilities.
• Good verbal and written communication skills.

Responsibilities

• Prepare, cleanse, validate and upload ERP master data using Excel templates.
• Transform business data into ERP-ready formats for imports/updates.
• Review Excel files for data issues and ensure accuracy before uploads.
• Utilize AI tools and automation to reduce manual data processing.
• Develop and improve scripts, workflows and data import processes.
• Review drawings/docs to extract product information for ERP records.
• Support sales order creation and data entry in Odoo ERP.
• Collaborate with engineering, operations, customer service and business users.

Skills

Attention to detail

Analytical skills

Communication skills

Organizational skills

Independent yet collaborative

Tools

Odoo ERP

Microsoft Excel

Power Query

VBA

Python

Job description

Job Description

Legrand has an exciting opportunity for a Jr. Business Analyst - ERP Data & Process Support to join the Electrical Infrastructure (EI) Team in Mississauga, ON. We are looking for a motivated and detail-oriented Junior Business Analyst to support ERP master data management, data uploads, process improvement initiatives, and business operations within our Odoo ERP environment. This role is ideal for someone with 1-2 years of experience who enjoys working with data, solving problems, learning new technologies, and finding opportunities to automate repetitive tasks.

Responsibilities

• Prepare, cleanse, validate, and upload ERP master data using company-developed Excel templates.
• Transform business data into ERP-ready formats for imports and updates.
• Review Excel files, identify data issues, and ensure accuracy before uploads.
• Utilize AI tools and automation techniques to reduce manual data processing effort.
• Assist in developing and improving scripts, workflows, and data import processes.
• Review PDF drawings and engineering documents to extract relevant product information.
• Create structured datasets for released sales orders and new product requirements.
• Create and maintain ERP records for new parts, assemblies, and product-related data.
• Support sales order creation and data entry activities within Odoo ERP.
• Work closely with engineering, operations, customer service, and business users to gather and validate information.
• Document procedures, data standards, and process improvements.

QUALIFICATIONS

• 1-2 years of experience in an ERP, data analyst, business analyst, or data coordination role.
• Experience with Odoo ERP is preferred but not required.
• Strong Microsoft Excel skills including formulas, lookups, filtering, and data manipulation.
• Ability to work with large volumes of structured data accurately.
• Strong analytical and problem-solving skills.
• Good verbal and written communication skills.

Technical Skills (Preferred)

• Exposure to AI tools such as Microsoft Copilot, ChatGPT, or similar solutions.
• Basic understanding of automation, scripting, Power Query, VBA, or Python is an asset.
• Experience with ERP data imports and exports is beneficial.
• Interest in learning AutoCAD or Autodesk Inventor for basic drawing interpretation.

What We Are Looking For

• High attention to detail and commitment to data accuracy.
• Strong organizational skills and ability to manage multiple tasks.
• Willingness to learn new systems, tools, and business processes.
• Positive attitude with a continuous improvement mindset.
• Ability to work independently while collaborating effectively with a team.

Growth Opportunity

• Hands-on experience with Odoo ERP and enterprise business processes.
• Exposure to AI-assisted automation and process improvement initiatives.
• Training and development opportunities in ERP systems, engineering data, and business analysis.
• Opportunity to contribute directly to digital transformation and operational efficiency projects.

Salary: $55,000-$65,000/annually

About Us

Legrand is the global specialist in electrical and digital building infrastructures. Its comprehensive offering of solutions for residential, commercial, and datacenter markets makes it a benchmark for customers worldwide. Bridging power from sources to pathways to touchpoints, Legrand’s Electrical Infrastructure division combines innovation and quality to provide leading solutions for an evolving energy landscape. Our expertly designed products enable customers to confidently address the complex needs and challenges of electrification, while enhancing everyday experiences like plugging in, switching on, and staying connected. Committed to best-in-class service at every stage, we act as a trusted partner for our customers to ensure each project’s success and their continued satisfaction. Legrand's Electrical Infrastructure division includes the following brands and product lines: Girtz, Avtron, Power Bus Way, Cablofil, Connectrac, Wiremold and Pass & Seymour. Legrand, North & Central America offers comprehensive medical, dental, and vision coverage, as well as distinctive benefits like a high employer 401K match, paid time off (PTO) and holiday pay, short-term and long-term disability benefit plans, above-benchmark paid maternity and parental leave, bonus opportunities in accordance with the Company’s incentive plans, paid time off to volunteer, and an active/growing Employee Resource Group network. For more information, visit legrand.us.