onsite
Data Analyst - Wake County Public School System
Data Analyst
Data Analyst responsible for ensuring data accuracy, generating regular reports, and building interactive dashboards for the Office of Early Learning, using SQL, Excel and data visualization tools.
About the role
Key Responsibilities
- Maintain and validate current and historical databases to ensure data integrity for all Early Learning programs.
- Produce weekly, monthly, and annual reports that track program performance, enrollment, and service delivery metrics.
- Design, develop, and update an interactive OEL Data Dashboard for stakeholders, incorporating key performance indicators.
- Perform data extraction, transformation, and loading (ETL) tasks using SQL and Excel to support analysis and reporting needs.
- Collaborate with program staff to identify data requirements, troubleshoot issues, and recommend improvements.
Requirements
- Proficiency in SQL for querying relational databases and data manipulation.
- Advanced Excel skills, including pivot tables, formulas, and data visualization.
- Experience creating dashboards and visual reports using tools such as Tableau, Power BI, or similar.
- Strong attention to detail and ability to ensure data quality and accuracy.
- Effective communication skills to translate data insights into actionable recommendations for non‑technical audiences.