Business Analytics Consultant

US101 Guidehouse Inc.; Washington (District of Columbia); On-site; USD 74,000 - 124,000; Full time

Benefits offered by this job

Medical, Dental & Vision Insurance

401(k) Retirement Plan

Employee Referral Program

Mobility Stipend

Job summary

Guidehouse is seeking a Data Analytics Consultant to support Homeland Security and Federal Law Enforcement clients. You will analyze business challenges, develop data-driven recommendations, and implement solutions using analytics, BI, automation, and low-code tech.

This onsite role requires active TS clearance and 2+ years of experience in consulting or analytics. Responsibilities include building dashboards, KPIs, and data visualizations with Power BI, and designing Power Apps and Power

Qualifications

• Active Top Secret clearance (TS) required.
• 2+ years of professional experience in consulting, business analysis, BI, analytics, or related transformation.
• Experience developing dashboards, reports, and visualizations using Power BI.

Responsibilities

• Evaluate processes and opportunities to improve and modernize operations.
• Lead requirements gathering, stakeholder interviews, and discovery sessions.
• Analyze data to identify trends, risks, and efficiency gaps.
• Develop executive dashboards and KPIs to support decision making.
• Design Power Apps solutions to streamline data collection and workflow tracking.
• Create automated Power Automate workflows to improve data quality and reduce manual work.
• Translate requirements into scalable technical designs.
• Present findings and recommendations to leadership and stakeholders.
• Collaborate with client teams to ensure delivery and adoption.

Skills

Analytical thinking

Stakeholder interviews

Requirements gathering

Process improvement

Education

Bachelor's degree in Business/Information Systems/Data Analytics/CS/Engineering

Tools

Power BI

Power Apps

Power Automate

Job description

Job Family: Management Consulting Travel Required: Up to 10% Clearance Required: Active Top Secret (TS)

What You Will Do:

Guidehouse is seeking a Data Analytics Consultant to support Homeland Security and Federal Law Enforcement clients in improving mission operations, enhancing organizational effectiveness, and advancing digital transformation initiatives. The successful candidate will serve as a trusted advisor, partnering with client stakeholders to analyze business challenges, evaluate operational processes, develop data-driven recommendations, and implement solutions leveraging analytics, business intelligence, automation, and low-code technologies. This role combines consulting, process improvement, and technical solution delivery to help clients achieve mission‑critical outcomes.

Responsibilities:

• Evaluate business processes, operational workflows, and organizational challenges to identify opportunities for improvement and modernization.
• Lead requirements gathering sessions, stakeholder interviews, workshops, and discovery meetings to understand client needs and define solution strategies.
• Analyze business problems and operational data to identify trends, risks, performance gaps, and opportunities for increased efficiency.
• Develop and maintain executive dashboards, scorecards, and data visualizations using Power BI and other analytics tools.
• Design and implement Power Apps solutions that streamline data collection, case management, workflow tracking, and operational reporting.
• Develop Power Automate workflows to automate business processes, improve data quality, and reduce manual effort.
• Translate business requirements into scalable technical and functional solution designs.
• Develop key performance indicators (KPIs), metrics frameworks, and performance measurement strategies that support mission and organizational objectives.
• Conduct process analysis and recommend improvements that enhance effectiveness, accountability, and decision‑making.
• Create process maps, workflow diagrams, user stories, functional requirements, and technical documentation.
• Present findings, recommendations, and solutions to client leadership and program stakeholders.
• Collaborate with client teams, technical resources, and project managers to ensure successful solution delivery and adoption.
• Support continuous improvement initiatives through analytics, reporting, and business process automation.
• Deliver client services while supporting business development activities, proposal efforts, internal initiatives, and professional development.
• Manage project tasks, timelines, and deliverables while balancing multiple priorities in a dynamic consulting environment.

This role is 100% onsite.

What You Will Need:

• An ACTIVE and MAINTAINED TOP SECRET Federal or DoD security clearance.
• Bachelor's degree in Business, Information Systems, Data Analytics, Computer Science, Public Administration, Engineering, or a related field.
• TWO (2) or more years of professional experience in consulting, business analysis, business intelligence, analytics, process improvement, or technology transformation.
• Experience developing dashboards, reports, and visualizations using Power BI.
• Experience gathering, documenting, and translating business requirements into technical solutions.
• Understanding of business process analysis, workflow optimization, and operational performance measurement.
• Strong written and verbal communication skills, including experience presenting findings to stakeholders.
• Ability to manage multiple projects and priorities simultaneously.

What Would Be Nice To Have:

• Experience documenting requirements, creating functional specifications, technical user guides, and preparing wireframes/flowcharts.
• Experience with HR data analytics and reporting.
• Excellent organizational, prioritization, and time management abilities, with a keen eye for detail.
• Ability to manage multi-task projects.
• Knowledge and experience working with Power Apps and Power Automate

The annual salary range for this position is $74,000.00-$124,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 a global AI‑led professional services firm delivering advisory, technology, and managed services to the commercial and government sectors. With an integrated business technology approach, Guidehouse drives efficiency and resilience in the healthcare, financial services, energy, infrastructure, and national security markets. Built to help clients across industries outwit complexity, the firm brings together approximately 18,000 professionals to achieve lasting impact and shape a meaningful future.

Equal Opportunity Employer

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.

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.

guidehouse.com