Intern_Data Validation, Operational Analytics and Automation, ECDA/TFN
Posted Updated Apply by 1
view
Ministry Of Social And Family Development Intern_Data Validation, Operational Analytics and Automation, ECDA/TFN
Description
Early childhood attendance data plays a foundational role in ECDA's oversight of preschool operations, informing resource planning, policy decisions, and regulatory compliance. The TFN Division is looking to improve operational efficiency and data integrity in the preschool attendance workstream by (a) conducting a rigorous data validation exercise to assess whether the current monthly attendance reporting process from preschools can be streamlined, (b) supporting enhancements for preschool attendance reporting and other operational analytics dashboards, and (c) reducing manual effort in routine communications and data preparation through process automation.
The primary focus of the internship will be on the data validation exercise and supporting enhancement work (approximately 90% of time), with the remaining 10% dedicated to process automation.
Responsibilities
Project scope - Conduct a comparative analysis between derived monthly attendance figures (aggregated from daily data) and monthly attendance data submitted by preschools. - Design and apply appropriate data validation and statistical methods to assess discrepancies, including proposing acceptable tolerance thresholds and identifying potential causes of variance. - Develop a recommendation framework on whether the current monthly attendance submission process can be streamlined or discontinued, based on data reliability, operational considerations, and risk assessment. - Support the building and enhancement of dashboards for preschool attendance monitoring and reporting. - Support the rework of Python/SQL scripts for monthly preschool attendance data collation, based on the new daily submission process. - Develop automation scripts and workflows to reduce manual effort in the collation and preparation of emails and templates. - Present analysis findings and recommendations to the team and relevant stakeholders.Requirements
- Proficient in at least one of Python, SQL, VBA, or Power Automate, and has strong analytical and problem-solving skills with the ability to propose and apply appropriate statistical or data validation methods. - Good writing and presentation skills are important, as the intern will be expected to communicate technical findings clearly to non-technical stakeholders. - The candidate should be comfortable working with large datasets and translating findings into recommendations, and be a self-driven, organised team player with strong attention to detail.Skills
Sign in to read and join the discussion.