Financial Analyst - Excel Automation & Process Support

 
Finance 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
Assignment Details
1.     Duration: Approximately 6–9 months
2.     30/60/90 Days
3.     Remote based
4.     Immediate start
·Work through Central Model Roadmap backlog:
o   ROLL THROUGH NEW CARTOGRAPHER MAPPING INTO CENTRAL MODEL
o   Automate volume template (map stat accounts into vena and into central model)
o   Backfill xF splits into Central Model
o   Clean up new Org mapping in Central model
o   Additional COR buckets for Data (Data licensing, royalties, etc)
o   Breakout Paige COR into buckets
o   Clean up Balance Sheet/Cash forecast
o   Headcount forecast clean-up (add IBNR/LOA accounts, update formulas)
o   Add wages summary section to Database tab
·Vena Templates & Vena Load data
o   Genomics Revenue Load template
o   Load Historical headcount actuals into Vena
o   Clean up volume load template in Vena (OneOme, MRD, xF splits)
o   Add Adj EBITDA walk to Vena
·Help with Ambry go-live in Netsuite
o   Mapping new teams, new accounts, legal entity
o   Ensure Central Model ready to ingest Ambry data
·WBR/MBR
·Clean up/automate Weekly Exec Dashboard 
 

This is a remote, work from home position. This role is to be filled outside the states of California and Colorado.

**We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, ethnic origin, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.**

#LI-KH1