Business Intelligence Data Modeler Engineer

SCIGON

Chicago (IL)

On-site

USD 116,000 - 144,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Healthcare benefits
Paid time off
Retirement plan
Professional development resources

Job summary

SCIGON, based in Chicago, seeks a Business Intelligence Data Modeler Engineer II to architect data models that power reporting and analytics across the enterprise.

Collaborate with analysts, data engineers, and stakeholders to translate requirements into scalable data solutions and to design ETL processes that feed BI platforms and warehouses.

The role emphasizes SQL proficiency, governance, and staying current with evolving BI tools and best practices.

Qualifications

  • Bachelor's degree in CS or related field plus 7+ years in data modeling, warehousing, ETL.
  • Strong dimensional modeling knowledge with fact tables, star/snowflake schemas, SCDs, and Erwin.

Responsibilities

  • Design conceptual, logical, and physical data models for enterprise reporting and analytics.
  • Translate business requirements into structured, scalable data solutions with stakeholders.
  • Contribute to ETL design to move data into BI platforms and warehouses.
  • Create data quality checks to ensure accuracy and consistency of data.
  • Monitor and optimize data models and database performance for efficient queries.
  • Document models, schemas, and data flows in alignment with governance.

Skills

Dimensional modeling
SQL (T-SQL)
ETL/ELT
Azure Data Factory
Azure Synapse Analytics
Power BI
Data governance
Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Erwin
Azure Data Factory
Azure Synapse Analytics
OneLake
Microsoft Fabric

Job description

Business Intelligence Data Modeler Engineer

What You'll Do

If you're someone who gets excited about building the data structures that make analytics actually work, this role is worth a close look.

As a Business Intelligence Data Modeler Engineer II, you'll be at the center of how data gets organized, accessed, and put to use across the enterprise. You'll work directly with business analysts, data engineers, and stakeholders to design data models that fuel reporting and analytics, while helping shape the broader data strategy. It's a role that calls for both technical depth and genuine curiosity about how a business operates.

Day to day, you can expect to:

  • Work on conceptual, logical, and physical data models that underpin enterprise reporting and analytics.
  • Partner with stakeholders to translate business requirements into well-structured, scalable data solutions.
  • Contribute to the design of ETL processes that move data efficiently into BI platforms and warehouses.
  • Build and enforce data quality checks to keep information accurate, consistent, and trustworthy.
  • Monitor and tune data models and database performance so queries run efficiently.
  • Create and maintain solid documentation of models, schemas, and data flows, in alignment with governance standards.
  • Support access control and data security design for sensitive datasets.
  • Write sophisticated SQL queries for ad hoc analysis, validation, and troubleshooting.
  • Participate as a data subject matter expert across Agile sprints, from analysis through UAT.
  • Develop deep familiarity with business domains and systems to better support strategic work.
  • Keep pace with evolving tools, technologies, and best practices in data modeling and analytics.

What You'll Bring

A bachelor's degree in computer science, a related field, or equivalent hands-on experience, plus at least seven years working in data modeling, data warehousing, and ETL.

Required skills and experience:

  • Strong working knowledge of dimensional modeling, including fact tables, star and snowflake schemas, slowly changing dimensions, and tools like Erwin.
  • Solid command of SQL (including T-SQL) and deep experience with relational databases, particularly Microsoft SQL Server.
  • Practical experience building data pipelines using ETL or ELT approaches and tools like Azure Data Factory, with exposure to platforms such as Azure Synapse Analytics, OneLake, or Microsoft Fabric.
  • Familiarity with BI tools like Power BI and Qlik Sense, and experience supporting enterprise-level reporting.
  • Understanding of data governance principles, access controls, and data protection practices.
  • Experience working with operational data domains such as HR, Finance, or Risk Management.
  • Clear, confident communication skills and the ability to collaborate across technical and non-technical teams.
  • An organized, self-directed work style that holds up under shifting priorities in a fast-moving environment.

Nice to have: Exposure to Python, PySpark, Databricks, Java, or C#. Professional services industry background is a plus.

Compensation

The base salary range for this position in Chicago is $116,000 to $144,000. Actual compensation may vary based on location and cost of living. In addition to base salary, this role includes a strong benefits package covering comprehensive healthcare, paid time off, retirement, and access to professional development and personal support resources.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Modeling BI Engineer
Data Modeling BI Engineer

Request Technology, LLC • Houston (TX)

On-site
USD 120,000 - 150,000
Bonus eligible
BI Data Modeler Engineer
BI Data Modeler Engineer

Request Technology, LLC • Chicago (IL)

Hybrid
USD 110,000 - 140,000
BI Data Analyst
BI Data Analyst

Eight Eleven Group • Birmingham (AL)

On-site
USD 70,000 - 75,000
Business Intelligence Engineer
Business Intelligence Engineer

penninteractive • United States

Hybrid
USD 80,000 - 115,000
Education reimbursement
Conference reimbursement
Career growth
+1
Senior BI Data Modeler — Hybrid, Impactful Analytics
Senior BI Data Modeler — Hybrid, Impactful Analytics

Kirkland & Ellis • Chicago (IL)

Hybrid
USD 133,000 - 166,000
Comprehensive healthcare
Paid time off
Retirement plan
Business Intelligence Data Modeler Engineer Senior I
Business Intelligence Data Modeler Engineer Senior I

Kirkland & Ellis • Chicago (IL)

Hybrid
USD 133,000 - 166,000
Comprehensive healthcare
Paid time off
Retirement plan
Sr Business Intelligence Analyst (Financial)
Sr Business Intelligence Analyst (Financial)

LaSalle Intelligent Solutions • Chicago (IL)

Hybrid
USD 95,000 - 105,000
Medical Insurance
Dental Insurance
Vision Insurance
+2
Data Modeler - BI Analytics - Onsite (Full Time)
Data Modeler - BI Analytics - Onsite (Full Time)

The Dignify Solutions, LLC • Chicago (IL)

On-site
USD 100,000 - 120,000
Senior Analytics Engineer (Data Modeling & BI)
Senior Analytics Engineer (Data Modeling & BI)

feverup • United States

Hybrid
USD 110,000 - 170,000
Home-office setup
Health insurance
Stock options
+3
Business Intelligence Developer
Business Intelligence Developer

Standard Motor Products • Lewisville (TX)

On-site
USD 80,000 - 100,000