Senior Financial Data Analyst

Kirkland & Ellis; Chicago (IL); On-site; USD 100,000 - 138,000; Full time

Benefits offered by this job

Healthcare

Paid time off

Retirement benefits

Learning & development opportunities

Job summary

Kirkland & Ellis is seeking a Senior Financial Data Analyst in Chicago to leverage advanced analytics, financial modeling, SQL, and Power BI to illuminate financial performance and operations for senior leaders.

The role reports to the Finance Data & Analytics Manager and involves data flows, data mart enhancements, and turning data into trusted insights for executives.

Qualifications

• Bachelor's degree in accounting or finance required or comparable experience.
• CPA or MBA is preferred.
• Six+ years of progressively responsible accounting or finance experience; law firm or professional services a plus.
• Strong SQL querying skills and experience building complex queries; relational databases understood.

Responsibilities

• Deliver strategic insights: finance modeling and analysis drawing from multiple data sources.
• Build scalable data models to enable efficient analysis for technical and non‑technical users.
• Advance business intelligence by designing Power BI models, reports, and DAX solutions.
• Translate business needs by partnering with senior management and stakeholders.
• Develop complex queries using Transact-SQL to extract and format information.

Skills

Financial analysis

Analytical thinking

Communication

Leadership

Education

Bachelor's in accounting or finance

CPA or MBA preferred

Tools

SQL

PySpark

Power BI

DAX/Tabular modeling

Fabric notebooks

Job description

About Kirkland & Ellis

At Kirkland & Ellis, we don’t just meet the standard for legal excellence — we set it. Our culture is built on teamwork, ingenuity and an unwavering commitment to continuous growth. We tackle the most sophisticated legal challenges with bold ideas and innovative solutions, powered by the exceptional experience and ambition of our 7,000+ people, including 4,000+ attorneys, across 24 offices worldwide. Our dedicated professionals share our lawyers’ commitment to excellence and show up each day to do meaningful work that helps drive global business, investment and innovation forward.

About Kirkland & Ellis

At Kirkland & Ellis, we don’t just meet the standard for legal excellence — we set it. Our culture is built on teamwork, ingenuity and an unwavering commitment to continuous growth. We tackle the most sophisticated legal challenges with bold ideas and innovative solutions, powered by the exceptional experience and ambition of our 7,000+ people, including 4,000+ attorneys, across 24 offices worldwide. Our dedicated professionals share our lawyers’ commitment to excellence and show up each day to do meaningful work that helps drive global business, investment and innovation forward.

What You’ll Do

As a Senior Financial Data Analyst on the Finance Data & Analytics team in Chicago, you will use advanced analytics, financial modeling, Structured Query Language (SQL), and Microsoft Power BI to help senior leaders understand financial performance, business operations, and critical management issues. Reporting to the Finance Data & Analytics Manager, you will investigate data flows, translate business needs into effective solutions, enhance the Finance data mart, and make trusted information more accessible to business users.

• Deliver strategic insights: Support key initiatives through financial modeling, data mining, and analysis, bringing together information from multiple sources for specialized firm and client reporting.
• Build scalable data models: Transform transactional data into intuitive fact-and-dimension models that enable efficient analysis by technical and non-technical users.
• Advance business intelligence: Design and enhance Power BI models, reports, measures, and Data Analysis Expressions (DAX) solutions that improve access to meaningful financial information.
• Translate business needs: Partner with senior management, firm partners, functional leaders, and other stakeholders to understand their goals and identify the most effective data and delivery approach.
• Develop complex queries: Use Transact-SQL and related data tools to extract, organize, validate, and present information in clear, useful formats.
• Uncover trends and opportunities: Analyze complex datasets to identify patterns, correlations, gaps, and insights that support informed decision-making.
• Improve tools and processes: Introduce practical analytical approaches, evaluate the effects of process changes, and contribute to system and process re-engineering efforts.
• Support executive reporting: Prepare accurate, timely reporting for committees, the Chief Financial Officer (CFO), and other members of senior management.
• Strengthen analytics capabilities: Stay current with Power BI developments and collaborate across teams to improve how financial data is used throughout the firm.

What You’ll Bring

• Education: A bachelor’s degree in accounting or finance, or comparable experience, is required. Certified Public Accountant (CPA) status or a Master of Business Administration (MBA) is preferred.
• Experience: At least six years of progressively responsible accounting or finance experience; experience in a law firm or professional services environment is a plus.
• SQL expertise: Strong SQL querying skills and experience building complex queries, supported by a solid understanding of relational database concepts.
• Analytics technology: Advanced Microsoft Excel skills are required. Experience with PySpark, Microsoft Fabric notebooks and batch jobs, Power BI reporting, DAX, or tabular modeling is highly valued.
• Analytical thinking: The ability to collect, organize, interpret, and communicate complex information accurately while connecting detailed findings to broader business objectives.
• Initiative and problem-solving: A proactive approach to identifying next steps, exploring solutions, anticipating potential barriers, and gathering input from relevant stakeholders.
• Communication and collaboration: Strong written, verbal, interpersonal, and organizational skills, with the ability to work effectively across all levels of the firm, both independently and as part of a team.
• Service and precision: Excellent attention to detail, sound judgment, a commitment to confidentiality, and a strong customer-service mindset.

If you’re excited to transform financial data into actionable insight and help leaders make well-informed decisions, we’d love to hear from you for this Senior Financial Data Analyst opportunity!

Compensation

The base salary range below represents the low and high end of the salary range for this position in Chicago. This range may differ based on your geographic location and cost of living considerations. At Kirkland & Ellis, we consider compensation more than just a base salary. We offer an exceptional range of flexible benefits including comprehensive healthcare, paid time off, and retirement. We also offer personal support and tailored learning and development opportunities all designed to help you realize your full potential both in life and at work.

Compensation Range

Chicago $100,000 - $138,000

Equal Employment Opportunity

All employment decisions, including the recruiting, hiring, placement, training availability, promotion, compensation, evaluation, disciplinary actions, and termination of employment (if necessary) are made without regard to the employee’s race, color, creed, religion, sex, pregnancy or childbirth, personal appearance, family responsibilities, sexual orientation or preference, gender identity, political affiliation, source of income, place of residence, national or ethnic origin, ancestry, age, marital status, military veteran status, unfavorable discharge from military service, physical or mental disability, or on any other basis prohibited by applicable law.