Children and Family Benefits Unit Data Analyst - Grant Funded
Chicago, IL

Job Description

Description

The Chicago Public Schools (CPS) has set ambitious goals to ensure that every child-in every school and every neighborhood-has access to a world-class learning experience from birth, resulting in graduation from high school and college.

The Office of Student Health and Wellness aims to remove health-related barriers to learning so that students may succeed in college, career and life.

The Children and Family Benefits Unit Data Analyst will be responsible for turning data into information, information into insight and insight into decisions that will help build efficiencies in CPS's school based Medicaid and CHIP enrollment processes. This position will be responsible for conducting full data analytic activities related to tracking student enrollment into the Medicaid, CHIP and other poverty grant programs by designing and assisting in the development of data analysis processes and reporting capabilities. They will be responsible for continuously monitoring performance and quality control plans to identify improvements and increases in revenue from CPS's Medicaid Reimbursement processes and CPS's poverty counts. The CFBU Data Specialist will be responsible for assisting the CFBU to develop target reports for outreach and enrollment as well as assisting the CFBU Manager in developing robust reports that speak to student under enrollment in Medicaid and CHIP as well as potential revenue gains and losses due to under-enrollment. Funding for grant scheduled to end June 30, 2019

Roles and Responsibilities:

* Interpret data, analyze results using statistical techniques and provide ongoing reports.
* Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality.
* Acquire data from primary or secondary data sources and maintain databases/data systems.
* Identify, analyze, and interpret trends or patterns in complex data sets.
* Filter and "clean" data, and review computer reports, printouts, and performance indicators to locate and correct code problems.
* Work closely with management to prioritize business and information needs.
* Locate and define new process improvement opportunities.
* Work with CFBU staff and Community Based Organizations to set up logistics for enrollment events which includes setting up logistics of event, sending out letters and setting up appointments centrally for the event.
* Provide administrative support to the CFBU Manager, Project Manager and Regional Specialists including but not limited to developing ad hoc student under enrollment reports, working with Illinois Department of Healthcare and Family Services to ensure data received is accurate, serve as lead on CFBU's data needs and other duties as assigned.

In order to be successful and achieve the above responsibilities, the CFBU Coordinator must possess the following qualifications:

Type of Education Required:

High school diploma required; Bachelor's or Master's Degree preferred in Policy Analysis, Business, Information Management or Statistics.

Type of Experience:

* Minimum two years' experience in an analytic role.


* Technical expertise regarding data models, database design development, data mining and segmentation techniques.


* Strong knowledge of and experience with data manipulation and programming environments including databases (SQL, etc.), general programming (Macros, Python, other ETL frameworks).


* Knowledge of statistics and experience using statistical packages for analyzing large datasets (SAS strongly preferred).


* Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.


* Adept at generating queries, writing reports, creating visualizations, and presenting findings.


* Proficiency in PC skills: Word, Excel, Access.


* Must be flexible, willing to travel locally.


* Able to work in team setting.


* Community organizing background preferred.



Knowledge, Skills, and Abilities:

* Ability to communicate effectively, both verbally and in writing with all stakeholders.


* Ability to use a range of technology and tools, including but not limited to IMPACT, Microsoft Office, and Google.


* Ability to work independently as well as to function effectively and collaboratively in a team environment.


* Excellent organizational skills and ability to effectively multi-task.



Additional Notes:

* CPS employees are required to be actual residents of the City of Chicago within six months of beginning employment, and are required to maintain Chicago residency throughout employment.


* Chicago Public Schools is an EEO/AA Employer. All qualified individuals, including minorities, females, veterans, and individuals with disabilities, are encouraged to apply. Healthy CPS - Office of Student Health & Wellness



Residency Requirement:

As a condition of employment with the Chicago Public Schools (CPS), employees are required to live within the geographic boundaries of the City of Chicago within six months of his or her CPS hire date and maintain residency throughout their employment with the district.

'212422