Financial Data Analyst

IMP Group; Abbotsford; On-site; CAD 75,000 - 110,000; Full time

Job summary

Cascade Aerospace in Abbotsford is seeking a Financial Data Analyst to transform large sets of financial and operational data into actionable insights. You will support budgeting, forecasting, and management reporting using advanced Excel, Power BI, and SQL querying tools.

The role emphasizes developing dashboards, cost analysis, and ERP data integrity across finance processes. CPA designation is not required, but strong analytics, business intelligence, and collaboration with stakeholders are

Qualifications

• Strong analytical, financial modeling, and BI skills.
• Proficiency in Excel and data visualization required.
• Ability to translate complex financial data into actionable insights.

Responsibilities

• Analyze large volumes of financial and operational data to identify trends, risks, and opportunities.
• Develop and maintain recurring financial reports, dashboards, and KPIs.
• Support budgeting, forecasting, and variance analysis processes.
• Build and enhance financial models for budgeting, forecasting, scenario analysis.
• Design and maintain Power BI dashboards and reports.
• Coordinate with operations and accounting to improve cost visibility and reporting.

Skills

Analytical thinking

Data storytelling

Attention to detail

Problem solving

Communication

Tools

Power BI

SQL

Power Query

ERP systems

Job description

Join Our Team

Cascade Aerospace is one of Canada's leading specialty aerospace and defence contractors - a place where we do cool things for great customers! We invite you to consider a career with us - come, experience our creative, innovative, and performance-based company!

Job Description

Financial Data Analyst supports financial planning, reporting, costing, and business decision-making through advanced data analysis and financial modeling. The ideal candidate will have strong expertise in Excel, Power BI, and database querying tools, combined with a solid foundation in accounting and ERP systems. This role will transform complex financial data into actionable insights that drive operational and financial performance. CPA designation is not required. Candidates with strong analytical, financial modeling, and business intelligence skills are encouraged to apply.

This position requires immediate Controlled Goods clearance, therefore, only Canadian Citizens or Permanent Residents will be considered at this time.

Major Responsibilities & Duties

Financial Analysis & Reporting

• Analyze large volumes of financial and operational data to identify trends, risks, and opportunities.
• Develop and maintain recurring financial reports, dashboards, and KPIs.
• Support budgeting, forecasting, and variance analysis processes.
• Provide actionable recommendations to management based on financial and business performance.

Financial Modeling

• Build, maintain, and enhance financial models for budgeting, forecasting, scenario analysis, and strategic decision-making.
• Develop profitability, pricing, and cost allocation models.
• Perform sensitivity and trend analyses to support business initiatives and investments.

Business Intelligence & Data Analytics

• Design and maintain interactive dashboards and reports using Power BI.
• Extract, transform, and analyze data using SQL, Power Query, and other query tools.
• Improve data quality, reporting accuracy, and automation across finance processes.
• Collaborate with business stakeholders to define reporting requirements and data solutions.

Costing & ERP Systems

• Support product costing, operational costing, and margin analysis initiatives.
• Analyze manufacturing, distribution, or operational costs to identify efficiency opportunities.
• Maintain and validate financial data within ERP systems.
• Partner with operations, supply chain, and accounting teams to improve cost visibility and reporting.

Accounting & Financial Controls

• Apply general accounting principles to ensure accuracy and consistency in reporting.
• Support month-end and year-end financial reporting activities.
• Assist with account reconciliations, financial audits, and internal controls as required.
• Ensure data integrity between ERP systems and reporting platforms.

Core Skills

• Advanced proficiency in Microsoft Excel, including:PivotTables,Power Query, Advanced formulas and functions, andFinancial modeling
• Strong proficiency in Power BI dashboard development and data visualization.
• Experience writing and optimizing SQL queries and working with relational databases.
• Strong understanding of data management, reporting automation, and analytics best practices.
• Familiarity with ERP reporting tools and financial data structures.
• Strong analytical and problem-solving abilities.
• Excellent attention to detail and data accuracy.
• Ability to translate complex financial data into clear business insights