Junior Data Engineer

Role Overview

• Supports system-specific implementations that enable enterprise ingestion by assisting in the design, build, and operation of automated metadata harvesting pipelines that populate DHA-EDC content on reliable schedules.
• Focuses on hands-on engineering using SQL/Python/R to develop connectors and extraction scripts, implement validation rules, and configure refresh frequencies to support completeness, accuracy, and timeliness of harvested metadata.
• Works closely (in-person and virtually) with source system SMEs to safely extract metadata from authorized sources.
• Escalates tool constraints and design decisions to Architects within the approved architecture.
• Contributes to building and orchestrating metadata extraction pipelines to ensure timely population of DHA-EDC content.
• Collaborates in-person/virtually with source system SMEs to safely extract metadata from relevant sources and validate results during review cycles.
• Supports implementation and testing of automated metadata harvesting tools and ETL/ingestion workflows to enable real-time or scheduled extraction.
• Implements validation checks to help measure metadata completeness, accuracy, and timeliness, including coverage reporting and issue flagging for remediation.
• Participates in defect triage and troubleshooting for failed harvest runs, refresh delays, or validation errors; documents findings and supports re-runs after fixes.
• Co-develops the metadata harvesting plan with Architects and program stakeholders; translates requirements into build tasks and technical documentation.
• Produces and maintains technical documentation for pipelines, connector configurations, validation logic, and refresh schedules to support sustainment and knowledge transfer.

Requirements

• Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST".
• Ability to meet the project’s client security and access requirements.
• Bachelor’s degree obtained
• 3 years of experience (or strong internship/coop experience) in data engineering, ETL/ELT, or pipeline development using SQL and Python.
• Working proficiency in SQL and Python; familiarity with R is a plus for statistical validation and profiling.
• Familiarity with building or supporting connectors/extractors (e.g., relational sources, APIs, file-based repositories) and running scheduled jobs.
• Ability to collaborate with technical SMEs and follow structured validation and documentation processes.
• Strong written and verbal communication skills; ability to document technical work clearly and escalate issues appropriately.
• Once onboard with Guidehouse, new hire MUST be able to OBTAIN and MAINTAIN a Federal or DoD "Secret" security clearance.

Tech Stack

• ETL
• Python
• SQL

Benefits

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Position may be eligible for a discretionary variable incentive bonus
• Parental Leave and Adoption Assistance
• 401(k) Retirement Plan
• Basic Life & Supplemental Life
• Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
• Short-Term & Long-Term Disability
• Student Loan PayDown
• Tuition Reimbursement, Personal Development & Learning Opportunities
• Skills Development & Certifications
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Emergency Back-Up Childcare Program
• Mobility Stipend