Senior Program Analyst: Data & Performance

City of Chicago; Chicago (IL); In loco; USD 68.000 - 83.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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

Mansioni

• 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

Conoscenze

Project management

Data analysis

Excel advanced

Python pandas

R programming

Data visualization

Dashboard tools

SQL

GIS

Salesforce

Formazione

Bachelor's degree

Associate degree

Master's degree

Strumenti

Python

R

Excel/VBA

Power BI

Tableau

SQL

Salesforce

GIS

AgingIS

ECM

TCare

Descrizione del lavoro

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.