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.
Apply Today!
