Apply on Employer Site

Allegiant · 10 hours ago

Data Engineer

Las Vegas, NV

Full-time

Hybrid

Mid Level

$87K/yr - $125K/yr

3+ years exp

Allegiant is a national air carrier seeking a Data Engineer to architect, develop, and maintain their enterprise data infrastructure. The role involves overseeing the transition to a cloud-hosted data warehouse and developing data tools to enhance data accessibility and quality.

AerospaceLeisureTransportation

Growth Opportunities

No H1B

Responsibilities

Develop and maintain Allegiant data marts and data warehouses

Migrate Allegiant’s existing on-premise infrastructure to the AWS environment

Design, implement, and maintain scalable ETL processes to ensure efficient data flow and accessibility

Implement data quality checks to ensure accuracy and reliability of data

Troubleshoot and resolve issues related to data processing and ETL pipelines

Design, build, and implement data transformation, conversion, and validation of data required for BI applications

Maintain SQL Server and Redshift data marts, databases, and data warehouses

Provide services to replicate data from various data sources to reporting database servers for enterprise reporting applications

Work closely with the business to understand and translate user requirements into practical data models

Develop and maintain repeatable, systemic processes while finding ways to make internal team processes more efficient

Other duties as assigned

Qualification

SQL ServerAmazon RedshiftETL processesAWS servicesInfrastructure as CodePythonCritical thinkingProblem solvingDetail orientedTime management

Required

Combination of Education and Experience will be considered

Must be authorized to work in the US as defined by the Immigration Act of 1986

Must pass a Criminal Background Check

Bachelor's Degree In Computer Science, Engineering, or a related technical field

Minimum three (3) years of experience as a Data Engineer which includes work experience in data mart development and data warehousing, including experience working with ETL processes, OLAP structures, and dimensional modeling

Strong SQL Server and Amazon Redshift skills

In depth understanding of database architecture

Demonstrated basic proficiency in AWS services, including but not limited to S3, Glue, Lambda, and Redshift

Basic understanding of Infrastructure as Code (IAC) principles to define and manage infrastructure using code (e.g., AWS CloudFormation, Terraform)

Manage time effectively to meet deadlines across multiple projects

Excellent critical thinker and effective problem solver with creative solutions

Detail oriented and highly organized

Results-driven; accepting responsibility for individual performance and contributions to team projects

Ability to work a hybrid schedule with the expectation to be in the office 2 days a week or 8 days a month (when campus is open) and to work the remainder remotely

Must be able to work in a high pressure environment

Must have sufficient vision and ability to safely perform the essential functions of the position