The U.S Federal border security customers are looking to improve their data-driven decision-making capabilities by collecting, transforming, integrating, and analyzing data to identify trends, assess performance, and develop visualizations in support of organizational and mission goals.
Requirements
- 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, Python, or R, etc.
- Experience using Databricks to clean, transform and integrate complex datasets into production systems
- Experience using business intelligence tools like Tableau and/or Power BI to visualize large data sets
- Proficiency in querying and joining datasets using SQL.
- Proficiency in data wrangling and analysis using Python
- Certifications in relevant areas to include project management, 508 compliance and/or data engineering
Responsibilities
- Develop and maintain data governance documentation, tools, and templates.
- Construct data pipelines and flows to support enterprise data reporting and analysis
- Define data requirements and ensure storage, availability, and coherence of electronically stored information meets the client’s needs.
- 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.
Other
- Up to 10% travel required
- Active Public Trust clearance required
- Bachelor's degree
- FOUR (4) years of experience in hands-on data engineering, data visualization and/or database management
- Master's degree in relevant field (e.g. Data Science, Computer Science, Engineering or Applied Mathematics) preferred
