During my tenure as a Data Analyst at the Youth Justice Service office, a critical challenge was presented related to the efficacy of rehabilitation programs for youth offenders. The existing data infrastructure was fragmented, hindering the ability to assess the impact of intervention programs accurately.

My task was to unify and analyze disparate datasets, providing meaningful insights into the effectiveness of various rehabilitation initiatives. This was essential for evidence-based decision-making and resource allocation to enhance the youth rehabilitation efforts.

I initiated a comprehensive data integration project, collaborating closely with different departments within the Youth Justice Service office to collect and consolidate relevant information. Using SQL and Python, I developed scripts to clean, transform, and merge datasets, ensuring data consistency and integrity.

Understanding the significance of collaboration in a government setting, I organized workshops to gather insights from frontline staff, counselors, and program managers. This collaborative approach helped me identify nuanced factors that were crucial in assessing the impact of rehabilitation efforts

In addition, I implemented advanced statistical analyses to measure recidivism rates, program completion rates, and other key performance indicators. Visualizations, including interactive dashboards, were created to present the findings in an accessible manner for both technical and non-technical stakeholders.

The data-driven insights provided a holistic view of the effectiveness of youth rehabilitation programs. The recidivism rate analysis revealed a notable decrease, showcasing the positive impact of specific interventions. This evidence-based approach not only informed strategic decisions within the Youth Justice Service but also facilitated targeted improvements in programs and resource allocation.

Furthermore, my collaborative approach fostered a culture of data-driven decision-making within the organization, with the findings being utilized in policy discussions and presentations to external stakeholders. The success of this project contributed to a more informed and efficient Youth Justice Service, ultimately benefiting the community and the individuals involved in the rehabilitation programs.