Data-Driven Systems & Analytics Specialist

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

Benefits offered by this job

Health benefits

Store discounts

Tuition reimbursement

Job summary

Matix Lumber is seeking a Systems and Analytics Specialist to turn reliable data into useful information for decision-making. You will develop reports and dashboards, work with BisTrack, Epicor, Phocas, Power BI and Crystal Reports, and support financial forecasting and budgeting across Finance and Operations.

The role requires strong SQL, Excel, and data-analytic capabilities, with experience in ERP systems and KPI reporting.

Qualifications

• Post-secondary education in business, accounting, finance, information systems, data analytics or equivalent.
• Experience with ERP systems, reporting, data validation, user support, and process improvement.
• Strong SQL skills to write and 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.
• Experience with financial reporting, budgeting, forecasting, variance analysis, and KPI reporting.
• Ability to build financial models and turn data into actionable insights.

Responsibilities

• 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 using Phocas, Power BI, and Crystal Reports.
• Configure BisTrack workflows and reporting with business teams.
• Support new company setups and maintenance of existing ones, including BisTrack, GP validation.
• Assist AP automation and grant reporting access to new users with training.
• Collaborate with Epicor support to resolve data and reporting issues.
• Summarize financial data for forecasts and budgets; monitor KPIs for senior management.
• Stay current with Epicor BisTrack and Epicor Financials updates via webinars and training.
• Troubleshoot reporting issues and communicate solutions to users; assist with Procore as needed.
• Provide clear, practical insights and supporting data to leadership.

Skills

SQL

Data analytics

Power BI

Forecasting

KPI reporting

Data analysis

ERP systems

Communication

Education

Post-secondary education in business, accounting, finance, information systems, data analytics

Tools

BisTrack

Epicor BisTrack

Epicor Financials (GP)

Phocas

Power BI

Crystal Reports

Job description

Matix Lumber is seeking a Systems and Analytics Specialist to turn reliable data into useful information for decision-making. You will develop reports and dashboards, work with BisTrack, Epicor, Phocas, Power BI and Crystal Reports, and support financial forecasting and budgeting across Finance and Operations.

The role requires strong SQL, Excel, and data-analytic capabilities, with experience in ERP systems and KPI reporting.