> Markdown version of [/jobs/ext/1471456-business-intelligence-data-modeler-engineer-ii](https://www.wearedevelopers.com/jobs/ext/1471456-business-intelligence-data-modeler-engineer-ii). 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). --- # Business Intelligence Data Modeler Engineer II - **Company:** Class Valuation, LLC - **Location:** Chicago, IL, United States - **Experience:** Expert - **Salary:** $116,000.0 - $144,000.0 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Agile Methodology, Data Analysis, Business Systems, C Sharp (Programming Language), Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Security, Data Structures, Data Warehousing, Relational Databases, Dimensional Modeling, Python (Programming Language), Microsoft SQL Server, Performance Tuning, Power BI, SQL Databases, Data Streaming, Transact-SQL, Qliksense, Scripting, 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:** July 28, 2026 - **Apply:** https://www.dice.com/job-detail/8bb7b163-37ac-4e58-9c84-6adbf188dd34 ## About the Role Education: Bachelor's degree in computer science, a related field, or equivalent practical experience. Experience: 7+ years of experience in data modeling, data warehousing, and ETL processes. Required Data Modeling Expertise: Strong Hands-on experience of dimensional modeling, fact tables, star/snowflake schemas, slowly changing dimensions (SCDs), and tools like Erwin. Technical Skills: Expertise with SQL (including Transact-SQL) and deep experience with relational database systems such as Microsoft SQL Server. Data Engineering Knowledge: 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. Analytics & BI Tools: Familiarity with Business Intelligence (BI) platforms such as Microsoft Power BI and Qlik Sense, and experience supporting enterprise reporting. Programming & Scripting: Exposure to Python, PySpark, Databricks, or programming languages like Java or C# is a plus. Data Governance & Security: Understanding of data governance principles, access controls, and data protection best practices. Business Acumen: Experience working with operational analytics domains such as Human Resources (HR), Finance, or Risk Management; professional services industry experience is a plus. Collaboration & Communication: Strong problem-solving, interpersonal, and communication skills with the ability to work cross-functionally. Work Style: Highly organized, self-motivated, and able to thrive in a fast-paced, Agile project environment managing multiple priorities. If you're ready to help shape how data drives smarter decisions and deliver impactful insights as a Business Intelligence Data Modeler Engineer II, we'd love to hear from you! ## Description Are you passionate about turning complex data into meaningful insights that drive business decisions? As a Business Intelligence Data Modeler Engineer II, you'll play a critical role in shaping how data is structured, accessed, and for enterprise business intelligence. Partnering closely with business analysts, data engineers, and business stakeholders, you'll design and support development of data models that power reporting, analytics. This role blends technical expertise with business insight, giving you the opportunity to influence how data supports enterprise-wide decision-making. 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 Business Intelligence (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 Structured Query Language (SQL) queries for ad hoc analysis, troubleshooting, and data validation. Agile Collaboration: Participate in Agile workflows across analysis, development, quality assurance (QA), and user acceptance testing (UAT) phases as a data subject matter expert. Domain Expertise: Build strong knowledge of business systems and data domains to support strategic initiatives. Continuous Learning: Stay current with evolving technologies and industry trends in data modeling and analytics. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)