PROGRAM ANALYST

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 #J-18808-Ljbffr City of Chicago