Data Engineer/Sr Data Engineer, IT Analytics

Location: DFW Headquarters Building 8 (DFW-SV08)
Cities:
Requisition ID: 78934

Job Description

Intro

Are you ready to explore a world of possibilities, both at work and duringyour time off? Join our American Airlines family, and you'll travel the world, grow your expertise and become the best version of you. As you embark on a new journey, you'll tackle challenges with flexibility and grace, learning new skills and advancing your career while having the time of your life. Feel free to enrich both your personal and work life and hop on board!

Why you'll love this job

• As one diverse, high-performing team dedicated to technical excellence, you will focus relentlessly on delivering unrivaled digital products that drive a more reliable and profitable airline.
• The Data Domain refers to the area within Information Technology that focuses on managing and leveraging data as a strategic asset. This includes data management, storage, integration and governance. The Data domain leans into Machine Learning and AI, as well as Data Science and Business Intelligence.

What you'll do

As noted above, this list is intended to reflect the current job but there may be additional essential functions (and certainly non-essential job functions) that are not referenced. Management will modify the job or require other tasks be performed whenever it is deemed appropriate to do so, observing, of course, any legal obligations including any collective bargaining obligations.

• Work closely with source data application teams and product owners to design, implement and support analytics solutions that provide insights to make better decisions
• Implement data migration and data engineering solutions using Azure products and services: (Azure Data Lake Storage, Azure Data Factory, Azure Functions, Event Hub, Azure Stream Analytics, Azure Databricks, etc.) and traditional data warehouse tools.
• Perform multiple aspects involved in the development lifecycle - design, cloud engineering (Infrastructure, network, security, and administration), ingestion, preparation, data modeling, testing, CICD pipelines, performance tuning, deployments, consumption, BI, alerting, prod support.
• Provide technical leadership and collaborate within a team environment as well as work independently.
• Be a part of a DevOps team that completely owns and supports their product
• Implement batch and streaming data pipelines using cloud technologies
• Leads development of coding standards, best practices and privacy and security guidelines.
• Mentors others on technical and domain skills to create multi-functional teams

All you'll need for success

Minimum Qualifications- Education & Prior Job Experience

• Bachelor's degree in Computer Science, Computer Engineering, Technology, Information Systems (CIS/MIS), Engineering, or related technical discipline, or equivalent experience/training
• 5+ years of Teradata Vantage development and administration
• 5+ years of experience in Teradata performance optimization techniques and Structured Query Language (SQL) tuning.
• 5+ years of experience in implementing and managing database tools, including Teradata Viewpoint, Data Mover, Datalabs, Studio, TASM, Query Grid, Teradata Load Utilities, DSA, MVC, TPT, and BTEQ scripts
• 5+ years of experience in optimizing and designing data models for the Teradata platform or MPP platforms.
• Performance Data Collection Reporting (PDCR) and Database Query Logging (DBQL).

Preferred Qualifications- Education & Prior Job Experience

• 3+ years of cloud development and data lake experience (prefer Microsoft Azure), including Azure EventHub, Azure Data Factory, Azure Databricks, Azure DevOps, Azure Blob Storage, Azure Data Lake, Azure Power Apps, and Power BI
• 5+ years of software solution development using agile, DevOps, product model that includes designing, developing, and implementing large-scale applications or data engineering solutions.
• 5+ years of data analytics experience using SQL.
• Airline Industry Experience

Skills, Licenses & Certifications

• Strong knowledge of Teradata database sizing, capacity planning, and performance tuning using DBQL, Stats Manager, PDCR, and TASM.
• Experience in designing physical database layouts, including indexing, partitioning, and compression.
• Familiarity with NOS, BCM, and data migration from heterogeneous sources to Teradata data warehouses.
• Expertise in Teradata Application database management, Query Grid, and backup/recovery solutions using DSA and Data Mover with IR.
• Expertise in Workload management with TASM, change management via Cherwell, and code versioning with GitHub.
• Familiarity with the Azure Technology stack for data management, data ingestion, capture, processing, curation, and creating consumption layers
• Teradata Vantage Certification (preferred)
• Agile exposure with Scrum using tools including Rally and ADO.
• Combination of Development, Administration & Support experience in several of the following tools/platforms required:
• Scripting: Python, Bteq, Unix Shell Script, SQL
  • Data Platforms: Teradata, Cassandra, MongoDB, Oracle, SQL Server, ADLS, Snowflake, ADX
  • Data Governance and Privacy: Alation, Monte Carlo, Informatica, and BigID

What you'll get

Feel free to take advantage of all that American Airlines has to offer:

• Travel Perks: Ready to explore the world? You, your family and your friends can reach 365 destinations on more than 6,800 daily flights across our global network.
• Health Benefits: On day one, you'll have access to your health, dental, prescription and vision benefits to help you stay well. And that's just the start, we also offer virtual doctor visits, flexible spending accounts and more.
• Wellness Programs: We want you to be the best version of yourself - that's why our wellness programs provide you with all the right tools, resources and support you need.
• 401(k) Program: Available upon hire and, depending on the workgroup, employer contributions to your 401(k) program are available after one year.
• Additional Benefits: Other great benefits include our Employee Assistance Program, pet insurance and discounts on hotels, cars, cruises and more

Feel free to be yourself at American

From the team members we hire to the customers we serve, inclusion and diversity are the foundation of the dynamic workforce at American Airlines. Our 20+ Employee Business Resource Groups are focused on connecting our team members to our customers, suppliers, communities and shareholders, helping team members reach their full potential and creating an inclusive work environment to meet and exceed the needs of our diverse world.

Are you ready to feel a tremendous sense of pride and satisfaction as you do your part to keep the largest airline in the world running smoothly as we care for people on life's journey? Feel free to be yourself at American.

Cities:
Requisition ID: 78934