Senior Financial Data Analyst
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)