Senior FP&A Analyst — Strategy, Insights & Automation

Troutman Pepper

Harrisburg (Dauphin County)

On-site

USD 95,000 - 150,000

Full time

40 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Troutman Pepper in Harrisburg is seeking a Senior Financial Analyst to drive financial analysis, budgeting, forecasting, and strategic insights across the firm. You will model performance, prepare executive-ready reports, and influence decisions with clear recommendations.

Collaborating with Finance, IT, and operations, you will build dashboards using Power BI/Tableau, automate processes, and ensure data integrity while communicating complex concepts to senior leadership.

Qualifications

  • 5+ years of progressive experience in finance, FP&A, or a related analytical role.
  • Proven ability to independently perform complex financial analysis, financial modeling, budgeting, forecasting, or management reporting.
  • Advanced proficiency with Microsoft Excel, including complex formulas, PivotTables, and data analysis.
  • Experience with ERP/GL, financial reporting, or time-and-billing systems.
  • Experience with business intelligence and data visualization tools such as Power BI or Tableau.
  • Proficiency with Microsoft Word, PowerPoint, Outlook, and Teams.

Responsibilities

  • Perform detailed analyses linking financial performance to underlying business drivers at the firm, offices, practice groups, clients, and matters.
  • Prepare monthly/quarterly variance analyses versus budget, forecast, and prior periods, identifying key drivers and actions.
  • Synthesize complex financial information into clear, decision-ready insights for Finance and firm leadership.
  • Prepare executive summaries, dashboards, presentations, and trend analyses for senior leadership discussions.
  • Develop conclusions and recommendations from analysis rather than just presenting data.
  • Adapt presentations to the needs of financial and non-financial audiences.
  • Respond to recurring and ad hoc analytical requests from Finance leadership and stakeholders.
  • Support annual budgeting, periodic reforecasting, and multi-period outlook processes.
  • Develop and maintain financial models supporting revenue/expense forecasting, headcount, productivity, and KPI tracking.
  • Analyze KPIs like realization, utilization, leverage, and profitability drivers.
  • Conduct rate and realization analyses focusing on trends and operational drivers.
  • Support working capital analysis including WIP and AR trends.
  • Collaborate with IT and data teams to improve data quality and reporting.
  • Develop dashboards and reporting solutions using Excel, Power BI, Tableau, SQL.

Skills

Financial analysis
Budgeting & forecasting
Variance analysis
Executive communication
Excel advanced
Power BI
SQL basics
ERP/GL systems
Financial modeling
Attention to detail

Education

Bachelor's degree in Finance/Accounting
Master's degree or CPA (preferred)

Tools

Power BI
Tableau
SQL
ERP/GL systems
Time & Billing systems

Job description

Troutman Pepper in Harrisburg is seeking a Senior Financial Analyst to drive financial analysis, budgeting, forecasting, and strategic insights across the firm. You will model performance, prepare executive-ready reports, and influence decisions with clear recommendations.

Collaborating with Finance, IT, and operations, you will build dashboards using Power BI/Tableau, automate processes, and ensure data integrity while communicating complex concepts to senior leadership.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior FP&A Analyst — Strategy, Insights & Automation
Senior FP&A Analyst — Strategy, Insights & Automation

Troutman Pepper • Georgia

On-site
USD 80,000 - 120,000
Senior FP&A Analyst: Strategy, Insights & Automation
Senior FP&A Analyst: Strategy, Insights & Automation

Troutman Pepper • Pennsylvania

On-site
USD 90,000 - 130,000
Senior FP&A Analyst: Strategic Insights & Automation
Senior FP&A Analyst: Strategic Insights & Automation

Troutman Pepper • Texas

Hybrid
USD 90,000 - 140,000
Senior FP&A Analyst: Strategy, Insights & Automation
Senior FP&A Analyst: Strategy, Insights & Automation

Troutman Pepper Locke LLP • Atlanta (GA)

On-site
USD 85,000 - 125,000
Senior Financial Analyst - FP&A & Strategic Insights
Senior Financial Analyst - FP&A & Strategic Insights

Troutman Pepper • Atlanta (GA)

On-site
USD 90,000 - 130,000
Senior FP&A Analyst - Drive Strategy & Insights
Senior FP&A Analyst - Drive Strategy & Insights

Troutman Pepper • Pittsburgh

Hybrid
USD 90,000 - 130,000
Senior Financial Analyst: Insightful FP&A & Strategic Impact
Senior Financial Analyst: Insightful FP&A & Strategic Impact

Troutman Pepper • City of Rochester (NY)

On-site
USD 90,000 - 130,000
Senior FP&A Analyst: Data-Driven Insights & Automation
Senior FP&A Analyst: Data-Driven Insights & Automation

Troutman Pepper • Richmond (VA)

On-site
USD 90,000 - 120,000
Senior FP&A Analyst — Law Firm Growth & Insights
Senior FP&A Analyst — Law Firm Growth & Insights

Troutman Pepper • Wilmington (DE)

On-site
USD 90,000 - 140,000
Senior FP&A Analyst: Insights, Forecasting & Modeling
Senior FP&A Analyst: Insights, Forecasting & Modeling

Troutman Pepper • Detroit (MI)

On-site
USD 90,000 - 130,000