About the role

  • Data Engineer responsible for architecting, developing, and maintaining Allegiant’s enterprise data infrastructure. Overseeing transition to cloud hosted data warehouse and developing next-generation data tools.

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.

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

Job title

Data Engineer

Job type

Experience level

Mid levelSenior

Salary

$87,000 - $124,700 per year

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job