Technical Analyst, Finance - New York, United States - A+E Networks

A+E Networks
A+E Networks
Verified Company
New York, United States

4 weeks ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
Description

Work Locations:

_ _With the exception of some select roles that have In-Office requirements, most temporary or third party payroll workers should expect to work remotely, unless otherwise discussed.

_

Division Story

Most people don't realize the importance of the Finance department in keeping our business operating without hitches and delays. That's probably because we oversee many of the more quietly glamorous, back-office functions that drive our bottom line.

We not only forecast, build and manage budgets, we also collect and analyze important data that helps leadership make the best decisions.

All of this sounds exciting to you because you love numbers and spreadsheets, and especially love great entertainment.


Job Description:


THE ROLE:
Technical Analyst - Finance & Accounting


The Technical Analyst, Finance & Accounting will be responsible for maintaining, enhancing, and troubleshooting the Excel-based workforce planning solution and collaborating with all key stakeholders to ensure a seamless annual budgeting process.

The workforce planning solution is high in complexity with heavy VBA overlays and interdependencies between multiple spreadsheets.

This role will be responsible for distributing the spreadsheets to all workforce planners throughout the A+E organization via SharePoint and will collaborate closely with HR, Finance & Accounting, and Division Heads and their respective organizations to support the company-wide workforce planning process.


MORE ABOUT WHAT YOU'LL DO:
Application Support

  • Support fully the Excel
- based workforce planning solution/process, utilizing the following technical skills:

  • Microsoft VBA
  • Visual Basic for Applications


  • Microsoft Power BI

  • Power Query Office 365 Excel
  • Excel Formulas and Macros
  • Office 36
  • Sharing via SharePoint and OneDrive
  • Engage in knowledge transfer from the current A+E resource to be able to support all issues that may arise during the workforce planning process
  • Coordinate with the current A+E resource to ensure all required datasets, including market data, are populated in the Excel sheets
  • Perform an endtoend test of the workforce planning process to ensure there are no solutionrelated bugs prior to distribution of the spreadsheets
  • Ensure data integrity and that all data in each Excel sheet is appropriate for each end user given the confidential nature of the data
  • Distribute all Excel sheets via SharePoint to the relevant workforce planning partners
  • Provide all necessary data from the submitted Excel spreadsheets to the Accounting Lead for reporting purposes
  • Document, address and resolve any endtoend process related issues

YOUR STORY:
[+BEHAVIORS] _(what you need to have)_

  • Proficiency in writing and debugging VBA code.
  • Ability to create and use macros for automating repetitive tasks.
  • Knowledge of Excel objects, properties, and methods.
  • Experience with user forms and controls to create interactive spreadsheets.
  • Understanding of error handling and performance optimization in VBA.
  • Strong teamwork and interpersonal skills
  • Excellent communication skills and ability to persuade at all management levels
  • Highest level of ownership, accountability and integrity
  • Ability to question, evaluate, and make decisions

Desired:

  • Experience supporting confidential data with standalone solutions in MS Office 365 within small to midsized privately held organizations
  • Specific project and process support experience with an awareness of general accounting best practices in employee compensation, headcount budgeting and workforce planning


Please note project assignment associates are engaged to provide service to A+E Networks on a temporary basis in connection with a specific project.

Project assignment associates are hired and employed through a third party vendor with a duration/tenure of no longer than eighteen (18) months.

Compensation


Contract Hourly Pay Rate:
$90.00

  • The pay rate_ displayed serves as a_ good faith estimate_ _for this role._
  • Compensation for the role_ will be based on _a _number of different _factors_
  • A+E Television Networks is a joint venture of the Hearst Corporation and The Walt Disney Company._
  • We are proud to be an Affirmative Action/Equal Opportunity _Employer/Disabled/Veterans._
More jobs from A+E Networks
See all jobs of A+E Networks