Senior Teradata Engineer

Every year, nearly 200 million travelers trust our client to get them where they're going. Take your career to new heights by working for this longstanding leader in air travel that services more worldwide destinations than any other airline.

We are looking for a Senior Data Engineer to join our team for a 12 month contract in Atlanta, GA (hybrid).

Contract Duration: 12 Months

Required Skills & Experience

• Database Management, ETL Development, have used tools like Teradata Utilities (e.g., BTEQ, FastLoad, MultiLoad, TPT, etc.), Data Modeling, DB Performance Tuning, Data Security & Governance, Cloud Integration and Management, Cloud Infrastructure, Automation and DevOps, Data Warehousing and Analytics, Security and Compliance
• In-depth knowledge of Teradata architecture and components (e.g., AMP, Nodes, Parsing Engines, etc.).
• Proficiency in Teradata SQL and Teradata utilities.
• Strong SQL skills for querying and managing relational databases.
• Scripting experience (e.g., Shell, Python) for automating tasks.
• Knowledge of query optimization techniques, indexing, partitioning, and workload management in Teradata.
• Proficiency with core AWS services: EC2, S3, RDS, Lambda, CloudWatch, CloudFormation, etc.
• Familiarity with AWS storage options, such as S3, EFS, and Glacier, in the context of large-scale data storage and retrieval.
• Knowledge of AWS services that enhance Teradata performance, such as using S3 for staging data or integrating with Redshift for analytics.
• Hands-on experience with AWS CloudFormation, Terraform, or similar tools for automating infrastructure deployment.
• Proficiency in automating ETL pipelines and data processing workflows using AWS Lambda, Step Functions, or AWS Glue.

Desired Skills & Experience

• Bachelor of Science degree in Computer Science or equivalent
• Vantage Master 2.0 certifications / Vantage Data Science Master certifications
• At least 7 years of post-degree professional experience
• At least 5+ years of Airline industry experience
• 4+ years development experience building and maintaining ETL pipelines
• 3+ years of experience working with database technologies and data development such as Python, PLSQL, etc.
• Experience in mentoring junior team members through code reviews and recommend adherence to best practices
• Deep understanding of writing test cases to ensure data quality, reliability and high level of confidence
• Track record of advancing new technologies to improve data quality and reliability
• Continuously improve quality, efficiency, and scalability of data pipelines
• Expert skills working with queries/applications, including performance tuning, utilizing indexes, and materialized views to improve query performance
• Identify necessary business rules for extracting data along with functional or technical risks related to data sources (e.g. data latency, frequency, etc.)
• Develop initial queries for profiling data, validating analysis, testing assumptions, driving data quality assessment specifications, and define a path to deployment
• Familiar with best practices for data ingestion and data design

What You Will Be Doing

• Play a leading role on the Enterprise Data Services team, responsible for transforming data from disparate systems to provide insights and analytics for business stakeholders.
• Leverage cloud-based infrastructure to implement technology solutions that are scalable, resilient, and efficient.
• Collaborate with Data Engineers, Data Analysts, DBAs, cross-functional teams, and business leaders.
• Architect, design, implement and operate data engineering solutions, using Agile methodology, that empower users to make informed business decisions.
• Deep understanding of the full life data lifecycle and the role that high-quality data plays across applications, machine learning, business analytics, and reporting.
• Serve as a liaison with business users and walk with them through their problems to identify the best path forward.
• Provide technical counsel to other Data Engineers on the team and may be requested to review and guide their work to ensure all the work comes together successfully to meet the business need.

You will receive the following benefits:

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer, including Veterans/Disability/Women. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.