Data Engineer
Posted Updated
Summary
The Data Engineer is responsible for architecting, developing, and maintaining Allegiant’s enterprise data infrastructure. The Data Engineer will oversee our transition from on-premise data marts to a cloud hosted warehouse data and develop the next generation of our data tools.
Visa Sponsorship Available: No
Minimum Requirements
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.
Education: Bachelor’s Degree In Computer Science, Engineering, or a related technical field.
Years of Experience:
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.
Preferred Requirements
•Python development skills.
Job Duties
•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.
Physical Requirements
The Physical Demands and Work Environment described here are a representative of those that must be met by a Team Member to successfully perform the essential functions of the role. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the role.
Office/IT - While performing the duties of this job, the Team Member is regularly required to stand, sit, talk, hear, see, reach, stoop, kneel, and use hands and fingers to operate a computer, key board, printer, and phone. May be required to lift, push, pull, or carry up to 50 lbs. May be required to work various shifts/days in a 24 hour situation. Regular attendance is a requirement of the role. Exposure to moderate noise (i.e. business office with computers, phones, printers, and foot traffic), temperature and light fluctuations. Ability to work in a confined area as well as the ability to sit at a computer terminal for an extended period of time. Some travel may be a requirement of the role.
Essential Services Provider
Allegiant as a national air carrier is deemed an essential service provider during declared national and state emergencies. Team Members will be required to report to their assigned trip or work location during national and state emergencies unless prohibited by local, state or federal order.
EEO Statement
We welcome all individuals from varied backgrounds and experiences to apply. Our company celebrates diversity, and we value the unique perspectives and talents that each person brings to our team.
Equal Opportunity Employer: Disability/Veteran
For more information, see
Full Time 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
Part Time Benefits:
Profit Sharing
Medical Travel Reimbursement
Legal, Identity and Pet Insurance
401K with an employer match
Employee Stock Purchase Plan
Employee Assistance Program
Tuition Reimbursement
Flight Benefits
Sick time
Skills
As published by lever · 17 questions · 5 written answers
Basics
Which location are you applying for?, Resume/CV, Full name, Pronouns, Email, Phone, Current location, Current company, LinkedIn URL, Twitter URL, GitHub URL, Portfolio URL, Other website
Short answers (2)
- What is your Legal First Name?
- What is your Legal Last Name?
Pick from a list (10)
- Are you at least 18 years of age?
- Are you legally authorized to work in the United States?
- Will you now or in the future require employment-based visa sponsorship to work in the US? If, when your current work authorization expires, you may require employment-based visa sponsorship to continue working with Allegiant, please select ‘Yes.’ Examples of statuses that may require current or future sponsorship include, but are not limited to: H-1B, H-1B1, E-2, E-3, L-1, TN, O-1, F-1 (CPT, OPT, and STEM OPT), and J-1. Allegiant is unable to provide employment sponsorship now or in the future.
- What is the highest level of education completed? Do not include degrees that are in progress or with a future graduation date. optional
- Do you have a non-compete agreement or other legal written restrictions that would restrict you from performing work required in this role? If Yes - please provide a copy of the non-compete agreement or other legal written restrictions to your recruiter.
- Have you ever been employed by an Allegiant company, Sun Country, or through a Third Party Contractor Agency onsite?
- You should know that Allegiant does not employ a Substance Abuse Professional (SAP) as part of its DOT/FAA substance abuse testing program and therefore cannot accommodate any SAP-imposed return to duty requirements. If you have any such requirements in place from current or prior employment, you will not be eligible for employment at Allegiant in a safety sensitive role. optional
- Collaboration starts with honest, upfront conversations. The salary range for this role is $87,000 - $124,700, with offers based on experience, skills, and abilities. Does that fit within your expectations?
- This role is based at our Las Vegas, NV headquarters and includes regular in-person collaboration. Are you comfortable working on-site as needed?
- This position requires working at our Las Vegas, NV headquarters. Please select the option that best describes your current situation:
Written answers (5)
- Please include your completed degree program and school name for verification purposes. (Example: B.S. in Business Administration, UNLV). If you selected “High School Diploma or GED,” enter your high school name.
- In the last 10 years, have you ever been involuntarily terminated or asked to resign your employment? If Yes - please explain below | If No - please answer N/A.
- Do you have recall rights to any airline role? If Yes - which airline? | If No - please answer N/A.
- Are you related to anyone who is currently working for Allegiant? If Yes - please list the name of the person(s) and their relationship to you. | If No - please answer N/A.
- This position requires a minimum three (3) years of experience as a Data Engineer. How many years experience do you have?