Hybrid Data Engineer: Cloud Data Warehouse & ETL

Allegiant; Minneapolis (MN); Hybrid; USD 87,000 - 125,000; Full time

Benefits offered by this job

Profit Sharing

Medical/Dental/Vision/Life/ Disability

401K with an employer match

Employee Stock Purchase Plan

Flight Benefits

Paid vacation, holidays, and sick time

Tuition Reimbursement

Job summary

Allegiant is seeking a Data Engineer to architect, develop, and maintain Allegiant’s enterprise data infrastructure as we move from on-premise data marts to a cloud-hosted data warehouse.

The role focuses on designing scalable ETL processes, ensuring data quality, and partnering with business teams to translate requirements into robust data models, all while operating in a hybrid Minneapolis schedule.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related technical field.
• Minimum three years of experience as a Data Engineer with data marts, data warehousing, ETL, OLAP, and dimensional modeling.
• Strong SQL Server and Amazon Redshift skills; experience with AWS services (S3, Glue, Lambda, Redshift).

Responsibilities

• Develop and maintain Allegiant data marts and data warehouses.
• Migrate on-premise infrastructure to AWS environment.
• Design, implement, and maintain scalable ETL processes for data flow and accessibility.
• Implement data quality checks for data accuracy and reliability.
• Troubleshoot and resolve data processing and ETL pipeline issues.
• Design, build, and validate data for BI applications.
• Maintain SQL Server and Redshift data marts and warehouses.
• Replicate data from various sources to reporting databases.
• Collaborate with business teams to translate requirements into data models.
• Develop repeatable processes to improve team efficiency.
• Other duties as assigned.

Skills

SQL Server

Amazon Redshift

AWS services

Infrastructure as Code

Python development

Education

Bachelor's degree in Computer Science, Engineering, or related field

Tools

CloudFormation

Terraform

Job description

Allegiant is seeking a Data Engineer to architect, develop, and maintain Allegiant’s enterprise data infrastructure as we move from on-premise data marts to a cloud-hosted data warehouse.

The role focuses on designing scalable ETL processes, ensuring data quality, and partnering with business teams to translate requirements into robust data models, all while operating in a hybrid Minneapolis schedule.