> Markdown version of [/jobs/ext/2915900-bi-data-modeler-engineer](https://www.wearedevelopers.com/jobs/ext/2915900-bi-data-modeler-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # BI Data Modeler Engineer - **Company:** REQUEST TECHNOLOGY - **Location:** Chicago, IL, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Agile Methodology, Data Analysis, Microsoft Azure, Business Systems, C Sharp (Programming Language), Data Validation, Data Governance, Extract Transform Load (ETL), Data Structures, Data Warehousing, Relational Databases, Dimensional Modeling, Python (Programming Language), Microsoft Data Access Components, Microsoft SQL Server, Power BI, SQL Databases, Data Streaming, Transact-SQL, Qliksense, Azure Data Factory, Database Performance, Microsoft Fabric, Data Lakes, Pyspark, Information Technology, Data Analytics, Physical Data Models, Azure Synapse Analytics, Data Pipelines, Databricks, Programming Languages - **Published:** September 15, 2026 - **Apply:** https://www.dice.com/job-detail/425f5599-9c9d-42d9-96aa-b99745dfc810 ## About the Role · 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. · Strong Hands-on experience of dimensional modeling, fact tables, star/snowflake schemas, slowly changing dimensions (SCDs), and tools like Erwin. · Expertise with SQL (including Transact-SQL) and deep experience with relational database systems such as Microsoft SQL Server. · Experience with data pipelines using ETL or Extract, Load, Transform (ELT) techniques and tools such as Azure Data Factory (ADF) to load data into analytics data marts, data warehouses and data lakes. Experience with analytics data platforms such as Azure Synapse Analytics, OneLake or Microsoft Fabric. · Familiarity with Business Intelligence (BI) platforms such as Microsoft Power BI and Qlik Sense, and experience supporting enterprise reporting. · Exposure to Python, PySpark, Databricks, or programming languages like Java or C# is a plus. · Understanding of data governance principles, access controls, and data protection best practices. ## Description An established firm is looking for BI Data Modeler Engineer. This role will be focused on data modeling, Microsoft tech Stack, SQL Server, Azure, Azure Synapse Analytics, and Microsoft Data Analytics Foundation. Responsibilities: · Create and maintain conceptual, logical, and physical data models that support reporting and analytics across enterprise systems. · Collaborate with stakeholders to translate business needs into scalable data structures and solutions. · Contribute to the design of Extract, Transform, Load (ETL) processes to ensure efficient data movement into Business Intelligence (BI) platforms and warehouses. · Implement checks and rules to ensure data accuracy, consistency, and reliability across systems. · Continuously monitor and refine data models and database performance for efficient querying and reporting. · Maintain clear documentation of models, schemas, and data flows while adhering to data governance standards. · Help design access controls and security measures to protect sensitive data. · Develop and utilize Structured Query Language (SQL) queries for ad hoc analysis, troubleshooting, and data validation. · Participate in Agile workflows across analysis, development, quality assurance (QA), and user acceptance testing (UAT) phases as a data subject matter expert. · Build strong knowledge of business systems and data domains to support strategic initiatives. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)