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)