Senior Financial Data & FP&A Analytics Lead

Dechert LLP

Philadelphia (Philadelphia County)

On-site

USD 120,000 - 180,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Dechert LLP is seeking an experienced FP&A professional to join the Financial Planning & Analysis team in Philadelphia. You will combine advanced data skills with financial expertise to model, analyze, and report performance, collaborating with ED&A to create scalable governance for finance data.

You will leverage SQL, Excel, Tableau/Power BI, and AI-driven automation to streamline recurring reporting, improve accuracy, and support firm management with clear, sourced insights.

Qualifications

  • Bachelor’s degree in a related field and 5+ years in FP&A/Data analytics.
  • Expert-level T-SQL and data warehousing experience.
  • Experience with dashboards in Tableau, Power BI, or SSRS; DAX experience a plus.
  • Familiarity with Aderant or similar financial systems is preferred.
  • AI/tools or automation experience in reporting is a plus.

Responsibilities

  • Analyze and report key firm financial metrics including revenue, expenses, profitability, utilization, headcount, and FTE.
  • Build and maintain financial models and forecasts using Excel to automate analysis.
  • Own the end-to-end financial reporting lifecycle from data sourcing to delivery to finance leadership.
  • Translate business needs into requirements and communicate results, methodology, and assumptions to stakeholders.
  • Write complex T-SQL queries against the data warehouse to support analysis.
  • Create and support dashboards/reports in Tableau, Power BI, and SSRS with accuracy and performance.
  • Conduct data reconciliations and root-cause analysis on discrepancies with cross-team collaboration.
  • Collaborate with ED&A to define data requirements and governance for reusable warehouse objects.

Skills

T-SQL
Data warehousing
Tableau
Power BI
SSRS
DAX
Excel
AI tools
Copilot
ETL

Education

Bachelor’s Degree in Finance/Accounting/Data Science/IS or related field
5+ years of FP&A/data analytics experience

Tools

Aderant
Microsoft Fabric

Job description

Dechert LLP is seeking an experienced FP&A professional to join the Financial Planning & Analysis team in Philadelphia. You will combine advanced data skills with financial expertise to model, analyze, and report performance, collaborating with ED&A to create scalable governance for finance data.

You will leverage SQL, Excel, Tableau/Power BI, and AI-driven automation to streamline recurring reporting, improve accuracy, and support firm management with clear, sourced insights.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior FP&A Manager: Strategic Forecasting & Analysis
Senior FP&A Manager: Strategic Forecasting & Analysis

Dechert LLP • Philadelphia

On-site
USD 120,000 - 180,000
Senior Financial Data Analyst
Senior Financial Data Analyst

Dechert LLP • Philadelphia

On-site
USD 120,000 - 180,000
Senior FP&A Leader — Revenue Forecasting & Strategy
Senior FP&A Leader — Revenue Forecasting & Strategy

Dechert LLP • Philadelphia

On-site
USD 130,000 - 180,000
FP&A Manager: Strategic Finance & Analytics Leader
FP&A Manager: Strategic Finance & Analytics Leader

Dechert LLP • Philadelphia

On-site
USD 120,000 - 180,000
Senior FP&A Manager: Strategic Forecasting & Analysis
Senior FP&A Manager: Strategic Forecasting & Analysis

Dechert LLP • Washington

On-site
USD 180,000 - 200,000
Senior FP&A Strategist: Revenue Forecasts & Insights
Senior FP&A Strategist: Revenue Forecasts & Insights

J&T • Charlotte (NC)

On-site
USD 180,000 - 200,000
Senior FP&A Manager – Strategic Forecasting & Insights
Senior FP&A Manager – Strategic Forecasting & Insights

J&T Business Consulting • Florida

On-site
USD 180,000 - 200,000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

J&T Business Consulting • Pennsylvania

On-site
USD 180,000 - 200,000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

J&T Business Consulting • Florida

On-site
USD 180,000 - 200,000
Senior FP&A Lead — Revenue, Cash Flow & Strategy
Senior FP&A Lead — Revenue, Cash Flow & Strategy

Dechert LLP • Charlotte (NC)

On-site
USD 140,000 - 185,000