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.

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%. 

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)
• Familiarity with big data processing frameworks like Apache Spark or Hadoop.
• Knowledge of NoSQL databases (e.g., DynamoDB) and data streaming tools like Kafka or Kinesis.

Soft Skills:

• Strong problem-solving and analytical thinking abilities.
• Excellent communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
• Team player with a proactive attitude and willingness to learn new technologies.

Physical Requirements:

• Prolonged periods of sitting at a desk and working on a computer.
• Must be able to lift up to 15 pounds.

ITility is committed to providing a work environment that is non-discriminatory, harassment free, fair, ethical and inclusive.

ITility is committed to the principle of equal employment opportunity and complies with all applicable laws which prohibit discrimination and harassment in the workplace. ITility strictly prohibits discrimination or harassment based on race, color, religion, national origin, sex, age, disability or any other characteristic protected by law in all terms, conditions and privileges of employment, including without limitation, recruiting, hiring, assignment, compensation, promotion, discipline and termination. This policy covers conduct occurring at ITility’s offices, client sites, other locations where ITility is providing services, and to all work-related activities.