Systems and Analytics Specialist

Matix Lumber Inc. is a family and locally owned and operated professional building supply centre that provides for all of your building needs. We are a building supply and project centre providing project providing contractors and do-it yourself builders with the tools, materials, design, and construction services to support projects of any scale.

Matix Lumber services all sectors of the building industry and offer a comprehensive selection of quality lumber and building materials manufactured by North America’s leading producers. We provide contractors, avid builders DIYers, and community leaders the tools, construction service, and design expertise to support residential and commercial projects – from start to finish.

We believe in building collaborative, mutually beneficial relationships with everyone we work with and have been able to achieve this through our industry experience, sound project execution, and visionary thinking.

The Systems and Analytics Specialist helps turn reliable data into useful information for decision-making across the company. Reporting to the Chief Financial Officer, this role supports BisTrack and other business systems, develops reports and dashboards, and works with Finance and Operations to improve processes and resolve system issues. The specialist also supports financial analysis, forecasting, and performance reporting to help leaders understand results and plan ahead.

The successful candidate will have duties such as, but not limited to:

• Write and optimize SQL queries, views, and stored procedures in BisTrack’s hosted environment.
• Develop and update reports, dashboards, and data extracts for Finance, Operations, and Leadership, primarily using Phocas, Power BI, and (at times) Crystal Reports.
• Work with teams to customize BisTrack workflows and reporting.
• Support the setup of new companies and the maintenance of existing companies, including systems oversight in BisTrack and GP and validation of data.
• Support the team with accounts payable (AP) automation.
• Set up reporting access and permissions for new employees and provide related training.
• Work with Epicor support to resolve escalated data and reporting issues.
• Stay current on changes to Epicor BisTrack and Epicor Financials by attending webinars and reviewing training materials. Communicate relevant updates and changes in requirements to affected teams.
• Develop a technical understanding of Procore and help internal users troubleshoot issues. Act as the company’s representative with Procore support when needed.
• Gather financial data from departments, analyze trends, and help prepare forecasts and budgets.
• Develop financial models that support strategic decisions and identify opportunities for improvement.
• Monitor key performance indicators (KPIs) and provide insights to senior management.
• Prepare monthly, quarterly, and annual financial reports and presentations for internal and external stakeholders. Work with the CFO to determine how best to present the information and ensure the underlying data is accurate.
• Conduct variance analysis with the CFO and recommend ways to improve financial performance.
• Help develop and implement financial systems and processes that improve operations.
• Support ad hoc analysis and projects as needed.
• Perform other duties as assigned.

The ideal candidate will have:

• Post-secondary education in business, accounting, finance, information systems, data analytics, or a related field, or an equivalent combination of education and experience.
• Experience working with ERP systems, including reporting, data validation, user support, and process improvement. Experience with Epicor BisTrack and Epicor Financials (GP) is an asset.
• Strong SQL skills, including the ability to write and optimize queries, views, and stored procedures.
• Experience developing reports, dashboards, and data extracts. Experience with Phocas, Power BI, or Crystal Reports is an asset.
• Advanced Excel skills, including the ability to organize, analyze, and present complex data.
• Experience with financial reporting, budgeting, forecasting, variance analysis, and KPI reporting.
• Ability to build financial models and turn data into clear, practical insights for leaders.
• Strong attention to detail and the ability to validate data across systems before it is used in reports or decisions.
• Ability to troubleshoot system and reporting issues, work with software support teams, and explain solutions to users. Experience with Procore or AP automation is an asset.
• Strong communication and training skills, with the ability to work effectively with Finance, Operations, and other departments.
• Ability to manage competing priorities, work independently, and follow through on projects and requests.

Our employees enjoy a full range of health benefits and other Company perks including benefits, store and material discounts, tuition reimbursement and much more.

If you are interested in this exciting opportunity with Matix Lumber, apply today with your resume.

Matix Lumber is an equal opportunity employer and is committed to fostering a diverse workforce that is equitable and inclusive for all. Matix Lumber provides equal employment opportunity to all employees and applicants without regard to an individual’s protected status under the Human Rights Code including but not limited to: race/ethnicity, persons with disabilities, members of visible minorities, religion, creed, sex or gender, sexual orientation, gender identity or expression, family or marital status, pregnancy/childbirth or related conditions, national origin, military or veteran status, or any other protected status. Accommodations are available upon request throughout all aspects of the selection process. Candidates requiring accommodations may contact [email protected].

We thank all candidates for their interest, only those selected for an interview will be contacted.