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).
Staff Data Engineer at PPRO transforming data ecosystem into a self - service platform. Leading technical vision for data engineering and building scalable infrastructures.
SSIS Data Engineer at iKnowHow Group focusing on data migration projects. Involves data modeling, integration, and using T - SQL/SQL alongside SSIS packages.
Principal Data Engineer designing and implementing data solutions that ensure trust and transparency in supply chains. Collaborating with global teams and mentoring fellow engineers in data practices.
Senior Data Engineer role at Dun & Bradstreet focused on data analytics and visualization. Collaborating with teams to optimize data processes and deliver actionable insights.
Senior Data Engineer with AWS expertise leading financial data architecture and scalable solutions. Collaborating in wealth management to enhance data quality and systems.
Data Migration Specialist handling large - scale data migration from legacy to enterprise PLM platform. Analyzing data structures, developing strategies, and ensuring integrity across systems.
Director leading strategy, governance, and delivery of enterprise data platform at Phillips 66. Partnering with AI, Data Science, and business teams to enhance analytics and business systems.
Product Owner driving ERP data migration initiatives for BioNTech’s global landscape. Leading effective data management and ensuring compliance with regulatory standards in a fast - paced environment.
Data Engineer II leading development and delivery of data pipelines for Syneos Health. Collaborating with teams to optimize data processing and integrate solutions into production environments.