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.

• 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

• 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

• 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

• 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

• 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

• 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

• 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

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.