Senior BI Data Modeler & Analytics Engineer II

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

Job summary

Kirkland & Ellis seeks a Business Intelligence Data Modeler Engineer II to shape data architecture for enterprise reporting and analytics. You will design conceptual, logical, and physical models, partner with analysts and data engineers, and contribute to governance and security across BI platforms.

The role emphasizes collaboration across teams, optimizing data movement via ETL/ELT, and building scalable data structures for decision-making. Chicago-based, on-site with competitive compensation.

Qualifications

• Strong hands-on experience with dimensional modeling, star/snowflake schemas, SCDs.
• Experience with Erwin for data modeling and schema design.
• Proficiency in SQL (T-SQL) and relational databases such as SQL Server.

Responsibilities

• Create and maintain data models to support reporting and analytics.
• Collaborate with analysts and engineers to translate business needs into data structures.
• Design ETL/ELT processes for data movement into BI platforms and data warehouses.
• Ensure data quality, governance, and security in data models.
• Optimize performance of models and queries.
• Document models, schemas, and data flows.
• Stay current with evolving data modeling trends.

Skills

Dimensional modeling

SQL/T-SQL

Data warehousing

ETL/ELT

Cross-functional collaboration

Education

Bachelor’s degree in CS or related field

Tools

Erwin

Azure Data Factory

Azure Synapse

Power BI

SQL Server

Qlik Sense

Job description

Kirkland & Ellis seeks a Business Intelligence Data Modeler Engineer II to shape data architecture for enterprise reporting and analytics. You will design conceptual, logical, and physical models, partner with analysts and data engineers, and contribute to governance and security across BI platforms.

The role emphasizes collaboration across teams, optimizing data movement via ETL/ELT, and building scalable data structures for decision-making. Chicago-based, on-site with competitive compensation.