Senior Financial Data Analyst
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.