PROGRAM ANALYST

City of Chicago; Chicago (IL); On-site; USD 68,000 - 83,000; Full time

Job summary

City of Chicago is seeking a Program Analyst in the Seniors Division of the Department of Family and Support Services. The role involves researching, analyzing, and monitoring program efficiency, with emphasis on data-driven insights.

Strong skills in Python, R, Excel/VBA, and dashboard tools are essential to support leadership and staff. Starting salary is $75,336 per year, with a 4-year budget window for one vacancy.

Qualifications

• Bachelor's degree in Business Administration, Public Administration, Data Analytics, or related field plus 2 years of program evaluation experience
• Six years of program evaluation experience is acceptable in lieu of the degree
• Master's degree or higher in Business Administration, Public Administration, Data Analytics, or related field plus 1 year of program evaluation experience

Responsibilities

• Conducts in-depth research and analysis of program operations and funder requirements
• Gathers, evaluates, and interprets narrative and statistical data using Python, R, or Excel/VBA
• Designs and implements data analysis and reporting processes
• Identifies data sources, data gaps and meaningful metrics
• Organizes, formats, and analyzes large data sets using Excel and statistics when needed
• Assists with creating live dashboards and reports using GIS, Salesforce, Power BI, Tableau
• Communicates insights and facilitates performance discussions with staff and leaders
• Assists with creating reports and SQL queries in AgingIS
• Develops, maintains reports using Python and AgingIS, Salesforce, ECM, TCare
• Provides input on data systems and processes, including collection, storage, sharing and use
• Develops reusable Python, R, or VBA scripts to automate data processes
• Maintains technical documents and flow charts for systems and processes

Skills

Project management

Data analysis

Excel advanced

Python pandas

R programming

Data visualization

Dashboard tools

SQL

GIS

Salesforce

Education

Bachelor's degree

Associate degree

Master's degree

Tools

Python

R

Excel/VBA

Power BI

Tableau

SQL

Salesforce

GIS

AgingIS

ECM

TCare

Job description

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.

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

1615 West Chicago Avenue

Monday - Friday

9:00 AM - 5:00 PM

THIS POSITION IS IN THE CAREER SERVICE

Qualifications

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

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.

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

City of Chicago

Brandon Johnson, Mayor