Technical Analyst, Finance & Accounting Remote

Job Description

Technical Analyst, Finance & Accounting (Temporary) Remote

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 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 365
• 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 end-to-end test of the workforce planning process to ensure there are no solution-related 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 end-to-end process related issues

YOUR STORY: [+BEHAVIORS] (what you need to have)
• 5+ years of strong hands-on Excel VBA, macro and Power BI development experience. More specifically, the candidate must have the following:
• 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.
• Demonstrate business acumen and the ability to apply technology solutions to solve business problems
• 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 mid-sized 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

such as a candidate's qualifications, skills, competencies, location, and

experience. Learn more at aenetworks.com/careers.

A+E Networks proudly provides equal employment opportunity for all employees and job applicants, and makes employment decisions consistent with this principle. The company's employment actions and decisions – including recruitment, hiring, training, promotion, demotion, compensation, transfer, layoff, and termination – are made without regard to an employee's race, color, religion, creed, age, national origin, ancestry, sex (which includes pregnancy, childbirth, breastfeeding, and related medical conditions), gender, sexual orientation, gender identity, gender expression, marital status, alienage or citizenship status, physical and/or mental disability, medical condition, family and medical leave status, genetic information, military or veteran status, or any other characteristic protected by applicable law.
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.

Jobcode: Reference SBJ-dyn59m-3-147-89-85-42 in your application.