Excel Specialist

IT - Application & Software Development
Mississauga, ON
Contract
Oct 20, 2021

Duration: 3-6 months initially

 

Our Client..

A Canadian household name. One of Canada's best to work for..

 

Responsibilities

  • Learn/understand the existing Full Year Forecast model process and functions
    • Document all Existing Functions/Macros in Existing Full Year Forecast Model
      • Step-by-step documentation of how data gets captured from input sheet, processed and outputted.
  • Propose a documentation approach to track future changes (change, testing, version control etc.)
  • Work with Financial Planning and Analysis (FP&A) team to review, evaluate and propose changes to existing Full Year Forecast model to address:
    • Reduction of file size (reduction of crash risk) and improve run-time efficiency:
      • Elimination of redundant tabs/data
      • Clean up or re-write existing functions for efficiency
    • Process to roll-over data to a new fiscal year or month
    • Update existing model to automate recently added manual changes 
  • Work with FP&A team to review, evaluate and propose changes to existing model to improve automation of data loading and extracts,  automate validation of data inputs from OUs and improve security measures that could be implemented without impairing or impeding the functionality of the model

 

 Must Have:

    • Advanced proficiency in Excel specifically managing complex workbooks with embedded worksheets with VBA scripts/macros
    • Experience with user requirements, design/develop, test and deployment of a solution
    • Strong documentation skills
      • Coding and Functionality
    • Detail oriented with strong analysis capability
      • Ability to assess technical/solutions options (including change impact to the end user)
    • Ability to provide knowledge transfer to key Subject Matter Experts on the team
    • Ability to work independently and manage timelines
  • Nice to have skills
    • Finance background or experience

 

Send to Friend

Send to Friend