Why this role stands out
This role offers a compelling opportunity to shape critical business intelligence initiatives with a strong emphasis on data modeling and warehousing, leveraging your expertise in dimensional modeling and ETL. You'll thrive here if you possess a deep understanding of SQL, relational databases, and BI platforms, contributing to impactful analytics and reporting. Apply to join a reputable company and advance your career in data engineering.
Quick overview
Job description
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.
Similar jobs
- TT
Data Engineer/Database Administrator with Security ClearanceRecently posted
Tygart Technology Inc · Quantico, VA · Hybrid 🇺🇸
MySQLOracleSQL+2Technology$130k - $160k/yr - RD

Data EngineerRecently posted
Randstad Digital · Atlanta, GA · On-site 🇺🇸
SQLETLDatabricks+9Technology$55 - $61/hr - SH

Data Engineer (Mid or Senior Level) with Security ClearanceRecently posted
Summit Human Capital · Adelphi, MD · Hybrid 🇺🇸
ETLLogstashBash+5Technology$145k - $185k/yr - JI
Snowflake Data Engineer / Senior Data Engineer - W2Recently posted
Jupiter IT Solutions LLC · Kansas City, KS · Hybrid 🇺🇸
SQLAWSETL+6TechnologySalary not listed - VT

Senior Data EngineerRecently posted
Vsion Technologies Inc · United States · Remote 🇺🇸
SQLApache SparkETL+7TechnologySalary not listed - C-

Senior Data ScientistRecently posted Auto Apply
Cognite - AI for Industry · USA (Phoenix) · Hybrid 🇺🇸
GCPSQLGit+16TechnologySalary not listed - Y-

Senior Data Engineer - Airflow, DBT Core, Kubernetes/OpenShift - Hybrid Onsite in Jersey CityRecently posted
Yoh - A Day & Zimmerman Company · Jersey City, NJ · Hybrid 🇺🇸
AirflowApachedbt+1Technology$75 - $95/hr - CR
Senior Data Engineer
Credence · Columbus, OH · Hybrid 🇺🇸
FastAPIGCPSQL+23Technology$115k - $155k/yr - GL
Jr. Data Engineer/Architect - Plano, TX - ONLY LOCAL & W2Recently posted
Geopaq Logic · Plano, TX · Hybrid 🇺🇸
OracleSQLApache Spark+7TechnologySalary not listed - MT
AWS Data Engineer
Microgreen Technologies LLC · Plano, TX · Hybrid 🇺🇸
DynamoDBGitApache Spark+11Technology$55 - $60/hr - SW

Data EngineerRecently posted
Swanktek Inc · Irving, TX · Hybrid 🇺🇸
DockerSQLApache Spark+6TechnologySalary not listed - AE
Cybersecurity data engineer with Security ClearanceRecently posted
Anonymous Employer · Adelphi, MD · Hybrid 🇺🇸
GCPOracleRuby+9TechnologySalary not listed
