Kirkland & Ellis is looking to solve the problem of transforming complex financial information into clear, actionable insights to support the Firm's financial strategy and strengthen data-driven decision-making across the organization.
Requirements
- Advanced SQL querying skills and proven experience with Power BI tabular modeling.
- Strong understanding of relational database concepts and data architecture.
- Advanced Microsoft Excel skills, with solid experience in database and data visualization tools.
Responsibilities
- Support key Firm initiatives with sophisticated financial modeling, data mining, and analysis to meet specialized reporting needs for leadership and clients.
- Architect and maintain fact-and-dimension-based data structures that simplify access to critical financial information for non-technical users.
- Design and enhance Power BI models and measures using Data Analysis Expressions (DAX) to streamline reporting and analysis.
- Create complex queries using Transact-SQL and related tools to ensure accurate, efficient data extraction and reporting.
- Identify and analyze key performance patterns within large data sets to inform Firm strategy and operations.
- Explore transactional data, apply data mining techniques, and transform results into accessible reports and dashboards.
- Prepare and deliver reports for committees, the Chief Financial Officer (CFO), and other senior management stakeholders.
Other
- Bachelor’s degree in Accounting, Finance, or a related field (or equivalent experience); Certified Public Accountant (CPA) or Master of Business Administration (MBA) preferred with at least 6 years of progressive experience in accounting and/or finance, ideally within a professional services or law firm environment.
- Exceptional ability to collect, organize, analyze, and interpret data with precision, while maintaining awareness of broader business objectives.
- Strong written and verbal communication skills, with the ability to translate complex data into clear insights for all levels of the Firm.
- Highly organized, proactive, and results-oriented, with strong attention to detail and a commitment to excellence and customer service.
