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