FP&A Data Consultant

Financial Modeling & Analytics Specialist – 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.

About the Opportunity
Model Development & Enhancement

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

Design automated report generation capabilities

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

About You
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

Pay Rate:  $50.00/Hour

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.

Location:

Must currently reside within the Greater Toronto Area and be permitted to work in Canada.

#J-18808-Ljbffr