Systems and Analytics Specialist

Matix Lumber; Rural Municipality of Headingley; Presencial; CAD 70.000 - 100.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health benefits

Store discounts

Tuition reimbursement

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SQL

Data analytics

Power BI

Forecasting

KPI reporting

Data analysis

ERP systems

Communication

Educación

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

Herramientas

BisTrack

Epicor BisTrack

Epicor Financials (GP)

Phocas

Power BI

Crystal Reports

Descripción del empleo

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.