Financial Planning & Analysis Associate

The Metropolitan Opera; New York (NY); On-site; USD 75,000 - 110,000; Full time

Job summary

The Metropolitan Opera seeks a Financial Planning & Analysis Associate to turn financial and operational data into actionable insights that guide strategic decisions. You will blend traditional FP&A with data analytics, modeling, and BI to strengthen forecasting, budgeting, reporting, and long-range planning.

You will build and maintain financial models, prepare dashboards for senior leadership, and collaborate across departments to align financial objectives with artistic and operational goals.

Qualifications

• Bachelor's degree in a related field required.
• 2–3 years of FP&A or analytics experience required.
• Strong Excel, SQL, and data visualization skills needed.

Responsibilities

• Support budgets, reforecasts, and long-range plans.
• Perform variance analyses explaining gaps between results, budgets, forecasts, and actuals.
• Develop, maintain, and enhance detailed financial models to evaluate performance.
• Prepare recurring and ad hoc reports and dashboards for leadership.
• Collaborate with departments to align financial objectives with operational goals.
• Design automated reporting to improve efficiency and accuracy.
• Extract and analyze large datasets from multiple sources.
• Identify opportunities to streamline planning and analytics through automation.
• Support special projects and strategic initiatives.

Skills

Advanced Excel

SQL

Data analytics

Forecasting

Communication

Attention to detail

Education

Bachelor's degree in Finance, Accounting, Economics, Data Science, Statistics, Mathematics, Computer Science, or a related field

Tools

Python

Data visualization tools

Excel macros

Job description

The Financial Planning & Analysis Associate, plays a critical role in transforming financial and operational data into actionable insights that support strategic decision-making across the organization. A key member of the Financial Planning & Analysis team, this position combines traditional financial analysis with advanced data analytics, modeling, and business intelligence techniques to enhance forecasting, budgeting, reporting, and long-range planning.

Primary Responsibilities

• Support the creation of budgets, reforecasts, and long-range financial plans.
• Conduct variance analyses to explain differences between results, budgets, forecasts, and historical actuals.
• Develop, maintain, and enhance detailed financial models to evaluate business performance and strategic initiatives.
• Prepare recurring and ad hoc management reports, dashboards, and presentations for senior leadership.
• Collaborate with various departments to align financial objectives with operational goals.
• Design and build automated reporting solutions that improve the efficiency, accuracy, and timeliness of financial analysis.
• Extract, transform, and analyze large datasets from various sources to generate actionable insights.
• Identify opportunities to streamline financial planning, reporting, and analytical processes through automation and advanced analytics.
• Support special projects and strategic initiatives as assigned.

Skills and Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Data Science, Statistics, Mathematics, Computer Science, or a related field.
• Minimum 2-3 years professional experience in financial planning & analysis, data analytics, business intelligence, or a related analytical role.
• Advanced proficiency in Microsoft Excel, including modeling, complex formulas, pivot tables, macros, and data visualization.
• Proficiency in SQL and experience working with large datasets from multiple sources.
• Familiarity with programming languages used for data analysis a plus.
• Knowledge of statistical analysis, forecasting techniques, and predictive modeling.
• Ability to communicate complex analytical findings clearly to both technical and non-technical audiences.
• Strong attention to detail and commitment to data accuracy and integrity.
• Excellent organizational skills with ability to manage multiple priorities and meet deadlines.
• Ability to work collaboratively in a team-oriented environment.
• Demonstrated interest in the performance arts a plus.

The Metropolitan Opera is an equal opportunity employer. We are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and existing employees without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, citizenship status, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, or any protected category prohibited by local, state or federal laws.