Financial Analyst

San Francisco Permanent USD105,000 - USD115,000 per year Hybrid working
  • Hybrid Working Opportunity
  • Bonus, Full Benefits, 401K

About Our Client

My Client is an American international law firm with offices worldwide. The firm's practice areas include corporate, litigation, intellectual property, fund formation, public markets, employment, life sciences, clean technology, real estate, financial services, retail, regulatory and energy. It has consistently been ranked as an elite law firm for technology and life sciences companies, startups and emerging growth companies, and venture capital firms by Above the Law.

Job Description

FTE and time reporting:

  • Document financial analysis processes and workflows
  • Work with Payroll and HR to track leave information
  • Create and/or maintain Excel work files and Access database tables, as well as generation and manipulation of data views from the Elite 3E financial software system
  • Execute SQL queries from 3e and Xcelerate databases
  • Produce and distribute monthly time reports and documents in a timely manner
  • Analyze and reconcile 3E reports to IntApp Time on an ad-hoc basis
  • Prepare ad-hoc analylsis and projections of year ending Research and present process improvements and automation



Budget process:

  • Assist in mid-year budgeting, annual mid-year forecast process and annual planning cycle
  • Manage and analyze data in master tables in the Xcelerate budgeting database
  • Manage and maintain data links between Xcelerate and Elite 3E financial systems, including synchronization procedures, budget and data upload and downloads
  • Responsible for or assist in the production of various reports, work files, documents, etc., used in the annual planning cycle and the mid-year review cycle
  • Perform preliminary review of data input for annual capital budget review process including preparation of budget reports



Systems and data administration:

  • System configuration and access management in partnership with Financial Services management and IS teams
  • Oversee and administer GL access for 3E and Xcelerate
  • Complete monthly audit of GL access to ensure account security is properly assigned
  • Produce general ledger access management certification reports

MPI does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or based on an individual's status in any group or class protected by applicable federal, state or local law. MPI encourages applications from minorities, women, the disabled, protected veterans and all other qualified applicants.

The Successful Applicant

Required:

  • 4+ years working experience in an analytical position involving financial modeling
  • Experience with Access and demonstrated superior knowledge of database management
  • Understanding of segment reporting concepts and how these relate to structure of General Ledger
  • Understanding of full-time equivalency (FTE) measurements used in reporting



Preferred

  • Bachelor's degree in Accounting or Finance
  • Experience using Elite 3E software and metrics
  • Experience using Xcelerate budgeting software
  • Experience using SQL preferred
  • Prior law firm or professional services firm experience

What's on Offer

  • Full Health Beenfits
  • 401K,
  • Hybrid/remote working schedule
  • Bonus
Contact
Dante Antonini
Quote job ref
JN-072022-5699153

Job summary

Sector
Accounting
Sub Sector
Financial Accounting
Industry
Business Services
Location
San Francisco
Contract Type
Permanent
Consultant name
Dante Antonini
Job Reference
JN-072022-5699153
Job Nature
Hybrid working