Data Engineer - AWS

Sky Chefs, LLC
Irving, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 144K

Job location

Irving, United States of America

Tech stack

Amazon Web Services (AWS)
Information Systems
Databases
Data Cleansing
Data Control
Data Governance
Data Integration
ETL
Data Security
Data Structures
Data Warehousing
Database Design
Python
Query Optimization
SAP Applications
SQL Stored Procedures
Data Processing
Data Ingestion
Sql Optimization
Snowflake
Indexer
Microsoft Fabric
Infrastructure Automation Frameworks
Information Technology
Data Lineage
Terraform
Software Version Control
Data Pipelines
Api Management
Databricks

Job description

The AWS Senior Data Engineer will own the planning, design, and implementation of data structures for Sky Chefs North America in our AWS environment. This role will be responsible for incorporating all internal and external data sources into a robust, scalable, and comprehensive data model within AWS to support business intelligence and analytics needs throughout the company., * Collaborate with cross-functional teams to understand and define business intelligence needs and translate them into data modeling solutions

  • Develops, builds and maintains scalable data pipelines, data schema design, and dimensional data modelling in Databricks and AWS for all system data sources, API integrations, and bespoke data ingestion files from external sources. Includes Batch and real-time pipelines.
  • Responsible for data cleansing, standardization, and quality control
  • Create data models that will support comprehensive data insights, business intelligence tools, and other data science initiatives
  • Create data models and ETL procedures with traceability, data lineage and source control
  • Design and implement data integration and data quality framework
  • Implement data monitoring best practices with trigger based alerts for data processing KPIs and anomalies
  • Investigate and remediate data problems, performing and documenting thorough and complete root cause analyses. Make recommendation for mitigation and prevention of future issues.
  • Work with Business and IT to assess efficacy of all legacy data sources, making recommendations for migration, anonymization, archival and/or destruction.
  • Continually seek to optimize performance through database indexing, query optimization, stored procedures, etc.
  • Ensure compliance with data governance and data security requirements, including data life cycle management, purge and traceability.
  • Create and manage documentation and change control mechanisms for all technical design, implementations and systems maintenance.

Requirements

  • Bachelor's or graduate degree in computer science, information systems or related field preferred, or similar combination of education and experience
  • At least 4 years' experience designing and managing data pipelines, schema modeling, and data processing systems.
  • Experience with Databricks a plus (or similar tools like Microsoft Fabric, Snowflake, etc.) to drive scalable data solutions.
  • Experience with SAP a plus
  • Proficient in Python, with a track record of solving real-world data challenges.
  • Advanced SQL skills, including experience with database design, query optimization, and stored procedures.
  • Experience with Terraform or other infrastructure-as-code tools is a plus.
  • Must be willing and able to work in a hybrid office environment, with 4 days per week in office in the North America headquarters in the Dallas, Texas area

Benefits & conditions

3.53.5 out of 5 stars 5040 Riverside Dr # 1, Irving, TX 75039 Hybrid work $110,939.88 - $143,942.54 a year - Full-time

About the company

Since 1942, SkyChefs has taken culinary excellence to new heights. As a trusted partner to the nation's leading airlines and retailers, we proudly deliver millions of meals and exceptional service experiences every year across 43 sites throughout the United States. Built on a legacy of operational excellence, culinary expertise, and continuous innovation, we are committed to setting the industry standard in aviation culinary, airline services, last-mile logistics, and retail commerce. From the kitchen to the runway, our teams work together to deliver quality, reliability, and service at every altitude. Our people are the heart of everything we do. At SkyChefs, a career is more than a job - it's an opportunity to grow, lead, and make an impact in a fast-paced, team-driven environment. Join America's first, foremost, and finest and take your career to new heights.

Apply for this position