Junior Data Engineer

Guidehouse

Junior Data Engineer at Guidehouse supporting metadata harvesting pipelines and collaborating with SMEs. Focused on SQL/Python development and ensuring data accuracy and timeliness.

Posted 5/21/2026full-timeMcLean • Virginia • 🇺🇸 United StatesJuniorWebsite

Tech Stack

Tools & technologies

ETLPythonSQL

About the role

Key responsibilities & impact

Supports system-specific implementations that enable enterprise ingestion by assisting in the design, build, and operation of automated metadata harvesting pipelines
Focuses on hands-on engineering using SQL/Python/R to develop connectors and extraction scripts
Implements validation rules, and configures refresh frequencies to support completeness, accuracy, and timeliness of harvested metadata
Collaborates in-person/virtually with source system SMEs to safely extract metadata from relevant sources and validate results during review cycles
Implements validation checks to help measure metadata completeness, accuracy, and timeliness
Participates in defect triage and troubleshooting for failed harvest runs, refresh delays, or validation errors
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

What you’ll need

Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"
Candidates with an ACTIVE SECRET CLEARANCE OR PUBLIC TRUST or SUITABILITY are preferred
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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonRETLELTmetadata harvestingdata engineeringconnector developmentvalidation rulestechnical documentation

Soft Skills

collaborationcommunicationproblem-solvingattention to detaildocumentationescalationteamworkadaptabilityanalytical thinkinginterpersonal skills

Certifications

Federal or DoD Public TrustActive Secret Clearance