FP&A Data Consultant

Our Client is sourcing for an FP&A Data Consultant for a 6 month contract.

Position Overview
We are seeking a skilled Financial Modeling & Analytics Specialist to modernize and enhance our forecasting capabilities. This role will be responsible for transforming legacy Excel-based forecasting models into advanced, automated solutions that integrate seamlessly with our financial systems and provide comprehensive analytical insights.

Key Responsibilities

Redesign and rebuild existing Excel forecasting models using advanced modeling techniques

Develop automated budget and forecast generation processes

Create dynamic models capable of producing multiple scenario analyses

Implement macros, SQL queries, and other programming solutions to enhance model functionality

Data Integration & Reporting

Build data connections between forecasting models and Quick Books system

Create variance analysis reports (actuals vs. budget)

Develop reforecasting tools based on changing key assumptions

Generate sensitivity analysis outputs for various business scenarios

Technical Implementation

Write and maintain SQL queries for data extraction and manipulation

Develop VBA macros and other automation tools

Ensure data integrity and accuracy across all model outputs

Create user-friendly interfaces for non-technical stakeholders

Required Qualifications
Technical Skills

Programming Experience :
Proficiency in SQL, VBA macros, and/or other programming languages

Advanced Excel :
Expert-level skills including complex formulas, pivot tables, and data modeling

Database Management :

Experience with data extraction, transformation, and loading processes

Financial Systems :
Familiarity with Quick Books or similar accounting software

Professional Background

3-5 years experience in financial modeling, FP&A, or business analytics

Strong understanding of budgeting and forecasting processes

Experience building automated financial reporting solutions

Background in model validation and testing

Analytical & Communication Skills

Strong analytical thinking and problem-solving abilities

Ability to translate business requirements into technical solutions

Excellent documentation and training capabilities

Experience presenting complex data insights to various stakeholders

Preferred Qualifications

Bachelor's degree in Finance, Accounting, Economics, or related field

Professional certifications (CPA, CFA, or equivalent)

Experience with business intelligence tools (Power BI, Tableau, etc.)

Knowledge of financial planning software platforms

Previous experience modernizing legacy financial systems

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  #469833

You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity.

EEO Notice
Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.

Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided with reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, or to receive other benefits and privileges of employment, please contact  Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.

#J-18808-Ljbffr