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.

Under general supervision, the class researches, analyzes, and monitors the efficiency and effectiveness of programs and services relative to a department's operation.

• 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

DFSS Central Office

1615 West Chicago Avenue

Monday - Friday

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

• 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/Num Py) 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

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 .

The City of Chicago in an Equal Employment…