Business Intelligence Data Modeling Engineer

NO SPONSORSHIP - NO OPT

Business Intelligence Data Modeler Engineer

Salary: $144-$166

On site 3 days a week - CHICAGO - will also consider Dallas, Austin, Houston, Boston, Palo Alto, LA, NY, Salt Lake City, Miami, Nashville or Philadelphia

7 YEAR DATA MODELING, DATA WAREHOUSING AND ETL dimensional modeling.

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.

• 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.