Data Analytics Consultant with Security Clearance

Job Family :
Data Science Consulting Travel Required :
None Clearance Required :
Ability to Obtain Public Trust What You Will Do : The Data Analytics Consultant will support DHS PLCY by delivering data visualizations, analytics products, and automated workflows that enable informed, mission-focused decision-making. This role transforms complex datasets into clear, actionable insights for senior leaders, strengthening policy execution and improving operational visibility across Headquarters. The consultant will apply hands-on technical skills with strong communication capabilities to produce dashboards, data cleansing scripts, and stakeholder-ready documentation. Responsibilities include the following: * Design and develop enterprise-quality dashboards and data visualizations using Tableau and Power BI to support PLCY front office and sub-office leadership.
* Clean, transform, and integrate datasets from multiple DHS systems; develop repeatable Python or R scripts for data cleansing and transformation.
* Build process documentation, workflow guides, and PowerPoint walkthroughs for dashboard demos, requirement discussions, and leadership briefings.
* Collaborate with PLCY stakeholders to collect requirements, refine metrics, validate data sources, and ensure visualizations meet operational and strategic needs.
* Maintain, enhance, and automate reporting workflows using Power Automate and other O365 tools to streamline recurring reporting cycles.
* Present technical findings and complex analytical concepts to non-technical audiences in clear and accessible formats.
* Support development of PLCY analytics standards, governance practices, and repeatable frameworks that enable scalable, decision-ready insights.
* Build collaborative relationships across PLCY, OHSS, and DHS components to support integrated analytics and mission execution. What You Will Need : * Must be able to OBTAIN and MAINTAIN a Federal or DHS "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
* Bachelor's degree in data analytics, computer science, public policy, engineering, or a STEM related field.
* FIVE (5) or more years of experience in data analytics, data visualization, or related technical consulting fields.
* Experience with Tableau and Power BI, including dashboard design, visual storytelling, and leadership-ready products.
* Experience with Python, R, or similar languages for data cleansing and transformation.
* Must be able to go to client site in Anacostia, DC. What Would Be Nice To Have : * Familiarity with Power Automate or other cloud-based workflow automation tools.
* Ability to collaborate effectively and professionally in fast-paced, high-visibility environments.
* Strong writing and communication skills, including ability to produce polished documentation, stakeholder briefings, and demo materials.
* Experience working with DHS or other federal agencies, particularly in data-driven or analytics-focused environments.
* Knowledge of cloud analytics environments (AWS, Azure, Databricks, Palantir).
* Experience supporting policy offices or strategic planning teams within government.
* Understanding of ETL/ELT processes, data governance frameworks, and performance analytics.
* Experience developing leadership dashboards, requirements documents, or briefing materials for senior executives. The annual salary range for this position is $113,000.00-$188,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs. What We Offer : Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include: * 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 About Guidehouse Guidehouse is an Equal Opportunity Employer-Protected Veterans, Individuals with Disabilities or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with cri