Senior BI Data Modeling Engineer

Request Technology, LLC; Chicago (IL); On-site; USD 140,000 - 180,000; Full time

Job summary

Request Technology, LLC in Chicago is seeking a Senior Data Architect to design and govern enterprise data models across analytics platforms. You will drive dimensional modeling, data warehousing, and secure data access in collaboration with stakeholders.

Responsibilities include building scalable data structures, guiding ETL/ELT pipelines, ensuring data quality, and optimizing performance for BI reporting using SQL Server, Azure Synapse, and Power BI.

Qualifications

• 7+ years of experience in data modeling, data warehousing, and ETL processes.
• Hands-on experience with dimensional modeling, star/snowflake schemas, SCDs, and Erwin.
• Expertise with SQL (T-SQL) and Microsoft SQL Server.
• Experience with ETL/ELT data pipelines using Azure Data Factory.
• Experience with analytics platforms such as Azure Synapse Analytics, OneLake or Microsoft Fabric.
• Familiarity with BI platforms such as Power BI and Qlik Sense for enterprise reporting.
• Exposure to Python, PySpark, Databricks.
• Understanding of data governance, access controls, and data protection.
• Experience in HR, Finance, or Risk Management domains; professional services experience a plus.

Responsibilities

• Data Modeling Design: Create and maintain conceptual, logical, and physical data models that support reporting and analytics across enterprise systems.
• Business Partnership: Collaborate with stakeholders to translate business needs into scalable data structures and solutions.
• ETL Development Support: Contribute to the design of Extract, Transform, Load (ETL) processes to ensure efficient data movement into BI platforms and warehouses.
• Data Quality & Validation: Implement checks and rules to ensure data accuracy, consistency, and reliability across systems.
• Performance Optimization: Continuously monitor and refine data models and database performance for efficient querying and reporting.
• Documentation & Governance: Maintain clear documentation of models, schemas, and data flows while adhering to data governance standards.
• Data Security: Help design access controls and security measures to protect sensitive data.
• Advanced Querying: Develop and utilize SQL queries for ad hoc analysis, troubleshooting, and data validation.
• Agile Collaboration: Participate in Agile workflows across analysis, development, QA, and UAT phases as a data SME.

Skills

Data modeling

Data warehousing

ETL/ELT processes

Dimensional modeling

SQL / T-SQL

Relational databases (SQL Server)

Azure Data Factory

BI platforms (Power BI, Qlik Sense)

Python / PySpark / Databricks

Data governance & security

Tools

Erwin

Job description

Request Technology, LLC in Chicago is seeking a Senior Data Architect to design and govern enterprise data models across analytics platforms. You will drive dimensional modeling, data warehousing, and secure data access in collaboration with stakeholders.

Responsibilities include building scalable data structures, guiding ETL/ELT pipelines, ensuring data quality, and optimizing performance for BI reporting using SQL Server, Azure Synapse, and Power BI.