PROGRAM ANALYST

BID/JOB ANNOUNCEMENT

Program Analyst

Seniors Division

Department of Family and Support Services

Number of Positions: 1

(additional vacancies possible pending budget approval)

Starting Salary: $75,336.00/Year

Applications for this position will be accepted until 11:59pm CDT on 10/30/2026

This position is open to the public and all current City employees covered under the City's collective bargaining agreement with AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES (AFSCME) - BARGAINING UNIT 1, 3, 4 & 5. Only employees in City job titles in this bargaining unit are eligible to bid.

BID INSTRUCTIONS: Apply on the bid site: https://chicago.taleo.net/careersection/103/jobsearch.ftl?lang=en AND

1. Check the box on your profile titled "Currently employed by the City of Chicago"

2. Enter your employee ID (located on your pay stub labeled 'payee/employee number')

3. Select your correct bargaining unit

FAILURE TO FOLLOW THESE INSTRUCTIONS WILL RESULT IN A REJECTED BID APPLICATION

Description

Under general supervision, the class researches, analyzes, and monitors the efficiency and

effectiveness of programs and services relative to a department's operation.

Essential Duties

* Conducts in-depth research and analysis of program operations and funder requirements

* Gathers, evaluates, and interprets narrative and statistical data using tools like Python, R, or Excel/VBA

* Designs and implements data analysis and reporting processes

* Identifies appropriate data sources, current data gaps and collection methods, and meaningful metrics

* Organizes, formats, and analyzes large and complex data sets (using Excel and, when necessary, a statistical package)

* Assists with creating live dashboards and reports using tools such as GIS, Salesforce, Power BI, and Tableau

* Communicates insights and facilitates productive, performance-oriented discussions with staff across program and leadership teams

* Assists with creating reports and building SQL queries in AgingIS

* Develops, modifies, maintains, and supports custom reports using Python and third-party platforms (AgingIS, Salesforce, ECM, TCare).

* Provides input on division and department-wide data systems and processes, including collection, storage, sharing, and use.

* Assists with data collection systems and write reusable Python, R, or VBA scripts to automate complex data processes

* Develops, refines, and maintains technical documents and flow charts for various systems, services and business processes including databases and reporting procedures

Performs related duties as assigned

Location: DFSS Central Office

Address: 1615 West Chicago Avenue

Days: Monday - Friday

Hours: 9:00 AM - 5:00 PM

THIS POSITION IS IN THE CAREER SERVICE

Graduation from an accredited college or university with a Bachelor's degree in Business Administration, Public Administration, Data Analytics, or a directly related field, plus two (2) years of program evaluation experience

Should the above criteria not be fulfilled, the following options are acceptable:

Six (6) years of program evaluation experience

Graduation from an accredited college with an Associate's degree in Business Administration, Public Administration or a directly related field, plus four (4) years of program evaluation experience

Graduation from an accredited college or university with a Master's degree or higher in Business Administration, Public Administration, Data Analytics, or a directly related field, plus one (1) year of program evaluation exp

Selection Criteria

This position requires applicants to complete an interview. The interviewed candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position, based on the oral part of the interview will be selected

Desired Skills:

• Previous experience with project management
• Previous experience with data analysis and data management
• Proficiency in Excel, including advanced formulas, pivot tables, Power Query, and VBA/macros
• Previous experience programming in Python (Pandas/NumPy) and/or R for data cleaning, analysis, and automation
• Previous experience with data visualization and dashboard tools
• Previous experience researching and interpreting both narrative and statistical data
• Previous experience in senior services, government, nonprofit, or human services settings

For information about City of Chicago employee benefits, please click here

For information about City of Chicago salaries and job titles, please click here

APPLICATION EVALUATION: Initial evaluation will be based on the information provided on the application and the documents submitted. Department of Human Resources staff will review applications after the final posting date. Staff will follow all required employment/hiring plan provisions, federal, state, and local laws, and collective bargaining agreements when applicable. Staff will apply hiring preferences as required by the municipal code. Placement on an eligibility list is not an offer or guarantee of an interview nor employment with the City of Chicago

COMMITMENT TO DIVERSITY: To further our commitment to hiring applicants with diverse experience, the City of Chicago has adopted ordinances 2-74-020 and 2-74-075. The ordinances provide a preference to applicants who meet the minimum qualifications and who are veterans of the Armed Forces of the United States, residents of Socio-Economically Disadvantaged Areas (SEDA), and/or Chicago Public School (CPS) high school graduates. These hiring preferences do not apply to bidders. For positions covered by a collective bargaining agreement, bidders will be considered before external candidates. The learn more about our hiring processes click here.

ALL REFERENCES TO POLITICAL SPONSORSHIP OR RECOMMENDATION MUST BE OMITTED FROM ANY AND ALL APPLICATION MATERIALS SUBMITTED FOR CITY EMPLOYMENT.

The City of Chicago in an Equal Employment Opportunity and Military Friendly Employer and Fair Chance Employer

City of Chicago

Brandon Johnson, Mayor