Chicago, IL

Salary
$105,000from the description
Posted
Aug 4, 2026
Location
Chicago, IL
Last confirmed open
Sep 24, 2026

What this job asks for AI summary

A sole on-site data professional at a Flyover attraction (likely Chicago) who owns the full analytics stack — ingesting POS and ticketing data through Azure Data Factory into a Microsoft Fabric lakehouse, building bronze-to-gold layers, designing star schemas and DAX semantic models, and delivering Power BI dashboards to business stakeholders. The role also covers SQL Server administration for on-premises applications and handles a small amount of in-person Level 1 IT support.

Senior level · 5+ years · Chicago, IL · Full-time

Must have (6)
SQLDAXPower BIAzure Data FactoryMicrosoft Fabric, Azure Synapse Analytics, Azure Sql or SsasSQL Server
Nice to have (3)
Python or SparkGitFabric Data Activator

“or” means any one of them counts — you don't need all of them.

Posted 2 times — it's one opening, so apply once.

We read this from the posting text with AI. Skim the description below before ruling yourself out.

How this req sits in the market our data

Roughly 8 people in the Chicago, IL area plausibly meet what this posting asks for (database administrators). range 3–15

Applicant volume Light — Few people clear these requirements, so an application that does clear them gets looked at. Worth applying to even if you miss a nice-to-have.

What gives you an edge
Azure Data Factory5%Microsoft Fabric5%Power BI10%

Rare in this occupation — lead with these, and say what you built with them.

What won't set you apart
SQL90%SQL Server55%

Most people in this occupation already list these. Still required — just not what gets you shortlisted.

What the occupation pays Median $112,092 (middle half $79,112–$138,980). This posting is about at that midpoint.

Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Aug 6, 2026. It is a model, not a headcount.

Why we read it this way (5)

The posting lists multiple US locations (Chicago, Las Vegas) and a Canadian HQ (Vancouver). The role is described as the only IT team member 'at this location' with on-site requirements, but the specific city is not named. Chicago is the most likely US site given the context, but Las Vegas is also possible.

Microsoft Fabric is listed under the ideal experience section with an explicit fallback ('or a strong background in related Microsoft data technologies such as Synapse, Azure SQL, SSAS with willingness to go deep on Fabric'), so Synapse, Azure SQL, and SSAS are captured as alternatives rather than separate required skills.

Python/PySpark and Git appear only under the 'Preferred' section and are marked accordingly.

The degree requirement states 'Bachelor's degree … or equivalent practical experience', so no hard degree gate is set.

The SOC classification is a close call: the role is primarily BI/analytics engineering (reporting, dashboards, semantic models — pointing to 15-2031) but also involves substantial data pipeline and lakehouse architecture work (pointing to 15-1243). 15-2031 was chosen as the primary because Power BI delivery and stakeholder-facing reporting are the stated first priorities; 15-1243 is the runner-up.

Read the full posting

The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.

Apply

Apply on employer site ↗