Impact Analytics Manager

City Year is a non-profit organization dedicated to supporting students and schools. The Impact Analytics Manager will be responsible for data management, progress monitoring, and reporting to enhance the support provided to students and partner schools.

What you'll do:

• Support the collection and transformation of student-level data (attendance, behavior, and course performance) across multiple platforms to ensure accurate progress monitoring and reporting
• Support the collection and transformation of AmeriCorps member and partner data to ensure accurate progress monitoring of Corps and Partner experience
• Execute the set-up and administration of multiple enterprise assessment (DESSA) platforms
• Support the set-up and maintenance of enterprise salesforce platform for progress monitoring
• Design, create, and maintain tools that support site data collection using Excel, Power Apps, and Forms
• Create and maintain relevant data visualizations that support with monitoring student progress and analyzing program delivery and impact
• Supporting with the design and maintenance of our data model using Power Query and Power BI (DAX) to support with reporting service delivery and student impact to stakeholders
• Design and deliver trainings for staff and AmeriCorps members on how to use City Year’s data systems and tools including how to interpret program data to improve student outcomes
• Lead on the design and execution of a curriculum for a subset of AmeriCorps members to support ACM’s professional development in data and analytics
• Lead on designing training resources for Impact Analytics tools and systems to support our users
• Respond to data requests and questions by using the common data model and compiling in excel
• Support the service team in accessing and interpreting student level data including leading data reviews and answering questions

What they're looking for:

• Proficiency using Microsoft Office software (Excel, Word, Outlook, Teams, and PowerPoint)
• One year of data analysis experience (academic or professional preferred)
• Ability to interpret and display data to engage audiences
• Demonstrated ability to translate project goals into an action plan and to organize resources to meet timelines/deadlines
• Authorized documentation to work in the United States of America
• Criminal background history clearance to work with school-age children, depending on the position
• Exceptional critical thinking skills and experience supporting multi-faceted projects
• Proficiency in using Microsoft Excel: Power Query & VBA
• Proficiency using Access
• Proficiency with data visualization software (e.g. Power BI, Tableau, etc.)
• City Year and AmeriCorps alumni are encouraged to apply

Benefits:

• Eligible for all benefits including vacation, sick days and organization holidays
• Medical coverage
• Dental coverage
• Vision coverage
• Life coverage
• Accidental death and dismemberment coverage
• Disability coverage
• Flexible Spending Accounts (FSA)
• 401(k) plan(s) pursuant to the terms and conditions of company policy and the 401(k) plan document
• You may participate in all benefit programs that City Year establishes and makes available to eligible employees, under (and subject to all provisions of) the plan documents that govern those programs