Data Analytics Consultant

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

• 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 criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.