Business Intelligence Engineer II

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

• Design, build, and test impactful Microsoft Power BI dashboards with a strong focus on user interface (UI) and user experience (UX).
• Gather and document business and technical requirements, transforming them into scalable reporting and visualization solutions.
• Partner with data engineers to define architecture and ensure reliable, efficient data pipelines for analytics applications.
• Support all phases of development, from analysis and design to implementation and optimization.
• Help define and uphold standards for dashboard development, testing, access management, and data refresh processes.
• Maintain application performance, ensuring availability and a seamless user experience.
• Ensure compliance with organizational policies around data governance, risk management, and security.
• Promote adoption of BI tools by empowering business users and championing data-driven decision-making.
• Identify and recommend enhancements to optimize BI processes, reporting standards, and data structures.
• Support report writers and collaborate across technical and non-technical teams to meet evolving business needs.
• Work with operational support teams to maintain a healthy, efficient reporting environment in an agile setting.

What You’ll Bring

• Education: Bachelor’s degree in computer science or a related field, or equivalent experience.
• Experience: 5+ years of experience in reporting, data analytics, or business intelligence development.
• Required Power BI Expertise: Proven ability to design, develop, and maintain Microsoft Power BI dashboards and reports.
• Data & Technical Skills: Advanced Transact-SQL (T-SQL) skills, strong understanding of database design, and experience with relational and dimensional data models.
• Visualization & Storytelling: Strong grasp of data visualization best practices and the ability to communicate insights effectively.
• Data Security Knowledge: Familiarity with data security concepts such as row-level security and governance controls.
• Collaboration & Communication: Ability to manage stakeholder interactions, gather requirements, and build strong working relationships.
• Tools & Technologies: Experience with Microsoft Fabric, Microsoft SQL Server Management Studio (SSMS), Microsoft Report Builder, and Microsoft Visual Studio; familiarity with Qlik and SQL Server Reporting Services (SSRS) is a plus.
• Adaptability: Comfort working with diverse data sources in a fast-paced, agile environment.
• Mindset: Self-starter who is organized, detail-oriented, and committed to delivering high-quality, impactful solutions.

Preferred

• Exposure to server administration, master data management practices, or delivering BI solutions within a legal environment is a plus.

How to Apply

To complete an application and submit your resume, please click "Apply Now." Don't meet every job requirement? That's okay! If you're excited about this role but your experience doesn't perfectly fit every qualification, we encourage you to apply anyway. You may be just the right person for this role or others at Kirkland.

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.

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: $101,000 - $144,000