FinanceJobs.io
← Back to all jobs

Job Description

Dechert LLP is seeking a Senior Financial Data Analyst to join its Financial Planning & Analysis (FP&A) team in Philadelphia. This role combines advanced data and query capabilities with finance expertise to deliver accurate reporting, scalable analysis, and process improvements through automation and AI.

Key Responsibilities

  • Analyze and report on key law firm financial metrics, including revenue, expenses, profitability, realization, utilization, headcount, and FTE, with clear knowledge of how each metric 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 full financial reporting and analysis lifecycle, from requirements gathering and data sourcing to modeling, validation, and delivery to finance leadership and firm management.
  • Translate business needs into requirements and communicate outcomes, methodology, and assumptions to finance leadership, firm management, and 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.
  • Develop and support financial dashboards and reports in Tableau, Power BI, and SSRS, ensuring accuracy, performance, and usability for business audiences.
  • Conduct reconciliations and root-cause analysis for data quality, balance, and reporting discrepancies, coordinating with relevant teams to address issues.
  • Partner with Enterprise Data & Analytics (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 apply AI tools and automation to streamline recurring reporting, accelerate analysis, and improve accuracy, including evaluation, testing, and adoption of solutions.
  • 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.

Required Skills & Qualifications

  • Expert-level T-SQL skills for analytical work, 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 moves through ETL into reporting.
  • Solid understanding of financial concepts, including budgeting, forecasting, variance analysis, and profitability analysis.
  • Advanced Microsoft Excel capabilities, including complex formulas, data modeling, and large dataset 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 from design through delivery and support.

Preferred Skills

  • Experience building dashboards and reports in Tableau, Power BI, or SSRS, including calculated fields and DAX is a plus.
  • Experience with Microsoft Fabric, notebooks, or other cloud data platforms is a plus.
  • Demonstrated interest in and hands-on experience with AI tools (for example, Microsoft Copilot or similar) is preferred.
  • Law firm or professional services experience is strongly preferred, including familiarity with time and billing or financial systems such as Aderant.
  • Experience applying AI tools or automation to improve analysis and reporting efficiency is preferred.

Technologies

SQL, T-SQL, Excel, Tableau, Power BI, SSRS, DAX, Microsoft Fabric, Microsoft Copilot, AI tools, data warehouse, ETL, notebooks

Education & 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.

Location and Workplace

Philadelphia, PA (onsite)

Similar Jobs