Financial Data Analyst

IS2 Workforce Solutions; Abbotsford; On-site; CAD 75,000 - 105,000; Full time

Job summary

IS2 Workforce Solutions in Abbotsford, British Columbia is seeking a Financial Data Analyst to transform complex data into actionable business insights. You will focus on FP&A, costing, and financial reporting, collaborating with Finance and operations teams.

Responsibilities include building budgeting models, dashboards in Power BI, developing scalable data solutions with SQL, and ensuring data accuracy across ERP systems.

Qualifications

• Bachelor's degree in Business, Accounting, Finance, or related discipline.
• 3–7 years of experience in financial analysis, FP&A, or data analytics.
• Experience with ERP platforms (SAP, Oracle, Microsoft Dynamics, NetSuite, JD Edwards).
• Strong analytical and communication skills.

Responsibilities

• Analyze financial and operational data to identify trends and risks.
• Develop and maintain budgeting, forecasting, and variance analyses.
• Create Power BI dashboards and financial reporting solutions.
• Support ERP-based financial reporting and cost accounting initiatives.

Skills

Financial analysis

Power BI

SQL

Costing & FP&A

Data visualization

Data storytelling

Education

Bachelor's degree in Business, Accounting, Finance, or related

Tools

SAP

Oracle

Microsoft Dynamics

NetSuite

JD Edwards

Job description

Are you a finance professional who enjoys turning complex data into clear business insights? We’re looking for a Financial Data Analyst to join our clients team in Abbotsford, British Columbia.

This role combines financial analysis, FP&A, business intelligence, data analytics, costing, and financial reporting. You’ll work closely with Finance and operational teams to improve reporting, support decision-making, build financial models, and uncover opportunities to improve business performance.

Key Responsibilities

• Analyze financial and operational information to uncover trends, performance drivers, potential risks, and opportunities.
• Prepare and maintain recurring management reports, dashboards, and key performance indicators.
• Contribute to annual budgeting, forecasting, and financial variance analysis.
• Translate financial results into practical insights and recommendations for business leaders.
• Support management with ad hoc financial analysis and decision-making as required.
• Develop and maintain financial models used for budgeting, forecasting, scenario planning, and strategic initiatives.
• Create models to evaluate profitability, pricing, cost structures, and allocation methodologies.
• Conduct sensitivity, trend, and what-if analyses to assess business decisions, investments, and operational changes.
• Ensure financial models are accurate, scalable, well-documented, and aligned with business requirements.
• Build and enhance interactive Power BI dashboards and management reporting solutions.
• Extract, transform, and analyze data using SQL, Power Query, and related data-query tools.
• Identify opportunities to improve data quality, reporting consistency, process automation, and overall efficiency.
• Work closely with finance and operational stakeholders to understand reporting needs and develop effective data solutions.
• Help establish reliable and repeatable processes for financial and operational reporting.
• Support product, operational, and standard costing activities, including margin and profitability analysis.
• Analyze manufacturing, distribution, and other operating costs to identify trends, cost drivers, and potential efficiency improvements.
• Maintain, review, and validate financial information within ERP systems.
• Collaborate with Operations, Supply Chain, Accounting, and other teams to improve cost visibility and reporting accuracy.
• Assist with the development and enhancement of ERP-based financial reporting.
• Apply sound accounting principles to support accurate and consistent financial reporting.
• Assist with monthly and year-end close and reporting activities.
• Support account reconciliations, audit requests, and internal control processes.
• Investigate discrepancies and help ensure financial information is complete, accurate, and properly supported.
• Validate the consistency and integrity of data flowing between ERP systems and reporting platforms.
• Advanced Microsoft Excel skills, including PivotTables, Power Query, advanced formulas/functions, and financial modeling.
• Strong Power BI skills, with experience developing dashboards and presenting data through effective visualizations.
• Proficiency in SQL, including the ability to write, troubleshoot, and optimize queries against relational databases.
• Strong understanding of data management, reporting automation, and business analytics practices.
• Familiarity with ERP reporting environments and financial data structures.
• Strong analytical, critical-thinking, and problem‑solving skills.
• Exceptional attention to detail and commitment to data accuracy.
• Ability to turn complex financial and operational information into clear, actionable business insights.
• Strong communication and presentation skills, with the ability to work effectively with both technical and non‑technical stakeholders.
• Demonstrated ability to prioritize competing demands, manage multiple projects, and deliver results within deadlines.

Education

• Bachelor's degree in Business, Accounting, Finance, or a related discipline, or an equivalent combination of education and experience.
• CPA designation is not required.

Experience & Qualifications

• 3–7 years of experience in financial analysis, business analysis, data analytics, FP&A, or a related finance function.
• Demonstrated experience developing financial models and performing detailed financial analysis.
• Hands‑on experience with ERP platforms such as SAP, Oracle, Microsoft Dynamics, NetSuite, JD Edwards, or comparable systems.
• Practical knowledge of costing, financial reporting, and general accounting processes.
• Experience in manufacturing, distribution, supply chain, or other operationally focused finance environments is an asset.
• Familiarity with data warehousing concepts and business intelligence technologies.
• Experience with forecasting, scenario modeling, and advanced financial or operational analytics.
• Working knowledge of cost accounting principles and profitability analysis.