Data Engineer

Flyover in Las Vegas

Chicago (IL)

Hybrid

USD 80,000 - 90,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Extended Benefits

Job summary

Flyover is hiring a Data Engineer to build and run our Azure data platform. You will stand up and migrate our Synapse, ADLS Gen2, and Data Factory pipelines in a new Azure environment, and partner with Finance, Revenue, and IT leaders.

The role requires 3+ years in data engineering with Azure pipeline experience, data modeling, and a focus on reliability and cost optimization. Remote-first, with on-site time in Chicago area as needed.

Qualifications

  • 3+ years in data engineering with 2+ years building production Azure Data Factory pipelines.
  • Hands-on Azure Synapse Analytics and Azure Data Lake Storage Gen2, plus Azure SQL Database.
  • Design layered lakehouse architectures (bronze/silver/gold) and data staging in Azure.
  • Migrate data from on-premises SQL Server to Azure and manage data quality.
  • Microsoft Fabric experience is a plus, including Power BI semantic model work and governance.

Responsibilities

  • Stand up the data platform in a new Azure environment and migrate existing pipelines and databases.
  • Build and maintain ADF pipelines ingesting data from on-prem and cloud sources with incremental loads and alerts.
  • Own lakehouse architecture and staging databases; define schemas, procedures, and performance tuning.
  • After migration, identify improvements for reliability and cost; evaluate Microsoft Fabric.
  • Build and maintain a shared Power BI semantic model with consistent metrics definitions.
  • Serve as data SME within IT; document data standards and keep code in VCS.
  • Occasionally handle Level 1 on-site tasks in Chicago area; remote support from Vancouver.

Skills

SQL / T-SQL
Window functions
Query performance
Data warehousing
Dimensional modeling
Communication
Self-directed

Education

Bachelor's degree in CS/IS or related field

Tools

Azure Data Factory
Azure Synapse
Azure Data Lake Storage
Azure SQL Database
Power BI
Git
Azure DevOps
Microsoft Fabric

Job description

About the role

The Data Engineer builds and runs the Azure data platform that turns ticketing, point-of-sale, and other business data into reporting our teams can trust. In the first phase, this role stands up our existing Azure Synapse, Azure Data Lake Storage, and Azure Data Factory platform in a new Azure environment; after that, it leads the work of improving it, including evaluating Microsoft Fabric. The role is the data subject matter expert on the IT team and partners closely with Finance, the Revenue team, and IT leaders. It is remote-first and based in the Chicago area, with on-site time as needed for hands-on Level 1 IT tasks (up to about four hours per week) and occasional meetings

Compensation :
  • $80,000-90,000USD/annually
  • Extended Benefits
What you’ll do
  • Stand up our data platform in a new Azure environment: rebuild and migrate the existing Azure Data Factory pipelines, Synapse workspace, Azure Data Lake Storage (ADLS Gen2), and staging Azure SQL databases from our current template, and validate that the migrated data matches the source
  • Design, build, and maintain ADF pipelines that ingest data from on-premises SQL Servers, cloud native ticketing systems, and other sources, including incremental loads, parameterization, triggers, error handling, and alerting on pipeline failures and data freshness
  • Own the lakehouse architecture (bronze, silver, and gold layers) and the contents of the staging Azure SQL databases: schemas, stored procedures, load and transformation logic, and query performance (backups, patching, and access are handled by the System Admin team)
  • After the migration, find and deliver improvements to the platform’s reliability, cost, and design, and help evaluate whether Microsoft Fabric is the right next step
  • Build and maintain a shared Power BI semantic model that Finance, Revenue, and IT leaders report from, with consistent definitions for metrics such as attendance, admissions revenue, and per capita spending; build key reports and help those teams build their own
  • Serve as the data SME within the IT team: define data standards, keep pipelines and data definitions documented well enough for someone else to pick up, and keep pipeline code in version control
  • 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
