Note: The job is a remote job and is open to candidates in USA. Guidehouse is seeking a Data Analyst with strong child welfare domain expertise to support a state agency modernization effort. This role focuses on working directly with agency stakeholders to translate program needs into data-driven insights, scalable reporting, and actionable dashboards.

Responsibilities

• Partner with agency stakeholders to gather requirements and define analytics and reporting needs
• Assess and prepare data from multiple systems for analytics and reporting use cases
• Design and develop operational and decision-support dashboards that drive action
• Translate program workflows and policy into clear metrics, KPIs, and reporting logic
• Build and publish user-centered data products that are accessible and meaningful to business users
• Advise stakeholders on opportunities to expand the role and impact of data across the agency
• Collaborate across program, policy, and technical teams to align reporting with business priorities

Skills

• Bachelor's degree from an accredited college/university
• Based on our contractual obligations, candidate must be located within the United States and US Citizen
• Must be able to obtain and maintain a federal public trust
• Prior experience in child welfare, human services, or related social programs (state agency, consulting, or nonprofit)
• Minimum 3 + years of experience in data analytics, business intelligence, or reporting
• Proven experience developing dashboards (preferred: Power BI)
• Experience with SQL and Python
• Ability to prepare and execute data pipelines and integrations
• Strong experience preparing, transforming, and structuring data for reporting and analytics
• Experience with structured and unstructured data
• Experience working directly with stakeholders to gather requirements and design user-centered data products
• Ability to translate business needs into actionable insights and visualization
• Experience supporting state or county child welfare agencies
• Familiarity with CCWIS or large human services system environments
• Experience working across multiple data sources or legacy systems
• Exposure to data governance, metric standardization, or reporting strategy efforts
• Experience building executive-level dashboards or performance reporting

Benefits

• 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

Company Overview