Data Engineer

About the Role

Key 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, 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.
• 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.

Requirements

• An ACTIVE and MAINTAINED SECRET Federal or DoD security clearance.
• Bachelor's degree is required.
• Minimum FOUR (4) years of 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.
• Ability to detect data issues affecting the performance of data pipelines and devise techniques for resolving or mitigating them.

Nice to Have

• Knowledge of Archibus and/or Kahua.
• Proficiency in querying and joining datasets using SQL.
• 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.

Benefits & Perks

• Medical, Rx, Dental & Vision Insurance
• Personal and Family Sick Time & Company Paid Holidays
• Parental Leave
• 401(k) Retirement Plan
• Group Term Life and Travel Assistance
• Voluntary Life and AD&D Insurance
• Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
• Transit and Parking Commuter Benefits
• Short-Term & Long-Term Disability
• Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
• Employee Referral Program
• Corporate Sponsored Events & Community Outreach
• Care.com annual membership
• Employee Assistance Program
• Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
• Position may be eligible for a discretionary variable incentive bonus