Job description

King & Spalding is a leading global law firm with a commitment to excellence, innovation, and the seamless delivery of legal services. We harness innovative technology and exceptional talent to meet the complex needs of our clients in a fast-paced and dynamic legal landscape. The Financial Analyst is responsible for assisting the Financial Analyst team in the reporting and modeling of financial and profitability data. This includes working with internal business customers to define reporting requirements, building parameter based reports for end-user execution, developing electronic distribution of reports, functioning as a liaison with the financial systems and finance operations groups, and maintaining the balancing and integrity of the firm’s financial system. This also involves identifying and analyzing key performance measures, de-aggregating metrics into their underlying components, engaging in “root cause” analysis to assess changes in metrics and underlying causes, assessing performance against key industry benchmarks and, assessing the impact of various performance improvement efforts and measuring results. The position is heavily involved in compiling data for further analysis and reporting financial metrics to Partners and Senior Management. KEY RESPONSIBILITIES: · Evaluate recurring data requests for possible creation of reports with end-user execution · Advance the firm’s electronic distribution of reports · Work directly with IT to assess data integrity issues across applications · Map data elements from various sources to target databases · Perform extractions from the financial system and ensure the data is maintained accurately · Primary contact within the team to resolve application software problems with vendors or internal K&S IT Helpdesk · Prepare, or assist in the preparation, of recurring and special management reports/graphs · Prepare queries across multiple tables/databases to generate data · Manipulate data in Excel spreadsheets, SQL, or other databases in order to summarize the financial reports requested · Generate ad hoc financial models and data analysis · Monitor key performance indicators on a regular basis · Conduct competitive analysis for benchmarking purpose · Rely on instructions and pre-established guidelines to perform the functions of the job. · Works under immediate supervision. QUALIFICATIONS: · Bachelor’s degree. · 1-2 years of experience in a law firm or corporate environment preferred · Ability to prepare schedules and supporting work papers in an organized manner, documenting work performed in order for others to easily determine source of information and what work was performed. · Must be able to translate vague directions into specific actions. · Must have strong organizational skills and the ability to handle multiple tasks and tight deadlines effectively; understanding scope, deliverables, and timelines. · Must be able to communicate results and analysis clearly to various audiences; knowing when to summarize or detail information. · Attention to detail and accuracy are essential. · Must have a high proficiency with Excel, notably advanced formulas, pivot tables, and macros. · SQL experience preferred. · Must have ability to analyze relationships of financial data in order to spot variances from normal. Ability to follow through in investigation and explanation of any variances. · Must have good oral and written communication skills. · Must have good people skills and be able to interact well with all levels of personnel. · Strong working knowledge of computer concepts. Experience with use of personal computers. · Ability to maintain strict confidentiality is mandatory. The firm offers a generous total compensation package with bonuses and raises awarded in recognition of individual merit-based performance. All full-time Business Services employees may participate in King & Spalding’s comprehensive benefit program including health and wellness plan, life and disability insurance, flexible spending accounts and a health savings account, a 401(k) plan, profit sharing plan, and a substantial Paid Time Off (PTO) program. Pay Transparency Range: New York: The anticipated full-time annualized salary range is $105,000 - $120,000. The salary offer will be contingent upon various factors, including but not limited to, relevant experience, internal equity, market data, job location, and other job-related factors permitted by law.  In general, employers are not permitted to make unsolicited neutral statements about criminal background checks before a conditional offer, including statements noting the employer s compliance with laws protecting applicants with criminal histories such as Applicants criminal history will be considered consistent with the requirements of the New York City Fair Chance Act . King & Spalding LLP (K&S) is committed to providing equal employment opportunity to all applicants and employees in full compliance with all state, federal, and local laws prohibiting discrimination on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, genetic information, age, disability or any other status protected by applicable law. We are proud of our remarkably cohesive culture, which now encompasses more than 2,500 lawyers and business professionals worldwide. We seek to attract and develop the very best talent to work with us.

Requirements

Must-haves

Evaluate recurring data requests for possible creation of reports with end-user execution
Advance the firm’s electronic distribution of reports
Work directly with IT to assess data integrity issues across applications
Map data elements from various sources to target databases
Perform extractions from the financial system and ensure the data is maintained accurately
Primary contact within the team to resolve application software problems with vendors or internal K&S IT Helpdesk
Prepare, or assist in the preparation, of recurring and special management reports/graphs
Prepare queries across multiple tables/databases to generate data
Manipulate data in Excel spreadsheets, SQL, or other databases in order to summarize the financial reports requested
Generate ad hoc financial models and data analysis
Monitor key performance indicators on a regular basis
Conduct competitive analysis for benchmarking purpose
Rely on instructions and pre-established guidelines to perform the functions of the job.
Works under immediate supervision.
Bachelor’s degree.
Ability to prepare schedules and supporting work papers in an organized manner, documenting work performed in order for others to easily determine source of information and what work was performed.
Must be able to translate vague directions into specific actions.
Must have strong organizational skills and the ability to handle multiple tasks and tight deadlines effectively; understanding scope, deliverables, and timelines.
Must be able to communicate results and analysis clearly to various audiences; knowing when to summarize or detail information.
Attention to detail and accuracy are essential.
Must have a high proficiency with Excel, notably advanced formulas, pivot tables, and macros.
Must have ability to analyze relationships of financial data in order to spot variances from normal. Ability to follow through in investigation and explanation of any variances.

Nice-to-haves

1-2 years of experience in a law firm or corporate environment preferred
SQL experience preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: workday
Effort: long

Benefits

Benefits detected in the listing.

Vision

401(K)

Pto

Paid Time Off

Wellness