6-9 month contractOnsite 3 days per week: 600 W Chicago Ave
Summary
You’ll be cleaning up and rebuilding messy Excel-based financial models, automating manual reporting, and helping modernize how the finance team operates.
Finance Temp Analyst – Excel Automation & Process Support We are seeking a temporary Finance Analyst to support the team on a 6–9 month assignment focused on improving and streamlining existing Excel-based financial models and reporting processes.
This role is intended to provide additional bandwidth to the finance team while helping modernize and clean up several legacy files and workflows that currently have limited documentation.
The ideal candidate is highly proficient in Excel, comfortable working through loosely documented processes, and capable of identifying opportunities for automation and standardization.
Key Responsibilities
- Review, clean up, and optimize existing Excel models and financial reporting files
- Automate recurring manual tasks using advanced Excel functionality (formulas, Power Query, VBA/macros preferred)
- Improve usability, organization, and structure of legacy spreadsheets
- Assist with documenting existing processes and creating clearer workflows
- Support ad hoc finance and reporting requests as needed
- Partner with finance team members to identify inefficiencies and implement practical solutions
- Provide additional operational bandwidth during a period of process improvement and transition
Qualifications
- Strong Excel skills required, including advanced formulas and data manipulation
- Experience with Excel automation tools such as VBA, macros, Power Query, or similar preferred
- Background in Finance, Accounting, FP&A, Business Analytics, or related field
- Ability to work independently in an environment with limited documentation
- Strong problem-solving and organizational skills
- Comfortable navigating ambiguity and improving existing processes 30/60/90 Days
- Work through Central Model Roadmap backlog:ROLL THROUGH NEW CARTOGRAPHER MAPPING INTO CENTRAL MODELAutomate volume template (map stat accounts into vena and into central model)
- Backfill xF splits into Central Model
- Clean up new Org mapping in Central model
- Additional COR buckets for Data (Data licensing, royalties, etc)
- Breakout Paige COR into buckets
- Clean up Balance Sheet/Cash forecast
- Headcount forecast clean-up (add IBNR/LOA accounts, update formulas)
- Add wages summary section to Database tab
- Vena Templates & Vena Load data
- Genomics Revenue Load template
- Load Historical headcount actuals into Vena
- Clean up volume load template in Vena (One
- Ome, MRD, xF splits)
- Add Adj EBITDA walk to Vena
- Help with Ambry go-live in Netsuite
- Mapping new teams, new accounts, legal entity
- Ensure Central Model ready to ingest Ambry data
- WBR/MBRClean up/automate Weekly Exec Dashboard
