Financial Analyst – Pricing & Analytics

Job Description

Financial Analyst | Kilpatrick Townsend & Stockton LLP

The Tone:
This is a full-time, regular position at Kilpatrick Townsend & Stockton LLP, located in Atlanta, GA, with the option for remote work. Kilpatrick, a large international law firm, operates as one team where each person plays an integral role in serving client needs, demonstrating a strong dedication to its employees, values, and commitment to the community. This role supports the firm’s operational and strategic decision-making by developing and maintaining financial reporting solutions for internal financial performance and client/matter economics.

The TL;DR
• Role: Full Time
• Type: Regular position
• Location: Hybrid, Atlanta, GA
• Pay: $75000–$86000 yearly
• Team: Pricing & Analytics Department, working as part of a team of attorneys, paralegals, and support staff.
• Mission: Develop and maintain financial reporting solutions addressing internal financial performance and client/matter economics to support the Firm’s operational and strategic decision-making.
• Tech Stack: Microsoft Power BI, Microsoft Excel, SQL (preferred), Aderant (preferred), Elite 3E (preferred)

What You’ll Actually Do
• Develop: Develop, publish, and maintain routine reports and Power BI dashboards that support firm leadership and practice group decision-making.
• Translate: Translate complex financial data into clear, actionable visual outputs for both technical and non-technical audiences.
• Respond: Direct workflows for and respond to ad hoc reporting and data requests from attorneys, practice group leaders, and clients in a timely and professional manner.
• Partner: Partner with internal stakeholders to understand reporting needs and deliver analyses that directly support business development, client management, and operational decisions.
• Collaborate: Collaborate with broader Finance and Accounting teams to reconcile data and validate reporting outputs.

The Must-Haves
• Background: Bachelor’s degree in Finance, Accounting, Economics, Business Analytics, or a related field; this is an entry-level role.
• Experience: 1-2 years of relevant experience in a professional services, legal, or financial environment, including internship experience.
• Skills: Proficiency in Microsoft Power BI (report development, DAX formulas, dataset publishing/management), strong Microsoft Excel skills (pivot tables, VLOOKUP/XLOOKUP, financial modeling basics), ability to work with large, complex datasets and present findings clearly, strong attention to detail, and effective written and verbal communication skills.
• Bonus: Proficiency in SQL or comparable data query tools, interest or experience with applied mathematical and predictive modeling (statistics, machine learning, optimization, and/or simulation), familiarity with legal financial systems such as Aderant or Elite 3E, and knowledge of law firm operations or legal industry metrics (e.g., realization, utilization, leverage).