RESOURCE MAPPING & DATA DASHBOARD PROJECT MANAGER - 69615

Executive Service

For more information, visit the link below:
https://acrobat.adobe.com/id/urn:aaid:sc:va6c2:fe80e7ef-6c3b-4837-af99-092ebd9e51fb https://acrobat.adobe.com/id/urn:aaid:sc:va6c2:abb5e440-9412-4d17-bc0e-2544f8b26b39

Who we are and what we do:

The Tennessee Commission on Children and Youth (TCCY) is an independent, nonpartisan agency created to ensure the states policies and programs effectively promote and protect the health, well-being and development of children and youth. Established by the Tennessee General Assembly as a permanent commission, TCCY is the states centralized informational resource and advocacy agency for timely, fact-based information to aid policymaking and coordination of resources.

Job Overview:

This position manages Tennessee's legislatively mandated Resource Mapping Project, which tracks all public funding for services to children and families in Tennessee, and contributes to the agency's FUTURE Data Dashboard, a public-facing tool displaying key indicators of child well-being. The ideal candidate will bring strong analytical, organizational, and data management skills, strong writing skills with the ability to interpret data into a meaningful narrative, as well as an interest in improving state systems for children and families.

Key Responsibilities:

Resource Mapping Project Management

1. Oversee the annual data collection and reporting process for the Tennessee Resource Mapping Project, a statewide effort to account for all federal and state funding dedicated to children and youth.
2. Prepare for each new cycle by reviewing prior-year files, updating documentation, and coordinating with Strategic Technology Solutions (STS) to ready the internal data collection platform.
3. Manage outreach to and communication with over 20 state departments and divisions to request and receive funding data.
4. Organize and facilitate kickoff and technical support meetings with agency contacts to explain guidelines and deadlines.
5. Review submitted data for completeness, consistency, and compliance with reporting definitions.
6. Provide follow-up and technical assistance as needed to resolve errors or omissions.
7. Analyze data using Excel and other tools, including pivot tables and categorization by funding source (federal, state, local), program area (e.g., education, health), population served (age groups), and service outcomes.
8. Draft content for the Resource Mapping Report, including executive summaries, analysis sections, charts, tables, and appendices.

FUTURE Data Dashboard Support

1. Assist with updating and maintaining TCCYs FUTURE Data Dashboard, which highlights key indicators of child and youth well-being using data from federal and state sources (CDC, Census Bureau, TN Department of Health, Department of Education, etc.).
2. Monitor release schedules for key datasets and work with internal staff to retrieve and clean new data.
3. Follow established internal procedures to:
   1. Update tracking spreadsheets and documentation.
   2. Refresh interactive charts, graphs, and maps on the live dashboard.
4. Ensure data displayed on the dashboard remains accurate, timely, and well-documented for external users.
5. Contribute to quality assurance and user experience improvements by identifying data issues, formatting inconsistencies, or usability concerns.
6. Collaborate with policy staff to interpret trends and ensure data is appropriately framed for public and policymaker use.

Minimum Qualifications:

1. Bachelors degree in Public Policy, Data Science, Public Administration, Economics, Social Sciences, or related field.
2. Experience with Microsoft Excel, including pivot tables and data cleaning.
3. Familiarity with data visualization platforms (Infogram, Flourish, Tableau, ArcGIS, or Power BI).
4. Strong written and verbal communication skills.
5. Ability to manage multiple deadlines and projects simultaneously.

Pursuant to the State of Tennessee's Workplace Discrimination and Harassment policy, the State is firmly committed to the principle of fair and equal employment opportunities for its citizens and strives to protect the rights and opportunities of all people to seek, obtain, and hold employment without being subjected to illegal discrimination and harassment in the workplace. It is the State's policy to provide an environment free of discrimination and harassment of an individual because of that person's race, color, national origin, age (40 and over), sex, pregnancy, religion, creed, disability, veteran's status or any other category protected by state and/or federal civil rights laws.