Qualifications
  • Strong SQL/T‑SQL: complex joins, window functions, CTEs, MERGE, and query performance tuning
  • Builds reliable pipelines: incremental (watermark) loads, parameterized and reusable pipeline design, retries, and alerts that reach a person when a load fails or quietly loads nothing
  • Understands dimensional modeling (star schemas, facts and dimensions, grain) well enough to design data that a shared Power BI semantic model can be built on
  • Able to explain data and trade‑offs in plain language to Finance, Revenue, and IT leaders, and to turn their questions into well‑structured data
  • Self‑directed: comfortable owning a domain and setting priorities with minimal oversight while collaborating with the System Admin team and the wider IT team
Education & Experience
EDUCATION:
  • Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent practical experience
IDEAL EXPERIENCE:

You won’t need every item on this list. If you meet most of it, we encourage you to apply.

  • 3+ years in data engineering, including at least 2 years building and running production Azure Data Factory pipelines

  • Hands‑on Azure Synapse Analytics and Azure Data Lake Storage (ADLS Gen2), plus Azure SQL Database

  • Designing layered (bronze, silver, gold) lakehouse or warehouse architectures, on any platform

  • Moving data from on‑premises SQL Server into Azure, including use of the self‑hosted integration runtime

  • Preferred: Microsoft Fabric (lakehouse, warehouse, or pipelines); building a shared Power BI semantic model with DAX measures; Power BI report development and service administration (workspaces, refreshes, row‑level security); Python/PySpark; Git and Azure DevOps; migrating a data platform between Azure environments; transactional data from ticketing or POS systems and attraction metrics (attendance, admissions revenue, per capita spending, booking pace); small‑team background wearing multiple hats

Welcoming All Applicants

At Flyover, we value a strong team built on respect and professionalism. We seek individuals who bring talent, enthusiasm, and a commitment to great guest experiences. Our hiring decisions are based on skills and qualifications, as well as alignment with our mission and values.

We evaluate qualified applicants without regard to race, color, age, religion, gender, sexual orientation, disability, veteran status, and other protected characteristics. To handle this job successfully, any person hired must be able to perform each task effectively. We welcome all applicants and are happy to provide accommodation upon request.

Thank you for your interest in this opportunity. To ensure a smooth process, we kindly request that candidates refrain from calling about the status of their application. Only those selected for an interview will be contacted. We appreciate your understanding.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Intelligence Developer
Business Intelligence Developer

Flyover in Las Vegas • Las Vegas (NV)

Hybrid
USD 80,000 - 90,000
Extended Benefits
Business Intelligence Developer
Business Intelligence Developer

Flyover Las Vegas • Las Vegas (NV)

Hybrid
USD 80,000 - 90,000
Extended Benefits
Business Intelligence Developer
Business Intelligence Developer

Flyover Attractions • Las Vegas (NV)

Hybrid
USD 80,000 - 90,000
Extended Benefits
Data Engineer III
Data Engineer III

Preferred Travel Group • Chicago (IL)

Hybrid
USD 120,000 - 150,000
Data Engineer (contract)
Data Engineer (contract)

Capgemini • Atlanta (GA)

On-site
USD 61,812 - 96,528
Medical benefits
Dental benefits
Vision benefits
+1
IT - Analyst - IT Resources | Big Data - Data Processing | Spark
IT - Analyst - IT Resources | Big Data - Data Processing | Spark

Ampcus, Inc • Fort Worth (TX)

On-site
USD 110,000 - 160,000
Data Engineer
Data Engineer

Better Debt Solutions • Irvine (CA)

On-site
USD 140,000 - 155,000
Medical, dental, and vision insurance
Paid vacation and company holidays
Lunch every Friday
+3
Data Architect
Data Architect

Further • Dallas (TX)

Hybrid
USD 130,000 - 170,000
Net-zero cost medical option
Company contributions to HSA
Fully-paid parental leave
+1
Sr. Data Engineer
Sr. Data Engineer

United Utility • Spring (TX)

On-site
USD 130,000 - 150,000
Medical, dental, and vision insurance
Health Savings Account (HSA) and FSA
401(k) with company match
+3
Data Engineer, Operations Analytics
Data Engineer, Operations Analytics

Rowan Digital Infrastructure • Denver (CO)

Hybrid
USD 108,000 - 125,000
Hybrid working environment
Team building and educational opportun
Generous benefits package including 健康
+4