ERP & Analytics Strategist (Finance & Ops)

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 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.