Join our talent network

Business Intelligence Engineer II

Job ID: 7374

Updated: Oct 23, 2023

Location: Chicago, IL, United States

Category: Information Technology


About Kirkland & Ellis

At Kirkland & Ellis, we are united in our ambition and drive to move forward. We share core values that help us achieve excellence: collaboration, talent empowerment, service, inclusion, respect and gratitude. Our people are our greatest asset, and we invest in the brightest talent and encourage a diversity of perspectives and strengths to create dynamic teams that operate at the pinnacle of their field. Our talented professionals show up every day knowing they will engage in meaningful work, continuous learning and professional development.
As one of the world’s leading law firms, we serve a broad range of clients with market-leading practices in private equity, M&A and other complex corporate transactions; investment fund formation and management; restructurings; high-stakes litigation and trials; and government, regulatory and internal investigations. We handle the most complicated and sophisticated legal matters because we don’t just meet industry standards, we create them. We bring innovation and entrepreneurialism to every engagement and, as a result, have long-standing client relationships with leading global corporations and financial sponsors. With 6,500 employees (including 3,500+ lawyers) operating from 19 offices across the United States, Europe and Asia, we are one of the largest law firms in the world and a top financial performer.

Essential Job Functions

The Business Intelligence Engineer II is responsible for analysis, requirements gathering, design, development, testing, and documenting to build visualizations leveraging the Firm’s BI Toolset. Possess both technical and business-facing skills that allows driving solutions from a functional and technical perspective. The Business Intelligence team is chartered with providing the skills and innovative technologies to design, develop, produce and sustain data analytics and reporting projects across the firm.


  • Responsible for designing, developing and testing actionable PowerBI/Qlik dashboards with strong emphasis on UI and UX design;
  • Ensure support in analysis and design during all phases of software production, including suggesting the most effective solutions for its implementation;
  • Gather and document functional and technical requirements, and translate requirements into solutions using PowerBI/Qlik;
  • Collaborate with data engineers on architecture required to support visualization applications and ensure sustainable and timely data pipelines;
  • Proactively identify and communicate dependencies, issues, risks and, or barriers to completing assignments, and escalate to appropriate project stakeholders and, or supervisors;
  • Contribute to and assist in defining best practices around dashboard development, testing, access management and refresh scheduling;
  • Help drive user adoption of visualization applications and evangelize data-driven decision making across the firm;
  • Support the availability and optimized performance of developed applications and visualizations;
  • Maintain changes to data structures, schema and documentation associated with the BI applications;
  • Ensure software standards are met and comply with the firm’s policies on governance and risk mitigation;
  • Recommend enhancements and modifications to optimize business intelligence processes;
  • Work in a highly agile development environment;
  • Develop a strong understanding of the business and its' systems to support the firm's strategic objectives;
  • Be a resource and advocate for data within the organization by teaching and empowering others to use data;
  • Maintains up-to-date awareness of current and future directions of business industry and associated technologies;

Qualifications & Requirements

Education, Work Experience, Skills

The candidate must have a BA/BS in computer science, related field, or equivalent experience with 5+ years’ experience of reporting and data analytics. The ideal candidate must have good judgment, problem-solving, oral, written and interpersonal communication skills, as well as the ability to work in a fast-paced environment and build positive working relationships. In addition, candidates must be self-motivated, organized, and able to multi-task and effectively prioritize competing demands, along with:

  • Expertise required in the design, development, implementation and maintenance of PowerBI (Qlik Sense a plus).
  • Proficient in best practices around visualization and story-telling with data;
  • Strong understanding of relevant data security concepts, e.g. row-level, etc;
  • Able to manage requirements gathering and client interactions;
  • Knowledge of database design techniques and advanced SQL skills preferably on the SQL Server platform and/or Azure Synapse Data Marts;
  • Experience working with relational and dimensional data models;
  • Be able to understand and work with disparate data sources;
  • Experience delivering business intelligence solutions in a legal environment is a plus;
  • Ability to quickly understand business issues and data challenges of the organization;
  • The ideal candidate has tactical experience with data warehouse implementations and master data management practices;
  • Self-starter, team-player and will be expected to manage and complete their tasks in a fast-paced results driven environment;


  • PowerBI
  • Qlik
  • Azure Synapse
  • Transact-SQL Query

How to Apply

Thank you for your interest in Kirkland & Ellis LLP.  To complete an application and submit your resume, please click "Apply Now."

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.

Closing Statement

The job postings and recruiting mailbox are for candidates only. If you are a recruiter, search firm or employment agency, and do not have a signed contract with Kirkland & Ellis LLP ("K&E") and have not been asked specifically to submit candidates, you will not be compensated in any way for your referral of a candidate even if K&E hires the candidate. Direct contact with K&E employees in an attempt to present candidates is inappropriate and will be a factor in determining any future professional relationship with the Firm. #LI-Hybrid #LI-LC1

Talemetry Abbreviated Job Desc

The Business Intelligence Engineer II is responsible for analysis, requirements gathering, design, development, testing, and documenting to build visualizations leveraging the Firm’s BI Toolset.