Jr. Business Analyst – ERP Data & Process Support

Job summary

The role involves managing ERP master data, cleansing and validating datasets, and performing data uploads using Excel templates. Additionally, the analyst will assist in process improvement initiatives, automation efforts, and cross-functional collaboration to support business operations.

Job details

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 Qualifications/Experience: * 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 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.

What you’ll do

The role involves managing ERP master data, cleansing and validating datasets, and performing data uploads using Excel templates. Additionally, the analyst will assist in process improvement initiatives, automation efforts, and cross-functional collaboration to support business operations.

Requirements

Candidates should have 1-2 years of experience in data or business analysis roles with strong proficiency in Microsoft Excel. Familiarity with ERP systems, automation tools, and a detail-oriented approach to problem-solving are essential for this position.

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• 401k match
• Paid time off
• Holiday pay
• Short-term disability
• Long-term disability
• Maternity leave
• Parental leave
• Bonus opportunities
• Volunteer time off

Listed skills

• Problem solving · Preferred
• Data Validation · Preferred
• Microsoft Excel · Preferred
• Communication Skills · Preferred
• Process Improvement · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• ERP master data management
• Microsoft Excel
• Data cleansing
• Data validation
• Odoo ERP
• Automation
• Process improvement
• Analytical skills
• Problem-solving
• Communication skills
• AI tools
• Scripting
• Power Query
• VBA
• Python
• Drawing interpretation
• Microsoft Copilot
• ChatGPT
• Operational Efficiency
• Business Operations
• Workflow Management
• Organizational Skills
• Time Off Management
• Positivity
• Schema Markup
• Willingness To Learn
• Digital Transformation
• AutoCAD
• Data Analysis
• Autodesk Inventor
• Business Analysis
• Business Process
• Customer Service
• Communication
• Data Processing
• Continuous Improvement Process
• Training And Development
• Data Entry
• Data Manipulation
• Enterprise Resource Planning
• Sales
• Innovation
• Problem Solving
• Python (Programming Language)
• New Product Development
• Operations
• Visual Basic For Applications
• Process Improvement
• Data Import/Export
• Templates

Job areas

• Data & Analytics
• Technology
• Manufacturing
• Administrative
• Energy
• Business Process Analyst
• General ERP Analyst / Consultant
• Management and Organization Analysts
• Business Intelligence Analysts
• Data Scientists