Cloud Data Engineer: AWS 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

Medical Travel Reimbursement

Employee Assistance Program

Legal, Identity and Pet Insurance

Job summary

Allegiant is seeking a Data Engineer to architect, develop, and maintain its enterprise data infrastructure as the company moves from on‑premise data marts to a cloud hosted warehouse. You will advance the next generation of data tools and support enterprise reporting by building scalable ETL processes and robust data models.

The role requires a minimum of 3 years in data engineering, strong SQL Server and Redshift skills, and familiarity with AWS services (S3, Glue, Lambda).

Qualifications

• 3+ years as a Data Engineer with data mart and data warehousing experience.
• Proficient with SQL Server, Amazon Redshift, and AWS services (S3, Glue, Lambda).
• Experience with ETL, OLAP structures, and dimensional modeling.

Responsibilities

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

Skills

SQL Server

Amazon Redshift

AWS

Python

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 its enterprise data infrastructure as the company moves from on‑premise data marts to a cloud hosted warehouse. You will advance the next generation of data tools and support enterprise reporting by building scalable ETL processes and robust data models.

The role requires a minimum of 3 years in data engineering, strong SQL Server and Redshift skills, and familiarity with AWS services (S3, Glue, Lambda).