Hybrid BI Data Modeler Engineer: Azure, SQL, Synapse

Request Technology, LLC; Chicago (IL); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Request Technology, LLC is seeking a BI Data Modeler Engineer in Chicago, combining onsite and remote work in a hybrid model. You will lead data modeling across enterprise systems, work with SQL Server, Azure Synapse Analytics, and the Microsoft Data Analytics Foundation to enable robust analytics and reporting.

The role requires 7+ years in data modeling and ETL, with hands-on experience in dimensional modeling, Erwin, and modern data pipelines using ADF, Synapse, and analytics platforms like

Qualifications

• Bachelor’s degree in computer science, a related field, or equivalent practical experience.
• 7+ years of experience in data modeling, data warehousing, and ETL processes.

Responsibilities

• Create and maintain conceptual, logical, and physical data models for reporting and analytics across enterprise systems.
• Collaborate with stakeholders to translate business needs into scalable data structures and solutions.
• Design ETL/ELT processes to load data into BI platforms and data warehouses.
• Implement data quality checks and governance controls.
• Monitor and optimize data models and query performance for reporting.
• Document models, schemas, and data flows with governance standards.
• Assist with access controls and data security considerations.
• Develop SQL queries for ad hoc analysis and validation.
• Participate in Agile workflows as a data SME.
• Build knowledge of business systems and data domains to support initiatives.

Skills

Dimensional modeling

SQL / T-SQL

Azure Synapse Analytics

Azure Data Factory

Power BI / Qlik Sense

Python / PySpark

Java / C#

Data governance

Education

Bachelor's degree in CS or related field

Tools

Erwin

Job description

Request Technology, LLC is seeking a BI Data Modeler Engineer in Chicago, combining onsite and remote work in a hybrid model. You will lead data modeling across enterprise systems, work with SQL Server, Azure Synapse Analytics, and the Microsoft Data Analytics Foundation to enable robust analytics and reporting.

The role requires 7+ years in data modeling and ETL, with hands-on experience in dimensional modeling, Erwin, and modern data pipelines using ADF, Synapse, and analytics platforms like