Kilpatrick, a large international law firm, is seeking a Financial Analyst for our Pricing & Analytics Department in our Atlanta office, working remotely. This position will be part of our team of attorneys, paralegals and support staff providing a high level of service to both internal and external clients. At Kilpatrick we are one team where each person plays an integral role in serving the needs of our clients. The firm has a strong dedication to its employees, values, and commitment to the community.
We are seeking a motivated and detail-oriented Financial Analyst to join our Pricing & Analytics team. This entry-level role supports the Firm's operational and strategic decision-making by developing and maintaining financial reporting solutions addressing internal financial performance and client / matter economics. The ideal candidate is analytically curious, comfortable working with large datasets, and eager to build expertise in a dynamic, fast-paced professional services environment.
ESSENTIAL JOB FUNCTIONS:
- Develop, publish, and maintain routine reports and Power BI dashboards that support firm leadership and practice group decision-making.
- Translate complex financial data into clear, actionable visual outputs for both technical and non-technical audiences.
- Ensure the accuracy, consistency, and timeliness of all reporting deliverables.
- 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 with internal stakeholders to understand reporting needs and deliver analyses that directly support business development, client management, and operational decisions.
- Communicate findings clearly and concisely, tailoring the level of detail and format to the audience.
- Document reporting logic, data sources, and refresh processes.
- Collaborate with broader Finance and Accounting teams to reconcile data and validate reporting outputs.
- Identify and recommend opportunities to automate or streamline reporting workflows.
KNOWLEDGE/SKILLS REQUIRED:
-
Bachelor's degree in Finance, Accounting, Economics, Business Analytics, or a related field.
- Proficiency in Microsoft Power BI, including report development, DAX formulas, and 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.
- Proficiency in SQL or comparable data query tools preferred.
- 1–2 years of relevant experience in a professional services, legal, or financial environment (internship experience counts).
- Strong attention t