Senior Financial System Analyst

Job summary

Develop and optimize complex financial models and reports using Excel, VBA, and Power BI. Manage financial data extraction and reconciliation across OneStream and SAP S/4HANA systems to provide operational insights.

Job details

Our client is looking for a Senior Financial Systems Consultant for a 12-month contract 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. Preferred Qualifications · Degree or diploma in Accounting, Finance, Business, Information Systems, Data Analytics, or a related field. · 3+ years of experience in financial reporting, financial systems, data analysis, or a related role. · Experience working in a corporate Finance or Accounting environment. · Experience automating financial reporting and accounting processes. · Experience integrating data from multiple financial systems and sources. · Experience developing management dashboards and financial reporting solutions By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions. How to Apply Click the “Apply Now” button and follow the instructions to submit your resume. Please note that we only accept documents in MS Word or Rich Text formats. When referencing this job, quote #304402. ----- DISCLAIMERS ----- This position for employment is for a current vacancy with Highspring’s client. You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role. By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present you as a candidate for the foregoing position. Additionally, you agree to be included in our talent pool for future hiring for similarly qualified positions. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. Lastly, you also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal. Vaco by Highspring values a diverse workplace and strongly encourages women, people of colour, LGBTQ+ individuals, people with disabilities, members of ethnic minorities, foreign-born residents, and veterans to apply. The company is also committed to ensuring that persons who need them are provided with reasonable accommodations; if one is needed to participate in the job application or interview process, please contact HR@vaco.com . Vaco by Highspring respects your privacy and is committed to providing transparent notice of our policies in English here and in French here. Additionally, the company uses AI to perform preliminary screenings, focused on ensuring minimum job requirements noted in the position are satisfied. Further assessment of candidates beyond this initial phase will be conducted by recruiters and hiring managers. Vaco/Highspring does not know and cannot opine on if its client’s use of AI products in hiring. Pay Transparency Notice Determining compensation for this role (and others) at Vaco by Highspring depends upon a wide array of factors including but not limited to: the individual’s skill sets, experience and training; licensure and certification requirements; office location and other geographic considerations; other business and organizational needs. Having said that Vaco by Highspring believes that the salary range referenced reasonably estimates the base compensation for an individual hired into this position. The individual may also be eligible for discretionary bonuses and/or participation in medical, dental, and vision benefits as well as the company’s retirement plan (or similar retirement benefits).

What you’ll do

Develop and optimize complex financial models and reports using Excel, VBA, and Power BI. Manage financial data extraction and reconciliation across OneStream and SAP S/4HANA systems to provide operational insights.

Requirements

Requires a strong background in accounting and finance with advanced proficiency in VBA, Power Query, and Power BI. Experience with OneStream and SAP S/4HANA is essential for managing large financial datasets.

Benefits

• Medical Insurance • Dental Insurance • Vision Insurance • Retirement Plan • Discretionary Bonuses

Listed skills

• Power BI · Preferred
• Financial Reporting · Preferred
• Data analysis · Preferred
• Microsoft Word · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Advanced Microsoft Excel
• VBA Programming
• Power Query
• OneStream
• SAP S/4HANA
• Power BI
• Financial Modeling
• Financial Reporting
• Account Reconciliation
• Data Analysis
• P&L Analysis
• Balance Sheet Analysis
• Data Consolidation
• Microsoft PowerPoint
• Microsoft Word
• Financial Systems Optimization

Job areas

• Finance & Accounting
• Data & Analytics
• Consulting
• Technology
• Management & Leadership