Excel Specialist – North Vancouver Recreation & Culture (North Vancouver, BC)

Excel Specialist (Short-Term)

Contract
Competition #20003C

North Vancouver Recreation & Culture (NVRC) is dedicated to building healthy individuals, families and communities. We offer a wide range of recreation and cultural programs and services to residents of all ages and abilities.

NVRC is seeking a Microsoft Excel expert for a contract employment opportunity. For this role, you need to have a strong understanding of Microsoft Excel, with expert proficiency in pivot tables, conditional formatting, VBA, forecast & trend tools.

Key Competencies and Areas of Responsibility:

• Build tools for presenting and analyzing participation data from recreation program and membership database.
• The product of the tools will be a dashboard and  customized reports based on the data provided in CSV or excel format
• The tool must  provide the ability to input data from the registration system with selections of what is to be shown in the report
• The database  source data will be exported in CSV or excel format
• Tool must be tested by Excel expert to ensure good working order for field testing
• Implement changes from field testing
• The Excel specialist needs to:
  • Demonstrate the ability to communicate effectively, providing regular feedback and using initiative to ensure optimal results
  • Think outside the box when solving complex Excel challenges
  • Instill confidence in their ability to perform and meet agreed deadlines
  • Approach projects with a clear and methodical plan

Your expertise will include:

• Expert knowledge and experience with the following:
  • Excel Worksheets
  • Advanced Charting
  • Functions
  • Advanced Formulae
  • Tool Bars
  • VLOOKUP
  • INDEX + MATCH
  • Conditional Formatting
  • PIVOT Tables & PIVOT Reporting
  • VBA & Macros
  • Data Tables, Simulations & solver
  • Functions for data cleaning and manipulation: Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions, IfError, Short-Cut
• Ability to write Macros, advanced formulas and work with key stakeholders to ensure the customized dashboard and reports meet business need
• Understanding of the process of building and testing the Excel tool
• Understanding of how data spreadsheets relate to the dashboard and customized reports is essential
• Experience with analysis and interpretation of complex data
• The ability to work independently and to adhere to agreed deadlines
• Strong computer proficiency and work experience in Microsoft Windows environments
• Strong analytical skills
• Excellent oral and written communication skills
• Detail oriented
• Manage priorities and time appropriately
• Excellent organizational skills 

Additional experience and knowledge:

• Previous work or knowledge of sales and/or participation data analysis is preferred
• Knowledge of public community recreation industry is an asset

Contract length:
The contract will be for a set number of hours over an approximate 6-week period.  Additional projects may be offered after the successful completion of the contract.

Work Location:
This contract offers flexibility in hours and the ability to work remotely.

Compensation:
As per candidate’s experience

CLOSING DATE:   
February 10, 2021

APPLY ONLINE AT: 
https://nvrc.peopleadmin.ca/postings/1232    

We thank you for your interest in employment with North Vancouver Recreation & Culture and advise that only those selected for an interview will be contacted.