Border Security Technical Data Analyst

Guidehouse•Washington, DC

1d•$85,000 - $141,000•Hybrid

About The Position

The Technical Data Analyst will join a dynamic team supporting U.S Federal border security customers. In this role, the candidate will 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. Duties may include: 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. 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 CBP PUBLIC TRUST.
Bachelor's degree
FOUR (4) years of experience in hands-on data engineering, data visualization 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, 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

Nice To Haves

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
Experience supporting CBP and/or understanding of the nomenclature and organizational structure of offices within CBP.
Master's degree in relevant field (e.g. Data Science, Computer Science, Engineering or Applied Mathematics)

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.
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.

Benefits

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