Data Analytics Consultant

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 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.
• If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com .
• All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.
• All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @guidehouse.com or guidehouse@myworkday.com .
• Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse.
• Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event.
• Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.
• If any person or organization demands money related to a job opportunity with Guidehouse, please report the matter to Guidehouse’s Ethics Hotline.
• If you want to check the validity of correspondence you have received, please contact recruiting@guidehouse.com .
• Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicant’s dealings with unauthorized third parties.
• Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies.
• All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.