ETL Data Warehousing Specialist

Tyto Athene is seeking a dedicated ETL Data Warehousing Specialist to join our team supporting the Defense Health Agency (DHA) E-commerce Operations Service Support (EOSS) contract. The successful candidate will be responsible for designing, developing, and maintaining the data warehouse and all related ETL processes. This role is pivotal in transforming raw data into actionable insights for the DHA. You will leverage your expertise in AWS services, particularly AWS Glue, to build a scalable and efficient data warehousing solution that supports the EOSS mission.

Responsibilities:

• Design, implement, and maintain robust ETL pipelines using AWS Glue to extract data from various sources, transform it according to business rules, and load it into the data warehouse.
• Develop and manage the enterprise data warehouse using Amazon Redshift, ensuring data is organized efficiently for analysis and reporting.
• Create and maintain data models, including schemas, tables, and data marts, to support business intelligence and analytics needs.
• Write and optimize complex SQL queries for data manipulation, aggregation, and retrieval.
• Implement data quality checks and validation processes within the ETL framework to ensure the accuracy and integrity of the data warehouse.
• Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications for ETL jobs and data warehouse structures.
• Monitor ETL job performance, troubleshoot failures, implement optimizations to ensure timely data delivery, and perform unit testing in addition to other duties.
• Develop and maintain comprehensive documentation for all ETL processes, data models, and data warehouse architecture.

Qualifications

Required:

• 5+ years of experience in a data warehousing environment with a strong focus on ETL development.
• Extensive hands-on experience designing and building ETL pipelines using AWS Glue.
• Proven experience with data warehouse technologies, specifically Amazon Redshift.
• Strong proficiency in SQL for complex queries, performance tuning, and data analysis.
• Proficiency in a scripting language, preferably Python, for ETL development and automation.
• Solid understanding of data warehousing concepts, including dimensional modeling, star schemas, and data marts.
• Experience with data quality and data governance best practices.
• Must be a US Citizen and able to work on-site.
• Able to obtain a Public Trust/T3
• Education: Bachelor of Science in Information Technology, Cybersecurity, Computer Science, Information Systems, Data Science, or Software Engineering

Desired:

• AWS Certified Data Analytics - Specialty or AWS Certified Database - Specialty certification.
• Experience with other AWS data services such as S3, Lambda, and Athena.
• Experience with workflow conversion from one ETL tool to another tool
• Knowledge of Infrastructure as Code (IaC) using tools like AWS CloudFormation or Terraform.
• Familiarity with big data technologies (e.g., Spark, Hadoop) and their integration with data warehousing solutions.
• Experience working in a government or defense contracting environment

Clearance:

• Public Trust/T3 preferred or the ability 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 $135,000-$150,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.