Share this Job

Systems-Reporting Analyst

Date: Sep 14, 2021

Location: Brampton, ON, CA, L6T 1E5

Company: Novolex Holdings, LLC

At Novolex, we take pride in supporting our families across the globe. Our team is rich in diversity and our entrepreneurial culture encourages continuous personal growth and teamwork. Our careers include manufacturing, engineering, procurement, supply chain, finance, HR, product development, sales, marketing and an ever-expanding array of others to support our continuing rapid growth.



Job Title:

Systems / Reporting Analyst


Supervisor Title:

ERP Manager – Waddington North America (WNA)


Company and Location:

WNA (Polarpak) – Brampton, Ontario


Last updated:

2021 - August


Position Summary:

The Systems/Reporting Analyst is responsible for report design and maintenance, as well as general ERP support within Waddington North America’s Brampton, Ontario operation.  These responsibilities include AS/400 query writing and optimization, data mining, Microsoft Excel acumen, SSRS, and familiarity with the reporting and support needs of a 24/7 manufacturing and distribution operation.  Expertise with financial reporting and GL considerations is preferred.  Specific ERP experience is not required, but Epicor CMS is a plus.  The Systems/Reporting Analyst will also be responsible for incident resolution within established SLAs, management of enhancement requests, and encouraging processes and initiatives that maximize application capabilities while aligning with finance, accounting, operations, and IT best practices.   


Essential Functions & Key Responsibilities:


50% Report Development and Enablement

  • Analyze requirements and create reports (requests are primarily from finance)
  • Work with Query 400, SSRSI, and SQL
  • Monitor environment and ensure availability and integrity for all reports, reviewing processes and recommending solutions
  • Utilize data mining to improve processes


50% ERP Support and Enablement

  • Troubleshoot, support, and improve the use of Epicor CMS ERP
  • Perform ERP functional, integration, and regression testing as it pertains to patches and process improvement efforts
  • Train ERP users
  • Make continuous improvement recommendations
  • Prepare plans/status reports and track progress on the projects
  • Coordinate and manage application support with vendors and external consultants


Candidate Requirements:

  • Bachelors' degree in Computer Science, Information Systems or Information Technology, Engineering, or equivalent.  Junior level. 
  • The ideal candidate will have AS/400 and SQL reporting expertise within a manufacturing and/or distribution environment. 
  • ERP experience required. 


Essential for Reporting

  • AS/400 querying
  • SQL
  • SSRS
  • Experience with requirements for financial reporting and costing


Essential for ERP Support

  • ERP experience (Epicor CMS preferred, but any experience is valid)
  • Junior to mid-level Business Analyst skills and experience


In addition, WNA will be interested in candidates who possess many of the following skills:

  • Business Intelligence or other reporting applications
  • EDI
  • Microsoft Access
  • Visual Basic
  • Crystal Reports

Please no recruiting agencies

Following GMP in compliance with all food safety requirements.

Novolex does not publicly post salary information on job boards.

Novolex™ is committed to providing equal employment opportunity in all employment practices, including but not limited to, selection, hiring, promotion, transfer, and compensation to all qualified applicants and employees without regard to age, race, color, national origin, sex, pregnancy, sexual orientation, gender identity, religion, handicap or disability, genetics, citizenship status, service member or veteran status, or any other category protected by federal, state, or local law. Any individual, who because of his or her disability, needs an accommodation in connection with an aspect of the Company’s application process should contact human.resources@novolex.com.