AWS Data Engineer

Location - Irving, TX

Fulltime

Excellent Compensation + Full Benefits

Amazing Work Culture & Team

Excellent Growth Opportunities

PLEASE READ BEFORE APPLYING :

THIS ROLE DOES NOT OFFER SPONSORSHIP & OPT CANDIDATES CANNOT BE CONSIDERED FOR THIS ROLE.

Role Purpose Statement :

The AWS Data Engineer will own the planning, design, and implementation of data structures for LSG 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.

Main Accountabilities

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 AWS for all system data sources, API integrations, and bespoke data ingestion files from external sources

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.

Knowledge, Skills and Experience

CANDIDATES WITH AWS EXPERIENCE ARE CONSIDERED IDEAL CANDIDATES

Bachelor's or graduate degree in computer science, information systems or related field preferred, or similar combination of education and experience

Minimum 5 years’ experience with schema design, data modelling, data warehousing, data processing systems, ETL

Minimum 5 years’ experience with Python and.or Java development

Minimum 5 years’ experience with SQL, T-SQL, PL/SQL, SQL Server, SSMS, SSIS, SSAS

Minimum 2 years’ experience in AWS environment required

Expertise in building stored procedures, functions, and triggers

Experience with SDLC, agile and scrum methodologies 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

Competencies

Strong communication skills to effectively liaise with both technical and non-technical stakeholders

Ability to translate business needs to data modeling design frameworks

Exceptional problem-solving skills

Exemplary attention to detail

LSG Sky Chefs is an EEO and Affirmative Action Employer of Women/Minorities/Veterans/Individuals with Disabilities.