FP&A Data Consultant

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

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
• 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

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.

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.