Senior Financial Data Analyst

Dechert LLP

Philadelphia (Philadelphia County)

Presencial

USD 120.000 - 180.000

Jornada completa

Hace 5 días
Sé de los primeros/as/es en solicitar esta vacante

Consigue una respuesta de este empleador

Tu currículum y tu carta de presentación, adaptados exactamente a lo que buscan contratar.

Supera los filtros ATS

Descripción de la vacante

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.

Formación

  • 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.

Responsabilidades

  • 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.

Conocimientos

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

Educación

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

Herramientas

Aderant
Microsoft Fabric

Descripción del empleo

As part of the Financial Planning & Analysis (FP&A) team at Dechert LLP, you will pair advanced data skills with financial expertise to improve how the firm models, analyzes, and reports performance. This role is built for collaboration across Financial Planning & Analysis and Enterprise Data & Analytics (ED&A), helping ensure reporting is accurate, documented, and scalable. You will also look for ways to use automation and AI to streamline recurring reporting and speed up analysis.

What You’ll Do
  • Analyze and report key law firm financial metrics including revenue, expenses, profitability, realization, utilization, headcount, and FTE, with clear understanding of how each is calculated and sourced.
  • Build and maintain financial models and forecasts using Excel and other tools when appropriate 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 requirements and communicate results, methodology, and assumptions to finance leaders, 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.
  • Create and support financial dashboards and reports in Tableau, Power BI, and SSRS, ensuring outputs are accurate, performant, and easy for business users to understand.
  • Conduct reconciliations and root-cause analysis on data quality, balance, and reporting discrepancies, partnering with the right teams to resolve issues.
  • Collaborate 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, improve accuracy, and speed up analysis, including evaluating and adopting 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.
What You Bring
  • Expert-level T-SQL skills, including complex joins, CTEs, window functions, and query performance tuning on large datasets.
  • Strong understanding of data warehousing, including dimensional modeling and how source data flows through ETL into reporting.
  • Experience building dashboards and reports in Tableau, Power BI, or SSRS; DAX and calculated fields experience is a plus.
  • Solid financial acumen across 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 and hands-on experience using AI tools (for example, Microsoft Copilot or similar) to improve efficiency and enhance analysis.
  • Strong 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.
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 role with significant technical responsibilities.
  • Demonstrated experience writing advanced SQL and working with a data warehouse or other large relational environments.
  • 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 efficiency in analysis and reporting is preferred.

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

Location: Philadelphia, PA (onsite)

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Financial Planning and Analysis Senior Manager (Law Firm)
Financial Planning and Analysis Senior Manager (Law Firm)

J&T Business Consulting • Florida

Presencial
USD 180.000 - 200.000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

Dechert LLP • Washington

Presencial
USD 180.000 - 200.000
Senior Financial Data & FP&A Analytics Lead
Senior Financial Data & FP&A Analytics Lead

Dechert LLP • Philadelphia

Presencial
USD 120.000 - 180.000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

J&T • Charlotte (NC)

Presencial
USD 180.000 - 200.000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

J&T Business Consulting • Florida

Presencial
USD 180.000 - 200.000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

J&T Business Consulting • Pennsylvania

Presencial
USD 180.000 - 200.000
Senior Manager Financial Planning & Analysis - Charlotte
Senior Manager Financial Planning & Analysis - Charlotte

Dechert LLP • Charlotte (NC)

Presencial
USD 140.000 - 185.000
Financial Planning and Analysis Senior Manager
Financial Planning and Analysis Senior Manager

Dechert LLP • Philadelphia

Presencial
USD 120.000 - 180.000
Senior Manager Financial Planning & Analysis - Washington, DC
Senior Manager Financial Planning & Analysis - Washington, DC

Dechert LLP • Washington

Presencial
USD 130.000 - 190.000
Senior Manager Financial Planning & Analysis - Philadelphia
Senior Manager Financial Planning & Analysis - Philadelphia

Dechert LLP • Philadelphia

Presencial
USD 130.000 - 180.000