Financial Analyst

Financial Analyst (contract) with an acquisitive healthcare company.

Summary

The Financial Analyst (contract) is responsible for timely and accurate preparation and distribution of incentive plan calculations throughout the organization. You will be responsible for validating, reconciling and reporting on all commission and incentive compensation calculations utilizing Excel. 

The assignment will begin immediately and is expected to last 6 – 9 months.

Responsibilities

• Compiling source data and requirement needs in the Incentive Compensation excel spreadsheets/workbooks. Preparing the calculations on a timely basis.
• Assessing the source data to determine source of truth, current duplication of efforts, updates to current process that can add “company goal” value.
• Troubleshooting and addressing incentive questions received from stakeholders.
• Maintaining detailed documentation of all incentive plans.
• Developing and implementing calendars for distribution of key compensation plan metrics, results, analytics.
• Develop recurring and ad hoc compensation reports, metrics and dashboards.
• Providing updates to stakeholders on statuses of completion of all incentive plan calculations weekly, monthly, quarterly, etc.

• Bachelor’s degree in Accounting or Finance. 
• 2-4 years’ experience in Financial Analysis.
• Experience with large amounts of data, database and spreadsheet software, for example, SQL, Dashboards, etc.
• Advanced knowledge of Microsoft Excel is required, including but not limited to v-lookup, pivot tables, Index Match, Macros, Boolean formulas.
• Proven analytical ability, coupled with problem solving and time management skills, with the aptitude to multi-task and self-manage multiple priorities.
• Detail oriented and able to perform in a high-pressure environment, while meeting strict deadlines.
• Be able to apply strong analytical knowledge on large amounts of data, to identify errors, communicate findings, and resolve errors.