Technical Analyst, Finance & Accounting Remote
A+E Networks
New York, NYFull Time Job
We are testing out a new format for job postings, please let us know how you like it or how you would like it to be different. Thank you.
Compensation: Contract Hourly Pay Rate: $90.00
Workplace Requirements: Remote
Years of Experience Required: 5+ years
Educational Requirements: Not specified
Hard Skills:
- 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.
- Proficiency in Microsoft Power BI – Power Query Office 365 Excel.
- Familiarity with sharing via SharePoint and OneDrive.
Soft Skills:
- Strong teamwork and interpersonal skills.
- Excellent communication skills and ability to persuade at all management levels.
- High level of ownership, accountability, and integrity.
- Ability to question, evaluate, and make decisions.
Job Description:
The Technical Analyst, Finance & Accounting will be responsible for maintaining, enhancing, and troubleshooting the Excel-based workforce planning solution. This role involves collaborating with key stakeholders to ensure a seamless annual budgeting process, characterized by high complexity with heavy VBA overlays and interdependencies between multiple spreadsheets. Responsibilities include:
- Supporting the Excel-based workforce planning solution/process.
- Engaging in knowledge transfer to support all issues during the workforce planning process.
- Coordinating with resources to ensure all required datasets are populated.
- Performing end-to-end tests to ensure no solution-related bugs prior to distribution.
- Ensuring data integrity in each Excel sheet.
- Distributing Excel sheets via SharePoint to relevant planning partners.
- Providing necessary data from Excel spreadsheets to the Accounting Lead for reporting purposes.
- Documenting, addressing, and resolving any process-related issues.
This role requires a combination of technical expertise in Excel VBA and Power BI, with a strong understanding of business applications and confidentiality handling in data management.
Salary/Benefits
$90.00 - 90.00 per hour