Senior Finance Specialist - 12 month contract
- Toronto, ON, Canada
- Greater Toronto Area, Canada, Canada
$50 to $60 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $50 to $60 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
This is a 12 month contract with permanent potential
Key Responsibilities
- Develop, maintain, and optimize complex Microsoft Excel financial models, reports, and analysis.
- Create and maintain VBA macros to automate repetitive processes and efficiently manage complex and large datasets.
- Use Advanced Excel functions, formulas, pivot tables, data models, and other tools to analyze and report financial information.
- Develop and maintain Power Query processes and data connections to extract, transform, consolidate, and prepare data for reporting.
- Work with large data files and develop efficient solutions to consolidate, validate, and reconcile data from multiple sources.
- Create, run, and maintain financial reports using OneStream.
- Support the development and optimization of OneStream reporting and financial data processes.
- Work with SAP and S/4HANA systems to extract, analyze, reconcile, and report financial information.
- Develop and maintain Power BI dashboards and reports to provide management with meaningful financial and operational insights.
- Partner with Accounting and Finance teams to ensure data accuracy, completeness, and consistency.
- Prepare and analyze financial information related to the Profit & Loss (P&L), Balance Sheet, and other financial statements.
- Investigate data discrepancies and perform financial reconciliations as required.
- Identify opportunities to automate manual processes and improve reporting efficiency.
- Document reporting processes, procedures, and system solutions.
- Prepare presentations and management reporting using Microsoft PowerPoint.
- Prepare, format, and maintain documentation and reports using Microsoft Word.
- Work collaboratively with Finance, Accounting, IT, and other business teams on reporting and data-related projects.
Required Qualifications & Skills
- Strong background in Accounting and Finance, with a good understanding of:
- Profit & Loss statements
- Balance Sheets
- Financial reporting
- Account reconciliation
- Financial data analysis
- Advanced Microsoft Excel skills.
- Strong VBA programming skills, with the ability to create macros and automate complex processes.
- Advanced knowledge of Power Query and data connections.
- Experience working with OneStream, including running and creating reports.
- Experience with SAP and S/4HANA.
- Strong Power BI skills, including dashboard and report development.
- Ability to work with and consolidate large data files and datasets.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and commitment to data accuracy.
- Proficiency with Microsoft Word and PowerPoint.
- Ability to translate complex financial data into clear and useful reporting for business stakeholders.
More about this job
Responsibilities
Develop and maintain financial models, reports, dashboards, and data processes using Excel, VBA, Power Query, OneStream, SAP/S/4HANA, and Power BI. Analyze and reconcile financial data, improve reporting efficiency through automation, document processes, and collaborate with Finance, Accounting, IT, and other teams.
Requirements
Requires a strong Accounting and Finance background, advanced Excel and VBA skills, and experience with Power Query, OneStream, SAP/S/4HANA, and Power BI. Candidates should be able to analyze and consolidate large datasets, ensure data accuracy, solve problems, and communicate financial insights clearly to business stakeholders.
Skills
- Advanced Microsoft Excel
- VBA Programming
- Power Query
- OneStream
- SAP
- S/4HANA
- Power BI
- Financial Modeling
- Financial Reporting
- Account Reconciliation
- Financial Data Analysis
- Data Consolidation
- Process Automation
- Microsoft Word
- Microsoft PowerPoint
- Analytical Problem-Solving
Visa sponsorship
Not detected in the job text
Categories
- Finance & Accounting
- Data & Analytics
- Technology
Keywords
- Accounting
- Finance
- Financial Modeling
- Microsoft Excel
- VBA
- Macros
- Pivot Tables
- Data Models
- Power Query
- Data Connections
- OneStream
- SAP
- S/4HANA
- Power BI
- Dashboards
- Profit & Loss
- Balance Sheet
- Financial Statements
- Financial Reporting
- Account Reconciliation
- Data Analysis
- Data Consolidation
- Data Validation
- Process Automation
- Microsoft PowerPoint
- Microsoft Word
- Management Reporting