Senior Financial Data Analyst

Kirkland and Ellis

Chicago (IL)

On-site

USD 100,000 - 138,000

Full time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Comprehensive healthcare

Paid time off

Retirement

Flexible benefits

Personal support

Tailored learning and development

Job summary

Kirkland & Ellis seeks a Senior Financial Data Analyst in Chicago to support the Finance Data & Analytics team. You will craft analysis-ready models, deliver executive reporting, and partner with senior leaders to clarify financial performance.

Role focuses on data flows, data mart enhancements, and actionable insights using SQL, Power BI, and DAX. Collaborative and detail-oriented professionals thrive in this environment.

Qualifications

Bachelor's degree in accounting or finance or comparable experience.
6+ years of progressively responsible accounting or finance experience; law firm/professional services is a plus.
Strong SQL querying skills with complex queries and relational database concepts.
Advanced Microsoft Excel skills.
Ability to interpret complex data and relate findings to business objectives.
Proactive, detail-oriented, and able to work with stakeholders.
Excellent written, verbal, interpersonal, and organizational skills.

Responsibilities

Support initiatives using financial modeling, data mining, and analysis for firm and client reporting.
Transform transactional data into fact-and-dimension models for analysis.
Design and enhance Power BI models, reports, and DAX solutions.
Collaborate with senior management and partners to align data strategies with goals.
Use SQL and related tools to extract, validate, and present information.
Analyze complex datasets to identify patterns and insights for decisions.
Contribute to process improvements and data-driven initiatives.
Prepare timely reporting for committees, CFO, and senior leaders.
Stay current with Power BI developments and cross-team data usage.

Skills

SQL querying

Excel advanced

Power BI

DAX

Data modeling

Communication

Analytical thinking

Education

Bachelor's degree in accounting or finance

CPA or MBA preferred

Tools

PySpark

Microsoft Fabric

Transact-SQL

Job description

The Senior Financial Data Analyst position supports the Finance Data & Analytics team in Chicago, partnering with senior leaders to clarify financial performance and business operations through advanced analytics, financial modeling, SQL, and Microsoft Power BI.

Role Overview

Reporting to the Finance Data & Analytics Manager, this role investigates data flows, enhances the Finance data mart, and supports executive reporting and insights. The work focuses on turning transactional information into analysis-ready models and delivering clear, actionable reporting for committees, the Chief Financial Officer (CFO), and senior management.

Responsibilities

Support key initiatives using financial modeling, data mining, and analysis, integrating information from multiple sources to produce specialized firm and client reporting.
Transform transactional data into intuitive fact-and-dimension models that enable efficient analysis by both technical and non-technical users.
Design and enhance Power BI models, reports, measures, and Data Analysis Expressions (DAX) solutions to improve access to meaningful financial information.
Collaborate with senior management, firm partners, functional leaders, and other stakeholders to understand goals and determine effective data and delivery approaches.
Use Transact-SQL and related data tools to extract, organize, validate, and present information in clear, useful formats.
Analyze complex datasets to identify patterns, correlations, gaps, and insights that support informed decision-making.
Introduce practical analytical approaches, assess the impact of process changes, and contribute to system and process re-engineering efforts.
Prepare accurate, timely reporting for committees, the CFO, and other senior leaders.
Stay current with Power BI developments and work across teams to improve how financial data is used throughout the firm.

Required Qualifications

Bachelor’s degree in accounting or finance (or comparable experience).
At least six years of progressively responsible accounting or finance experience; experience in a law firm or professional services environment is a plus.
Strong SQL querying skills with experience building complex queries, supported by a solid understanding of relational database concepts.
Advanced Microsoft Excel skills.
Ability to collect, organize, interpret, and communicate complex information accurately, connecting detailed findings to broader business objectives.
Proactive approach to identifying next steps, exploring solutions, anticipating potential barriers, and gathering input from relevant stakeholders.
Strong written, verbal, interpersonal, and organizational skills, with the ability to work effectively independently and as part of a team.
Excellent attention to detail, sound judgment, commitment to confidentiality, and a strong customer-service mindset.

Preferred Qualifications

Certified Public Accountant (CPA) status or Master of Business Administration (MBA).
Experience with PySpark, Microsoft Fabric notebooks and batch jobs, Power BI reporting, DAX, or tabular modeling.

Technologies