BI Platform Engineer: Fabric Lakehouse & Power BI Dashboards

Flyover Attractions, Inc.; Chicago (IL); Hybrid; USD 80,000 - 90,000; Full time

Benefits offered by this job

Extended Benefits

Job summary

Flyover Attractions, Inc. in Chicago is hiring a Business Intelligence Developer to own our data platform end to end, from POS ingestion through Microsoft Fabric to Power BI dashboards relied upon by Revenue and Finance.

The role involves stabilizing pipelines, building a clean gold layer, and delivering self-service BI while handling occasional Level 1 IT tasks on site. Hybrid schedule with on-site attendance as needed.

Qualifications

• Strong SQL skills: complex joins, window functions, CTEs, performance tuning
• Intermediate to advanced DAX: time intelligence, filter context, iterator functions
• Power BI semantic modeling (star schemas, relationships, import vs DirectQuery/Direct Lake trade-offs), report development, and service administration
• Able to translate stakeholder reporting needs into clear, actionable reporting
• Self-directed: comfortable owning a domain and setting priorities with minimal oversight while collaborating across a cross-functional IT team
• Comfortable handling occasional hands-on Level 1 IT tasks, such as desktop, printer, and peripheral troubleshooting, with a customer service mindset

Responsibilities

• Design, build, and maintain Azure Data Factory pipelines that ingest data from multiple POS systems into Microsoft Fabric, including incremental loads, error handling, and data quality checks
• Architect and manage the Fabric lakehouse/warehouse (bronze, silver, and gold layers) and handle platform administration: capacity and cost management, gateway configuration, workspace security, and monitoring and alerting for pipeline failures and data freshness
• Own the database estate end to end, including a small on-premises SQL Server footprint supporting in-house applications: backups and recovery, patching and upgrades, performance tuning, security and access, and other database needs as they arise
• Design star schemas and semantic models and write DAX measures for core business metrics such as attendance, admissions revenue, per capita spending, and operational KPIs
• Work directly with business teams to understand what they need, then design and build Power BI dashboards with them for complex or high-visibility use cases; administer the Power BI service: workspaces, refreshes, row-level security, and app distribution
• Partner with the Revenue Manager, Finance, and other stakeholders to translate reporting needs into well-structured, reusable data solutions, and support self-service BI and end-user enablement
• Serve as the data and analytics SME within the IT team: define data standards and documentation, share knowledge with peers, and evaluate new Fabric capabilities as the platform evolves
• As the only IT team member on site at this location, handle Level 1 tasks that need to be done in person (hardware setup and swaps, printer and peripheral issues, hands-on troubleshooting), up to about 4 hours per week; remote support is handled by the team in Vancouver
• Other duties as assigned

Skills

SQL

DAX

Power BI

Stakeholder communication

Self-directed

IT troubleshooting

Education

Bachelor’s degree in Computer Science, Information Systems, or a related field

Tools

Power BI

SQL Server

Azure SQL

Synapse

SSAS

Microsoft Fabric

Git

Job description

Flyover Attractions, Inc. in Chicago is hiring a Business Intelligence Developer to own our data platform end to end, from POS ingestion through Microsoft Fabric to Power BI dashboards relied upon by Revenue and Finance.

The role involves stabilizing pipelines, building a clean gold layer, and delivering self-service BI while handling occasional Level 1 IT tasks on site. Hybrid schedule with on-site attendance as needed.