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.

Requirements

Bachelor’s Degree In Computer Science, Engineering, or a related technical field.
Minimum three (3) years of experience as a Data Engineer including 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).

Benefits

Profit Sharing
Medical/Dental/Vision/Life/ Disability Insurance
Medical Travel Reimbursement
Legal, Identity and Pet Insurance
401K with an employer match
Employee Stock Purchase Plan
Employee Assistance Program
Tuition Reimbursement
Flight Benefits
Paid vacation, holidays, and sick time

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

ETL processesdata warehousingdata mart developmentSQL ServerAmazon Redshiftdata transformationdata validationdata quality checksdimensional modelingInfrastructure as Code

Soft skills

problem-solvingcommunicationcollaborationorganizational skillsanalytical thinking

Certifications

Bachelor’s Degree in Computer ScienceBachelor’s Degree in Engineering