FinanceJobs.io
← Back to all jobs

Job Description

Drive financial insight on Kirkland and Ellis’ Finance Data & Analytics team in Chicago through advanced analytics, modeling, and reporting.

Responsibilities

  • Advance firm and client reporting initiatives using financial modeling, data mining, and analysis across multiple data sources.
  • Convert transactional data into fact-and-dimension structures that support efficient analysis for both technical and non-technical users.
  • Develop and improve Power BI solutions, including models, reports, measures, and DAX to surface meaningful financial information.
  • Partner with senior management, firm partners, functional leaders, and stakeholders to align on goals and determine the most effective data and delivery approach.
  • Use Transact-SQL and related tools to extract, organize, validate, and present information in clear formats.
  • Analyze complex datasets to identify patterns, correlations, gaps, and insights that support informed decision-making.
  • Apply analytical approaches to assess the impact of process changes and contribute to system and process re-engineering efforts.
  • Deliver accurate, timely reporting for committees, the CFO, and other senior leaders.
  • Monitor Power BI developments and collaborate across teams to improve how financial data is used throughout the firm.
  • Investigate data flows and support enhancements to the Finance data mart.

Requirements

  • Bachelor’s degree in accounting or finance (or comparable experience).
  • 6+ years of progressively responsible accounting or finance experience; law firm or professional services experience is a plus.
  • Strong SQL skills, including building complex queries with a solid understanding of relational database concepts.
  • Advanced Microsoft Excel skills.
  • Ability to collect, organize, interpret, and communicate complex information accurately, tying detailed findings to broader business objectives.
  • Proactive mindset for identifying next steps, exploring solutions, anticipating barriers, and gathering input from stakeholders.
  • Strong written, verbal, interpersonal, and organizational skills; ability to operate independently and collaboratively across all levels.
  • Excellent attention to detail, sound judgment, commitment to confidentiality, and a strong customer-service mindset.
  • Preferred: CPA status or MBA.
  • Highly valued: experience with PySpark, Microsoft Fabric notebooks, and batch jobs; also Power BI reporting, DAX, or tabular modeling.

Technologies

  • SQL, Transact-SQL
  • Microsoft Power BI, Power BI reporting
  • Data Analysis Expressions (DAX)
  • Tabular modeling
  • Microsoft Excel
  • PySpark
  • Microsoft Fabric (notebooks, batch jobs)

Location

  • Chicago, IL (hybrid)

Compensation

  • $100,000 - $138,000 annually (Chicago)

Benefits

  • Comprehensive healthcare
  • Paid time off
  • Retirement
  • Flexible benefits
  • Personal support
  • Tailored learning and development opportunities

How to Apply

Click Apply Now to complete the application and submit your resume.

Similar Jobs