Data Engineer - Database Focus

Overview

Join our dynamic ITility team and put your skills and passion to work! We are seeking a talented Data Engineer to join our Data aNd Analytics (DNA) team, who will be responsible for design, developing, and maintaining the data infrastructure supporting a business intelligence, data exchange, and scalable data infrastructure on an AWS ecosystem.  This candidate will support a new development activity for a client Chief Data Officer initiative to build a semantic data layer and enterprise data warehouse, brokering internal and external application data throughout the ecosystem.  The ideal candidate will have hands-on experience with Amazon RDS, AWS Lambda, Python Glue, SQL-based data solutions, and a strong understanding of data pipelines, ETL processes, warehouse concepts , and cloud-based architecture. You will collaborate closely with data scientists, analysts, and cross-functional teams to ensure robust data availability and accessibility.  This is remote position with an expectation of occasional client site visits. 

 

 You’ll be working on our prime contract supporting the USMEPCOM, a major command within the U.S. Department of Defense (DoD), responsible for screening and processing applicants into the U.S. Armed Forces. USMEPCOM operates 65 Military Entrance Processing Stations (MEPS) across the U.S., serving as the critical link between recruitment and training for the armed forces.

 

At ITility, we help our customers command the future by thinking beyond perceived limits to create new, unexpected ways to protect and defend our nation. We inspire and empower people to create significant solutions that secure what matters to our customers and communities, here and around the globe.

 

We Value:

• The Drive to Perform Beyond Perceived Limits.
• The Desire to Find Significance in All We Do.
• The Passion and Compassion That Powers Both.

Responsibilities

Key Responsibilities:

• Design & Development:
  • Architect and implement scalable data storage solutions using AWS services like Amazon RDS, S3, Redshift, Lambda, Python and Glue.
  • Write and optimize complex SQL queries for data retrieval and processing on RDS.
  • Develop, optimize, and maintain data pipelines to support data transformation and integration.
• ETL/ELT Pipelines:
  • Design, build, and manage ETL/ELT pipelines to ingest data from various sources into AWS storage layers.
  • Use AWS Glue, Lambda, or custom scripts (Python and SQL) for data transformation and orchestration.
• Performance Optimization:
  • Monitor, analyze, and optimize database and query performance on Amazon RDS.
  • Collaborate with teams to refine data models and indexing strategies.
• Collaboration & Communication:
  • Partner with stakeholders to define data requirements and ensure seamless integration with data systems.
  • Provide documentation and training for other engineers and analysts.
• Additional details:
  • Other reasonable job duties applicable to your role and location in support of the mission objectives.

  • This position may require travel to other contract duty locations, and selected individual must be willing to travel up to 10%. 

Qualifications

Required Skills and Qualifications:

• Bachelor’s degree in Computer Science, Engineering, or related field
• US Citizenship Required to be processed for a Government Background Investigation.
• 8+ years of professional experience as a Data Engineer or similar role.
• AWS certifications preferred (e.g., AWS Certified Data Analytics, AWS Certified Solutions Architect, AWS Certified Data Engineer).
• Strong proficiency in SQL, including advanced query writing, optimization, and troubleshooting.
• Strong proficiency in Python, including pandas, numpy and PySpark.
• Hands-on experience with Amazon RDS, including setup, maintenance, and scaling.
• Proficiency with AWS services such as S3, Glue, Athena, Lambda, Redshift, SNS, and API Gateway
• Experience in designing and maintaining data pipelines using ETL tools or custom scripting (e.g., Python, PySpark).
• Knowledge of data modeling, normalization, and database design principles.
• Experience with CI/CD pipelines for data engineering projects. (Git)
• Famil