Join our talent network

BI Data Modeler

Job ID: 7354

Updated: Oct 12, 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 BI Data Modeler is responsible for creating and managing data models that support the Firm’s business intelligence and reporting needs. This role involves working closely with business analysts, data engineers, and other stakeholders to design/optimize data structures and flows that facilitate efficient data analysis and reporting.  The BI Data Modeler has both technical and business-facing skills that allows driving solutions from a functional and technical perspective. The Data Modeler is well versed with industry best practices for creating, deploying, and managing data models for the Enterprise Data Warehouse, Data Marts, Data Cubes etc.  

Essential Functions: (This list is not exhaustive and may be supplemented and changed as necessary.)

  • Work with business resources to identify business needs then design and develop conceptual, logical, and physical data models for the needs and support data analysis and reporting.
  • Define and create ETL processes for data extraction, transformation, and loading into the data warehouse or BI platform.
  • Implement data quality checks and validation rules to ensure data accuracy and consistency.
  • Continuously monitor and optimize data models and database performance for efficient data retrieval and reporting.
  • Maintain comprehensive documentation of data models, schemas, and related processes.
  • Apply knowledge of the data in Kirkland’s ecosystem in internal consultations with IT and business staff who want to use this data in reporting and analytics.
  • Implement data security measures and access controls to protect sensitive data.
  • Ensure compliance with data governance and data management best practices.
  • Apply strong skills and experience with SQL and other means to develop data queries for ad hoc reporting, data profiling, validation, trouble shooting and analysis.
  • Identify and execute on new process improvement opportunities.
  • Work in a highly agile development environment.
  • Develop a strong understanding of the business and its systems to support the firm's strategic objectives.
  • Maintain 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 in data modeling concepts and techniques, ETL and data warehousing. 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:
  • Data Modelling skills (e.g., using Erwin to create and manage Logical/physical data models) and expertise in modeling OLAP marts, cubes etc., and understanding on data grain, slowly changing dimensions (SCDs), snowflake/star schemas, row / object level security designs etc. (required).
  • Experience working with relational and dimensional data models, and in developing complex queries using Transact SQL and other data query/reporting tools (required).
  • Knowledge of database design techniques and advanced SQL skills preferably on the SQL Server platform and/or Azure Synapse Data Marts (required).
  • Experience building, managing and optimizing data flows using ETL or ELT techniques in support of the data model buildout (required).
  • Legal or professional services industry experience that demonstrates ability to work in dynamic, fast-paced company / firm working across multiple business areas (desired).
  • The ideal candidate has tactical experience with data warehouse implementations and data mart design.
  • Be able to understand and work with disparate data sources (required).
  • Ability to quickly understand business issues and data challenges of the organization.
  • Self-starter, team-player and will be expected to manage and complete their tasks in a fast-paced results driven environment.


  • Erwin for data modeling
  • Transact-SQL query using tools like SSMS
  • ETL Tools - Talend and/or ADF preferred.
  • Strong knowledge of relational database management systems (RDBMS) such as Microsoft SQL Server and Azure Synapse.
  • Experience with version control systems like Git.
  • Familiarity with BI and reporting tools like Microsoft Power BI, Qlik Sense and Tableau.
  • Proficiency in scripting languages like Python or programming languages like Java or C# is a plus.
  • Microsoft office toolset (Microsoft Outlook, Word, PowerPoint, Excel) and other software as part of standard firm Windows desktop/laptop.

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