Senior Data Engineer

Company Description ATPCO is the bedrock of flight shopping, delivering pricing and retailing data, tools, and services to over 500 airlines, global distribution systems, sales channels, and technology companies. ATPCO connects the entire airline community, collaborating to create industry standards for airline distribution and comprehensive technology solutions. From shopping to settlement, ATPCO solutions operate smoothly across current, new, and evolving technologies and methods. Owned by airlines and consistently supporting air travel for over 55 years, ATPCO is present wherever flights are sold. Employees are qualified for our benefits package including an employer-matched 401(k), group health insurance and wellness programs, paid time off, tuition reimbursement; standby flight program, and employee collaborative work and life standards. We consider applicants for employment without regard to race, gender, age, color, religion, national origin, citizenship status, marital status, disability, sexual orientation, protected military/veteran status, gender identity or expression, genetic information, marital status, medical condition, or any other legally protected factor. Job Description As a Principal Data Engineer, you will be responsible for constructing and optimizing data pipelines, managing data storage and processing systems, and guaranteeing the availability, scalability, and reliability of our data platform. You will partner with cross-functional teams, including data scientists, software engineers, and business stakeholders to understand data requirements and provide efficient high-quality data solutions. We are seeking a talented individual to join our respected team of ATPCO data engineers, dedicated to addressing complex data processing challenges within the Airline industry. This role offers an opportunity to work on advanced solutions that involve handling hundreds of terabytes of data daily, leveraging the latest AWS services. You Will: Work with data scientists, analysts, and other stakeholders to understand data requirements and design data models and schemas that facilitate data analysis and reporting Design, develop, and maintain scalable and efficient data pipelines and ETL processes to ingest, process, and transform large volumes of data from various sources into usable formats Build and optimize data storage and processing systems, including data warehouses, data lakes, and big data platforms, using AWS services such as Amazon Redshift, AWS Glue, AWS EMR, AWS S3, and AWS Lambda, to enable efficient data retrieval and analysis Implement and manage real-time data streaming architectures using AWS services like Amazon Kinesis or Apache Kafka to enable real-time data processing and analytics Perform data profiling, data cleansing, and data transformation tasks to prepare data for analysis and reporting Implement data security and privacy measures to protect sensitive and confidential data using AWS security services and features Design and implement data architectures following Data Mesh principles within the AWS environment, including domain-oriented data ownership, self-serve data infrastructure, and federated data governance Provide technical guidance and mentorship to junior data engineers, reviewing their work and ensuring adherence to best practices and standards Qualifications: Strong programming skills in languages like Python, Java, or Scala, with experience in data manipulation and transformation frameworks Proven experience as a data engineer, with experience in designing and building large-scale data processing systems Strong understanding of data modeling concepts and data management principles In-depth knowledge of SQL and experience working with relational and non-relational databases Knowledge of Data Mesh principles and experience designing and implementing data architectures following Data Mesh concepts within the AWS ecosystem Experience with real-time data streaming architectures using AWS services like Amazon Kinesis or Apache Kafka Familiarity with AWS cloud services, such as AWS Glue, AWS Lambda, AWS EMR, AWS S3, Amazon Redshift, and their data-related features and functionalities Familiarity with AWS security services and features for data security and privacy Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.