Data Engineer

Guidehouse

Data Engineer supporting a global implementation of IT systems for the Department of State. Reviewing data policies and providing recommendations for data architectures and visualizations.

Posted 6/26/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $77,000 - $129,000 per yearWebsite

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

The Data Engineer will join a dynamic team supporting a global implementation of IT systems at the Department of State
Review and support the client’s data policies, processes, and standards to identify strengths and areas for improvement
Provide recommendations for the current and future architecture to support data and analytical needs
Collect, transform, integrate, and analyze data to identify trends, assess performance, and develop visualizations in support of organizational and mission goals and data-driven decision-making for the client
Develop and maintain data governance documentation, tools, and templates
Define data requirements and ensure storage, availability, and coherence of electronically stored information meets the client’s needs
Develop data pipelines involving collecting, transforming, cleaning, and validating data from multiple sources, using tools such as Palantir
Coordinate with non-technical users to gather requirements
Identify, summarize, and catalog data fidelity issues, and make recommendations to the client on how to resolve or mitigate the issues
Request, document, report, and analyze data, and where applicable, create tools and resources to support data and reporting.

Requirements

What you’ll need

ACTIVE and MAINTAINED SECRET Federal or DoD security clearance
Bachelor's degree in a relevant technical field
THREE (3) years’ experience in hands-on data engineering and/or database management
Understanding of relational database concepts and structures
Demonstrated ability to perform data blending, joining, and cleaning to ensure accurate and usable datasets using querying or data engineering software tools, such as SQL, Palantir, etc.
Experience using Palantir Foundry to clean, transform, and integrate complex datasets into production systems (e.g., Archibus)
Experience reading and cleaning data from external tables and importing it into relational database tables
An acute attention to detail when reviewing tens-of-thousands of rows of data from numerous sources
Ability to detect data issues affecting the performance of data pipelines and devise techniques for resolving or mitigating them
Ability to collaborate with team members, other development groups, and users to determine and implement the best approach for all data synchronization work
Flexibility to take direction from team members and adjust work activities for solutioning on various data efforts.

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

data engineeringdatabase managementdata blendingdata cleaningdata transformationdata integrationSQLPalantirrelational database conceptsdata pipelines

Soft Skills

attention to detailcollaborationflexibilityproblem-solvingcommunication

Certifications

SECRET Federal security clearance