E-Commerce ETL Test Engineer/App Training Specialist

Tyto Athene is searching for afor a versatile and detail-oriented professional to fill a unique hybrid role as an E-Commerce ETL Test Engineer and Application Training Specialist. In this position, you will be responsible for two critical functions: first, ensuring the accuracy and integrity of our e-commerce data pipelines through rigorous testing of ETL processes built with AWS Glue. Second, you will act as a subject matter expert, developing and delivering training programs to empower our business users to effectively utilize our data-driven applications. The ideal candidate is a strong communicator who is equally comfortable writing complex SQL queries and leading a training session.

Responsibilities:

ETL Testing & Quality Assurance

• Develop, document, and execute comprehensive test plans and test cases to validate ETL processes and data transformations.
• Perform rigorous testing of ETL jobs developed in AWS Glue, ensuring data is accurately extracted, transformed, and loaded.
• Write and execute complex SQL queries to compare source and target data, identify discrepancies, and verify business logic.
• Identify, document, and track defects to resolution, working closely with the data engineering team.
• Conduct end-to-end testing of data flows from the e-commerce platform into our data warehouse and data marts.
• Champion data quality best practices throughout the development lifecycle.

Application Training & Support

• Design and create a variety of training materials, including user manuals, quick-start guides, presentations, and video tutorials for our e-commerce applications.
• Deliver engaging and effective training sessions to both technical and non-technical audiences, in-person and virtually.
• Translate complex data concepts and application features into clear, concise, and easy-to-understand information for business users.
• Act as the primary point of contact for application-related questions and provide ongoing support to end-users.
• Gather feedback from users to help improve application usability and future training programs.

Qualifications

Required:

• Experience: 3-5+ years of experience in a data-focused role, such as ETL testing, data quality assurance, or business intelligence.
• ETL Testing: Proven experience in testing data warehouses and ETL pipelines.
• AWS Glue: Hands-on experience testing and validating ETL jobs and workflows within AWS Glue.
• SQL Proficiency: Expert-level SQL skills for writing complex queries, joins, and data validation scripts.
• Experience with Smoke testing, regression testing, load testing, interface testing, black box testing
• Training Experience: Demonstrable experience in developing training materials and/or delivering technical training to end-users.
• Communication: Exceptional verbal and written communication skills, with the ability to present complex technical information clearly and concisely.
• E-Commerce Domain: Understanding of common e-commerce data concepts (e.g., sales, customers, products, inventory).
• Must be a US Citizen and able to obtain public trust/T3 clearance.

Desired:

• Familiarity with business intelligence and reporting tools such as Tableau, Power BI, or Looker.
• Experience with other AWS data services like Amazon S3, Redshift, or Athena.
• Knowledge of test automation frameworks for data validation.
• Background in instructional design or corporate training.
• Experience working in an Agile/Waterfall development
• Education requirement or 8140 Certification .

Clearance:

• Public Trust/T3 preferred or able to obtain a DoD clearance.

Location:

• Aurora, CO (On-site)

About Tyto Athene

Compensation:

• Compensation is unique to each candidate and relative to the skills and experience they bring to the position. The salary range for this position is typically between $120,000-$140,000. This does not guarantee a specific salary as compensation is based upon multiple factors such as education, experience, certifications, and other requirements, and may fall outside of the above-stated range.

Benefits:

• Highlights of our benefits include Health/Dental/Vision, 401(k) match, Paid Time Off, STD/LTD/Life Insurance, Referral Bonuses, professional development reimbursement, and parental leave.

Tyto Athene is a trusted leader in IT services and solutions, delivering mission-focused digital transformation that drives measurable success. Our expertise spans four core technology domains-Network Modernization, Hybrid Cloud, Cybersecurity, and Enterprise IT-empowering our clients with cutting-edge solutions tailored to their evolving needs. With over 50 years of experience, Tyto Athene proudly support Defense, Intelligence, Space, National Security, Civilian, Health, and Public Safety clients across the United States and worldwide.

At Tyto Athene, we believe that success starts with our people. We foster a collaborative, innovative, and mission-driven environment where every team member plays a critical role in shaping the future of technology. Are you ready to join #TeamTyto?

Tyto Athene, LLC is an Equal Opportunity Employer; all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, [sexual orientation, gender identity,] national origin, disability, status as a protected veteran, or any characteristic protected by applicable law.