Job Family:Management Consulting
Travel Required:None
Clearance Required:Active Secret
What You Will Do:Guidehouse is seeking a Management Analyst to join our team supporting a high-visibility federal program focused on data integrity, fraud prevention, and mission-critical decision support. In this role, you will apply strong data analysis skills, SQL coding expertise, and detailed data validation methods to produce accurate, reliable, and timely insights in a fast-paced, complex operational environment. You will work within a collaborative consulting team, helping develop reporting solutions, analytical studies, and enhancing workflows that directly enable federal agency leaders to make informed, data-driven decisions.
Responsibilities Include:
Develop recurring and ad hoc reports, dashboards, and structured analysis that provides insights to operational outcomes and supports problem solving and process improvements.
- Extract, clean, join, and validate data from multiple systems to support fraud analysis
- Maintain and troubleshoot existing reporting processes, ensuring data quality and consistency
- Translate analytical findings into clear, accessible insights for non-technical audiences
- Document processes, assumptions, and methodologies to ensure reproducibility
- Ensure that all deliverables meet Guidehouse and client quality, accuracy, and formatting standards
- Manage tasks and problem solve independently, escalate risks early, and consistently meet deadlines
- Collaborate with client stakeholders to refine requirements and improve analytic workflows
- Review client reports for statistical accuracy
- Deliver timely analysis and data products to address unplanned or rapid-response requests
What You Will Need: - An ACTIVE and MAINTAINED "SECRET" Federal or DoD security clearance
- Bachelor's degree
- ONE (1) year of consulting, analyst or project management support experience
- Strong proficiency in SQL for data extraction, transformation, and validation
What Would Be Nice To Have: - Experience with R or Python for scripting, automation, or analytical workflows
- Experience with database management (schema design, optimization, ETL familiarity)
- Experience with Databricks or cloud-based analytics platforms
- Experience with Tableau or other data visualization tools
- Familiarity with Microsoft Access
- Advanced Microsoft Excel skills (pivot tables, formulas, logic, QC workflows, basic modeling)
- Ability to analyze large structured and unstructured datasets and produce meaningful insights
- Experience supporting recurring reporting cycles and quality-controlled deliverables
- Strong communication skills, particularly in conveying technical concepts to non-technical audiences
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