Systems and Analytics Specialist

Matix Lumber Inc.; Rural Municipality of Headingley; On-site; CAD 70,000 - 100,000; Full time

Benefits offered by this job

Health benefits

Store/material discounts

Tuition reimbursement

Job summary

Matix Lumber Inc. seeks an Systems and Analytics Specialist to turn data into insights for decision-making. You will develop reports and dashboards, write SQL queries, and support BisTrack, Epicor, and GP systems in Finance and Operations. This role involves financial analysis, forecasting, and performance reporting for leaders.

The ideal candidate will have ERP experience, strong SQL skills, and proficiency with Phocas, Power BI, and Crystal Reports, plus advanced Excel capabilities.

Qualifications

• Post-secondary education in business, accounting, finance, information systems, data analytics, or a related field.
• Experience with ERP systems including reporting, data validation, user support, and process improvement.
• Strong SQL skills and the ability to write/optimize queries, views, and stored procedures.
• Experience developing reports and dashboards using Phocas, Power BI, or Crystal Reports.
• Advanced Excel skills for organizing, analyzing, and presenting data.

Responsibilities

• Write and optimize SQL queries, views, and stored procedures in BisTrack’s hosted environment.
• Develop and update reports, dashboards, and data extracts using Phocas, Power BI, and Crystal Reports.
• Support BisTrack workflows and reporting, including setup of new companies and data validation across systems.
• Prepare monthly, quarterly, and annual financial reports and forecasts for leadership and stakeholders.
• Assist in budgeting, forecasting, variance analysis, and KPI reporting.

Skills

SQL

Data analysis

Attention to detail

Communication

Education

Post-secondary degree in business/finance/IS/data analytics

Tools

Phocas

Power BI

Crystal Reports

Epicor BisTrack

Epicor Financials (GP)

Excel

Job description

Matix LumberInc. is a family and locally owned and operated professional building supplycentre that provides for all of your building needs. We are a building supply and projectcentre 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 buildingindustry and offer a comprehensive selection of quality lumber and buildingmaterials 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, mutuallybeneficial relationships with everyone we work with and have been able toachieve this through our industry experience, sound project execution, and visionary thinking.

The Systems andAnalytics 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 successfulcandidate will have duties such as, but not limited to:

• Write and optimize SQL queries, views, and storedprocedures in BisTrack’s hosted environment.


• Develop and update reports, dashboards, and data extracts for Finance, Operations, and Leadership, primarily using Phocas, Power BI, and (attimes) 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.

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 this selection process. Candidates requiring accommodations may contact [e-mail].

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