Senior BI Data Modeler — Hybrid, Impactful Analytics

Kirkland & Ellis; Chicago (IL); Hybrid; USD 133,000 - 166,000; Full time

Benefits offered by this job

Comprehensive healthcare

Paid time off

Retirement plan

Job summary

Kirkland & Ellis is seeking a Senior IT BI Data Modeler Engineer to shape enterprise data for reporting and analytics in Chicago. You will design and maintain dimensional models, collaborate with analysts, engineers, and stakeholders, and ensure data quality and governance across BI platforms.

This role combines deep data modeling expertise with business insight, offering exposure to SQL Server, Azure Data Factory, Synapse, Power BI, and modern data warehouses.

Qualifications

• Bachelor’s degree in computer science or related field required.
• 7+ years of experience in data modeling, data warehousing, and ETL/ELT processes.
• Strong hands-on experience with dimensional modeling (star/snowflake), SCDs, and Erwin.

Responsibilities

• Design and maintain conceptual, logical, and physical data models for enterprise reporting.
• Collaborate with analysts, data engineers and stakeholders to translate requirements into scalable data structures.
• Contribute to ETL/ELT process design for data movement into BI platforms and data warehouses.
• Ensure data quality, governance, and security across systems.
• Develop and optimize SQL queries for ad hoc analysis and validation.
• Support Agile workflows across analysis, development, QA, and UAT.

Skills

Data modeling

SQL

BI collaboration

Agile

Data governance

Education

Bachelor’s degree in computer science or related field

Tools

Erwin

Azure Data Factory

Azure Synapse

Microsoft SQL Server

Power BI

Qlik Sense

Python/PySpark

Job description

Kirkland & Ellis is seeking a Senior IT BI Data Modeler Engineer to shape enterprise data for reporting and analytics in Chicago. You will design and maintain dimensional models, collaborate with analysts, engineers, and stakeholders, and ensure data quality and governance across BI platforms.

This role combines deep data modeling expertise with business insight, offering exposure to SQL Server, Azure Data Factory, Synapse, Power BI, and modern data warehouses.