Job details
Job type full-time
Full job description
Collaborate with vice president & cfo, controller, senior management, and external business partners on financial performance and budget development issuesDevelop detailed, clear analyses and creative models of business and financial performance to answer key strategic and operational questions for the henry fordCollaborate with various units across the institution to help make decisions and is a key voice for earned revenue initiatives, programs, events, and products.
Principal functions:
The financial analyst will work closely with the cfo, controller, manager of finance, and other senior staff at the museum on a wide range of issues and projectsExamples of projects are listed below.
Run monthly profit & loss statement, analyze variances, summarize findingsIdentify problems and research potential solutions both at the institutional and department levels.
Participate in the development of institute’s annual operating budget by updating budget templates, compiling departmental submissions, and verifying budget calendarization.
Compile weekly attendance and revenue data for cfo, and work with head of data analytics for weekly business brief.
Perform detailed analyses on attendance data, developing models for revenue projectionsIn coordination with manager, assigns tasks to financial analyst in all aspects of attendance tracking and ancillary revenue/cost analyses.
Analyze and compute royalties for various 3rd party exhibitions, admissions, and retail partners.
Prepare business analyses of existing and prospective programs and operations, and present them to units in actionable and understandable form.
Analyze institutional costs, the effect of price changes, capital expenditures, and other business issues as requested by the team leader.
Compile monthly financials for the ford rouge factory tourPerform additional analyses for venue as requested.
Prepare dashboard for quarterly board meetings, including updating standard tables as well as recommending new data displays.
Monitor labor hours and cost across the institute and complete variance analyses for managementCommunicate information to relevant parties.
Support annual audit and insurance renewal process by providing various financial or labor data.
Complete various annual surveys.
Contributes to the effective team management of all problems, issues, and opportunities.
Acts as a team player and provides expertise within the team and with other teams as appropriate.
Performs other duties as assigned.
Required qualifications:
Business degree (or experience)
5-8 years experience creating and monitoring complex budgets as well as performing financial analysis, forecasting and financial modeling.
Extensive experience using financial systems and financial information, such as financial edge, sage intacct, or netsuite.
Extensive experience and competence using excel advanced functions such as pivot tables and vlookups.
Proficiency in data visualization techniques for reporting purposes, developing dashboards and reports.
Excellent communication, critical thinking, analytical and organizational skills.
Experience developing and making presentations to senior management.
Ability to communicate technical or abstract concepts.
Ability to work independently, be a creative problem-solver and to develop and maintain collaborative working relationships as part of a team.
Must be able to work within a relatively unstructured environment and communicate effectively with non-financial people at all levels of the organization.
Desired qualifications
Mba degree
Proficiency in query and report writing tools; power bi preferred, or related tools such as tableau, bpc.
Experience extracting data from hris systems, such as dayforce, adp, ultipro, etc.
Experience extracting data from ecommerce or point-of-sale tools such as accesso or siriusware.
Physical / mental / environmental
Physical: sitting: 90% standing/walking: 10%
Lifting: 50 lb.
Vision: normal
Mental: problem solving skills essentialAble to set priorities and meet deadlines.
Environment: while typically a normal office environment, current this position is currently working in a hybrid environment with part remote work and part office work.
0
Email to a friend
Print version
