Chicago Public Schools
Data Analyst
Chicago Public Schools, Chicago, Illinois, United States, 60290
Chicago Public Schools (CPS) is one of the largest school districts in the United States, serving over 320,000 students in 600+ schools and employing approximately 40,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each for success in college, career, and civic life. In order to fulfill this mission, we make three commitments to our students, their families, and all Chicagoans: academic progress, financial stability, and integrity. Six core values are embedded within these commitments - student-centered, whole child, equity, academic excellence, community partnership, and continuous learning.
The Office of Budget and Grants Management (OBGM) supports the strategic utilization of all resources, aligning them to district priorities by spearheading CPS' financial strategy to support effective budget planning and maximizing available funds.
Job Summary:
Reporting to the Director of Training & Quality, the Data Analyst will support the School Resource Strategy (SRS) team within OBGM with creation of reports and budget tracking tools and metrics used in assisting school Principals and Network Chiefs in evaluating budgets, formulating strategic priorities, and maximizing resources. The Data Analyst will also be responsible for analyzing complex data sets and to identify opportunities to simplify and refine business systems and processes through the development of reports.
The Data Analyst will be held accountable for the following responsibilities:
Work closely with the Director of Training & Quality to manage the performance of OBGM, including strategic planning, creating performance metrics, and goal settingWork in the Oracle system to pull and analyze budget and financial data setsAssist with gathering requirements for the development of and updates to the Business Intelligence dashboard and School Budget Overview reportsDevelop, prepare, and review operations and school reports to gain insight into business drivers, efficiencies, and data accuraciesDesign, enhance, and report performance management dashboards, employee scorecards, and reports on a weekly and monthly basisOversee service delivery data (call and ticket performance metrics) for all call center functions, anticipating customer needs, actively monitoring and reporting on customer feedback and concerns to Central Office leadershipTrack satisfaction among customers through various tools including ServiceNow and provide comprehensive reporting for the Office of Budget and Grants ManagementSupport inbound call traffic monitoring, maintaining call scripting, and call routing flows in the telephony systemOversee the ServiceNow ticketing system, reporting, enhancements, and change management processesPartner with OBGM team members to review data and conduct root cause analysis and investigate data quality issues to determine best practices for simplifying and streamlining processes and systemsDesign and spearhead cross-functional projects to implement business solutions for Central Office and school customersIdentify opportunities and implement solutions for the improvement of content delivery to OBGM staff, principals, and school staff across the organizationAssist the Director of Training & Quality with the development of standard operating proceduresPartner with CPS departments to support internal staff and external stakeholder mass communications through various mediums such as data mail mergesEnsure data quality and integrity across OfficesWork with approved enterprise analytic tool sets. (SAS, SQL)Support analytic project planning, design and implementation across a variety of topic areasCompile, manipulate, and analyze data using appropriate statistical techniquesCommunicate with a broad spectrum of stakeholders at varying levelsParticipate in District's Data Analyst User GroupPerform other duties as assignedIn order to be successful and achieve the above responsibilities, the Data Analyst must possess the following qualifications:
Education Required:
Bachelor's degree from an accredited college or universityExperience Required:
A minimum of two (2) years of professional experience in a relevant field and a role requiring data analysis skills is requiredExperience with Google suite applications such as Sheets, Docs, LookerStudio and coding App Scripts is requiredExperience with MS Office, in particular, MS Excel and macros, MS PowerPoint, and/or other presentation software is requiredExperience writing code with data analytic tools (SAS, R, SPSS, STATA, etc) is requiredExperience drafting ad hoc surveys, programming content into online survey platforms (Alchemer, Survey Monkey, Qualtrics, etc.), and presenting findings to stakeholders is preferredOther Requirements:
Adhere to a set of guiding principles for analytic practice as established by the Data Governance CouncilKnowledge, Skills, and Abilities:
Ability to use or learn SAS requiredExceptional organizational, communication (oral and written), and, database management, analytical, and problem-solving skillsStrong attention to detail and data quality assuranceAbility to deliver high-quality results in a fast-paced environment, respond immediately to multiple constituencies and meet established deadlinesAble to lead independently under general guidance and as part of a teamAbility to establish priorities and manage multiple activities while meeting established deadlinesAbility to build collaborative relationships with a variety of constituent groups, including external partners, to ensure the entire system operates in the most effective manner possible to support schools and principalsFlexibility to meet changing departmental needs and prioritiesAbility to work on multiple projects simultaneouslyAdheres to a high level of professionalism at all times across professional interactions (e.g.- meets deadlines, is responsive to communications and requests, etc.)Ability to define problems, analyze data, and outline valid conclusions and action stepsVery strong communication skills (speaking, listening, and writing).Ability to use available tools such as ServiceNow (customer ticketing system), Nice In-Contact (call center/telecom management systems) - ability to adapt quickly when new tools and systems are deployedConditions of Employment
As a condition of employment with the Chicago Public Schools (CPS), employees are required to:
Establish/Maintain Chicago Residency -
Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.Be Fully Vaccinated Against COVID-19 -
Unless approved for a medical or religious exemption, all employees are required to be up-to-date on COVID-19 vaccinations, including boosters, and to submit proof of vaccination to the district within 30 days of hire. "Up-to-date" on vaccination is defined as being at least two weeks past all primary vaccine doses and any applicable boosters.
The Office of Budget and Grants Management (OBGM) supports the strategic utilization of all resources, aligning them to district priorities by spearheading CPS' financial strategy to support effective budget planning and maximizing available funds.
Job Summary:
Reporting to the Director of Training & Quality, the Data Analyst will support the School Resource Strategy (SRS) team within OBGM with creation of reports and budget tracking tools and metrics used in assisting school Principals and Network Chiefs in evaluating budgets, formulating strategic priorities, and maximizing resources. The Data Analyst will also be responsible for analyzing complex data sets and to identify opportunities to simplify and refine business systems and processes through the development of reports.
The Data Analyst will be held accountable for the following responsibilities:
Work closely with the Director of Training & Quality to manage the performance of OBGM, including strategic planning, creating performance metrics, and goal settingWork in the Oracle system to pull and analyze budget and financial data setsAssist with gathering requirements for the development of and updates to the Business Intelligence dashboard and School Budget Overview reportsDevelop, prepare, and review operations and school reports to gain insight into business drivers, efficiencies, and data accuraciesDesign, enhance, and report performance management dashboards, employee scorecards, and reports on a weekly and monthly basisOversee service delivery data (call and ticket performance metrics) for all call center functions, anticipating customer needs, actively monitoring and reporting on customer feedback and concerns to Central Office leadershipTrack satisfaction among customers through various tools including ServiceNow and provide comprehensive reporting for the Office of Budget and Grants ManagementSupport inbound call traffic monitoring, maintaining call scripting, and call routing flows in the telephony systemOversee the ServiceNow ticketing system, reporting, enhancements, and change management processesPartner with OBGM team members to review data and conduct root cause analysis and investigate data quality issues to determine best practices for simplifying and streamlining processes and systemsDesign and spearhead cross-functional projects to implement business solutions for Central Office and school customersIdentify opportunities and implement solutions for the improvement of content delivery to OBGM staff, principals, and school staff across the organizationAssist the Director of Training & Quality with the development of standard operating proceduresPartner with CPS departments to support internal staff and external stakeholder mass communications through various mediums such as data mail mergesEnsure data quality and integrity across OfficesWork with approved enterprise analytic tool sets. (SAS, SQL)Support analytic project planning, design and implementation across a variety of topic areasCompile, manipulate, and analyze data using appropriate statistical techniquesCommunicate with a broad spectrum of stakeholders at varying levelsParticipate in District's Data Analyst User GroupPerform other duties as assignedIn order to be successful and achieve the above responsibilities, the Data Analyst must possess the following qualifications:
Education Required:
Bachelor's degree from an accredited college or universityExperience Required:
A minimum of two (2) years of professional experience in a relevant field and a role requiring data analysis skills is requiredExperience with Google suite applications such as Sheets, Docs, LookerStudio and coding App Scripts is requiredExperience with MS Office, in particular, MS Excel and macros, MS PowerPoint, and/or other presentation software is requiredExperience writing code with data analytic tools (SAS, R, SPSS, STATA, etc) is requiredExperience drafting ad hoc surveys, programming content into online survey platforms (Alchemer, Survey Monkey, Qualtrics, etc.), and presenting findings to stakeholders is preferredOther Requirements:
Adhere to a set of guiding principles for analytic practice as established by the Data Governance CouncilKnowledge, Skills, and Abilities:
Ability to use or learn SAS requiredExceptional organizational, communication (oral and written), and, database management, analytical, and problem-solving skillsStrong attention to detail and data quality assuranceAbility to deliver high-quality results in a fast-paced environment, respond immediately to multiple constituencies and meet established deadlinesAble to lead independently under general guidance and as part of a teamAbility to establish priorities and manage multiple activities while meeting established deadlinesAbility to build collaborative relationships with a variety of constituent groups, including external partners, to ensure the entire system operates in the most effective manner possible to support schools and principalsFlexibility to meet changing departmental needs and prioritiesAbility to work on multiple projects simultaneouslyAdheres to a high level of professionalism at all times across professional interactions (e.g.- meets deadlines, is responsive to communications and requests, etc.)Ability to define problems, analyze data, and outline valid conclusions and action stepsVery strong communication skills (speaking, listening, and writing).Ability to use available tools such as ServiceNow (customer ticketing system), Nice In-Contact (call center/telecom management systems) - ability to adapt quickly when new tools and systems are deployedConditions of Employment
As a condition of employment with the Chicago Public Schools (CPS), employees are required to:
Establish/Maintain Chicago Residency -
Employees are required to live within the geographic boundaries of the City of Chicago within six months of their CPS hire date and maintain residency throughout their employment with the district. The Chicago residency requirement does not apply to temporary/part-time positions, however, all CPS employees must be residents of Illinois.Be Fully Vaccinated Against COVID-19 -
Unless approved for a medical or religious exemption, all employees are required to be up-to-date on COVID-19 vaccinations, including boosters, and to submit proof of vaccination to the district within 30 days of hire. "Up-to-date" on vaccination is defined as being at least two weeks past all primary vaccine doses and any applicable boosters.