Back to jobs

Senior Financial Data Analyst

Dechert LLP · Philadelphia, PA, US

Spotted 4d agoFull-time

Job details

Employment
Full-time
Level
Senior
Experience
5+ years
Education
Bachelor's degree
Posted
Nov 13, 2026
Last confirmed open
Nov 14, 2026
Job function
Software/Internet/AI › Data & Analytics › Data Analyst
Job description

About this role

The Senior Financial Data Analyst is a highly technical, senior individual-contributor role on the Financial Planning & Analysis (FP&A) team. This position combines strong financial acumen with advanced data skills to build the queries, models, and reporting that drive the firm’s financial analysis, forecasting, and performance insights.

The role works closely with the Enterprise Data & Analytics (ED&A) team, including analytics engineers and developers, to ensure that the data and logic behind finance reporting are accurate, well-documented, and scalable.

The ideal candidate is as comfortable writing complex SQL and building data models as they are discussing profitability, realization, and headcount with finance leaders. This person will own complex analyses and reporting solutions from source data to final deliverable, serve as the technical bridge between FP&A and ED&A, and actively look for ways to use automation and AI to make the team’s work faster and more reliable.

Law firm experience is highly valued. This is an excellent opportunity for an experienced analyst who wants to work on challenging technical problems with real financial impact in a fast-paced, service-oriented environment.

ESSENTIAL JOB FUNCTIONS:

  • Analyze and report on key law firm financial metrics such as revenue, expenses, profitability, realization, utilization, headcount, and FTE, with a clear understanding of how each is calculated and sourced.
  • Build and maintain financial models and forecasts, using Excel and, where appropriate, other tools to automate and validate analysis.
  • Own the end-to-end financial reporting and analysis lifecycle, from gathering requirements and sourcing data through modeling, validation, and delivery to finance leadership and firm management.
  • Translate business needs into clear requirements, and explain results, methodology, and assumptions to finance leaders, firm management, and other non-technical stakeholders.
  • Write and optimize complex T-SQL queries against the firm’s data warehouse to support financial analysis, forecasting, and ad hoc requests.
  • Build and support financial dashboards and reports in Tableau, Power BI, and SSRS that are accurate, performant, and easy for business users to understand.
  • Perform reconciliations and root-cause analysis on data quality, balance, and reporting discrepancies, and work with the appropriate teams to resolve them.
  • Partner with ED&A analytics engineers and developers to define data requirements, validate data models, and promote finance logic into governed, reusable warehouse objects and reports.
  • Identify opportunities to use AI tools and automation to streamline recurring reporting, speed up analysis, and improve accuracy; evaluate, test, and adopt solutions that make the team more efficient.
  • Document metric definitions, calculation logic, and reporting processes to support consistency, data governance, and knowledge sharing.

Provide technical guidance and share best practices with other FP&A team members.

*

KNOWLEDGE, SKILLS AND ABILITIES:

  • Expert-level SQL (T-SQL) skills for analysis, including complex joins, CTEs, window functions, and query performance tuning on large datasets.
  • Strong understanding of data warehousing concepts, dimensional modeling, and how source data flows through ETL processes into reporting.
  • Experience building dashboards and reports in Tableau, Power BI, or SSRS, including calculated fields and DAX, is a plus.
  • Solid understanding of financial concepts, including budgeting, forecasting, variance analysis, and profitability analysis.
  • Advanced Microsoft Excel skills, including complex formulas, data modeling, and large dataset analysis.
  • Experience with Microsoft Fabric, notebooks, or other cloud data platforms is a plus.
  • Demonstrated interest in and hands-on experience with AI tools (such as Microsoft Copilot or similar) to improve efficiency, automate repetitive work, and enhance analysis.
  • Excellent analytical, organizational, and communication skills, with the ability to collaborate effectively with both finance and technical teams.

Ability to manage multiple priorities, work independently, and take ownership of solutions from design through delivery and support.

*

EDUCATION AND EXPERIENCE:

  • Bachelor's Degree in Finance, Accounting, Information Systems, Computer Science, Data Science, Engineering, or a related field (or equivalent practical experience).
  • 5+ years of hands-on experience in financial analysis, FP&A, data analytics, or a similar analytical role with significant technical responsibilities.
  • Demonstrated experience writing advanced SQL and working with a data warehouse or other large relational data environments.
  • Law firm or professional services experience strongly preferred, including familiarity with time and billing or financial systems such as Aderant.
  • Experience applying AI tools or automation to make analysis and reporting more efficient is preferred.
Interested in this role?Continue on Dechert LLP's careers page.
Apply on Dechert LLP