Data Engineer at Allegiant | Minneapolis, Minnesota, United States | Rezi

Data Engineer at Allegiant

Data Engineer

Allegiant · Minneapolis, Minnesota, United States

3 weeks ago

Data Engineer

Allegiant · Minneapolis, Minnesota, United States

21 days ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now
Resume preview

Tailor your resume to this Data Engineer role.

Rezi rewrites your resume against Allegiant's job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Data Engineer posting at Allegiant — free, in seconds.

About the Role

The Data Engineer is responsible for architecting, developing, and maintaining Allegiant’s enterprise data infrastructure. This role will oversee the transition from on-premise data marts to a cloud-hosted data warehouse and develop the next generation of 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

  • 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.
  • 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.
  • 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.

Skills

  • 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).
  • Python development skills.

Location

  • 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.

Work Type

  • Full Time
  • Part Time
  • Hybrid

Experience Level

  • 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.

Education Level

  • Bachelor’s Degree In Computer Science, Engineering, or a related technical field.

Salary/Compensations

  • $87,000 - $124,700 a year

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
  • Sick time

About the Company

  • 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.

Equal Opportunity

  • 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