Data Engineer
| Company | Guidehouse |
|---|---|
| Location | Arlington, VA, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Mid Level |
Requirements
- An ACTIVE and MAINTAINED SECRET Federal or DoD security clearance.
- Bachelor’s degree
- 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 reading and cleaning data from external tables and importing it into relational database tables.
- Ability to detect data issues affecting the performance of data pipelines and devise techniques for resolving or mitigating them.
Responsibilities
- 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.
- 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.
- Develop intuitive, attractive, and interactive data visualizations using large data sets to create dashboards, using tools such as Tableau and Power BI, for a diverse set of users with varying technical capabilities.
- Request, document, report, and analyze data, and where applicable, create tools and resources to support data and reporting.
- Support hybrid work environments involving work on client site, in a Guidehouse office, and remote.
Preferred Qualifications
- Knowledge of Archibus and/or Kahua.
- Proficiency in querying and joining datasets using SQL.
- Proficiency developing data pipelines using Palantir.
- Proficiency in data wrangling and analysis using Python.
- Proficiency developing dashboards using Tableau or Power BI.
- Experience utilizing Robotic Process Automation (RPA) tools to streamline and automate workflows.
- Proficiency in programming with Excel Visual Basic for Applications (VBA).
- Experience supporting Department of State and/or understanding of the nomenclature and organizational structure of offices within the Department of State.