Business Intelligence Engineer II

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

Benefits offered by this job

Healthcare

Paid time off

Retirement plan

Learning & development

Job summary

Kirkland & Ellis in Chicago is seeking a Business Intelligence Engineer II to design and deliver high-impact analytics and reporting solutions. You will work with data engineers, business partners, and stakeholders to build intuitive Power BI dashboards and scalable analyses that inform strategic decisions.

The role emphasizes data governance, security, and reliable data pipelines, with opportunities to influence reporting standards, improve data models, and mentor teammates in a fast-paced,

Qualifications

• Bachelor's degree in CS or related field or equivalent experience.
• 5+ years in reporting, data analytics, or BI development.

Responsibilities

• Design, develop, test and deploy Power BI dashboards with strong UI/UX.
• Translate business requirements into scalable reporting solutions.
• Partner with data engineers to define data pipelines.
• Deliver end-to-end BI solutions from analysis to optimization.
• Help define dashboard standards, access controls and data refresh.
• Monitor performance and ensure reliable data delivery.
• Promote data governance and security compliance.
• Enable users and drive adoption of BI tools.
• Identify improvements to BI processes and data structures.
• Collaborate across technical and non-technical teams.

Skills

Power BI

T-SQL

Data modeling

Data visualization

Stakeholder management

UI/UX awareness

Collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Microsoft Fabric

SSMS

Report Builder

Visual Studio

Qlik

SSRS

Job description

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

Are you passionate about turning data into compelling, actionable insights that drive smarter business decisions? As a Business Intelligence Engineer II, you’ll play a key role in designing and delivering high-impact analytics and reporting solutions. You’ll collaborate closely with data engineers, business partners, and stakeholders to build intuitive visualizations using Microsoft’s Business Intelligence (BI) toolset. This role sits within a team dedicated to advancing data-driven decision-making across the firm, combining technical expertise with a strong understanding of business needs.

• Dashboard Development: Design, build, and test impactful Microsoft Power BI dashboards with a strong focus on user interface (UI) and user experience (UX).
• Requirements Translation: Gather and document business and technical requirements, transforming them into scalable reporting and visualization solutions.
• Data Collaboration: Partner with data engineers to define architecture and ensure reliable, efficient data pipelines for analytics applications.
• End-to-End Delivery: Support all phases of development, from analysis and design to implementation and optimization.
• Standards & Best Practices: Help define and uphold standards for dashboard development, testing, access management, and data refresh processes.
• Performance & Reliability: Monitor and maintain application performance, ensuring availability and a seamless user experience.
• Data Governance: Ensure compliance with organizational policies around data governance, risk management, and security.
• User Enablement: Promote adoption of BI tools by empowering business users and championing data-driven decision-making.
• Continuous Improvement: Identify and recommend enhancements to optimize BI processes, reporting standards, and data structures.
• Cross-Functional Support: Support report writers and collaborate across technical and non-technical teams to meet evolving business needs.
• Operational Excellence: 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

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

If you’re excited to create meaningful insights, shape how data is used across an organization, and make an impact as a Business Intelligence Engineer II, we’d love to hear from you!

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

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.

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. #LI-Hybrid #LI-CF1