Allegiantair Data Engineer at Allegiantair is responsible for architecting and maintaining enterprise data infrastructure and migrating on-premise data marts to cloud. The role includes developing scalable ETL processes and ensuring data quality.
Responsibilities
Develop and maintain Allegiant data marts and data warehouses
Migrate existing on-premise infrastructure to AWS environment
Design, implement, and maintain scalable ETL processes
Implement data quality checks
Troubleshoot and resolve data processing and ETL pipeline issues
Design, build, and implement data transformation and validation for BI applications
Maintain SQL Server and Redshift data marts and databases
Replicate data from various sources for enterprise reporting
Translate user requirements into practical data models
Develop and maintain repeatable, systemic processes
Qualification
Bachelor’s Degree in Computer SciencePython development skillsDesign
Required
Bachelor’s Degree in Computer Science, Engineering, or related technical field
Minimum 3 years experience as a Data Engineer
Experience in data mart development and data warehousing
Strong SQL Server and Amazon Redshift skills
Basic proficiency in AWS services including S3, Glue, Lambda, and Redshift
Basic understanding of Infrastructure as Code (IAC) principles
Preferred
•Python development skills.
•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.