ASSISTANT BUDGET DIRECTOR

JOB ANNOUNCEMENT

Assistant Budget Director

Office of Budget and Management

Data and Performance Analytics Unit

Number of Positions: 1

(Additional vacancies possible pending budget approval)

Salary Range: $125,316.00 to $141,660.00 annually

Applications for this position will be accepted until 11:59 pm CDT on July 23, 2026.

The Assistant Budget Director - Data Analytics is responsible for analyzing data related to the City's capital and grant budgets, providing recommendations that support effective resource management and compliance, and developing data dashboards and models for the effective tracking and monitoring of the grants and capital budget portfolio for the Capital Planning and Grants Management Unit.

ESSENTIAL DUTIES

• Works with grants and capital expenditure data to identify patterns, trends, and anomalies using statistical methods, data visualization tools, and other analytical techniques across fund types including GO bonds, TIF funds, and federal grants.

• Tracks actual expenditures against budgeted amounts and award balances, identifies issues such as lapsing funds or compliance gaps, and recommends corrective action in coordination with operating departments and grantor agencies.

• Prepares reports on grants and capital matters for senior management and department heads using platforms including, but not limited to, Tableau by Salesforce, Microsoft Power BI, ESRI ArcGIS, Microsoft Excel, and Microsoft Access.

• Participates in the development and revision of policies and procedures to ensure the City's fiscal and budgetary goals are met.

• Consults with staff on complex budget estimates and related reports.

• Coordinates and participates in conducting staff training on budgeting and fiscal policies and procedures.

• Oversees the preparation and maintenance of budget, operations, and administrative reports.

• Coordinates and oversees special budget and organizational studies.

• Works with large sets of data to identify patterns, trends, and anomalies. This may involve using statistical models, data visualization tools, and other techniques to analyze budgetary data and identify opportunities for improvement.

• Monitors actual spending against budgeted amounts, identifies potential issues or discrepancies, and recommends corrective action based on data analysis.

• Prepares reports and presentations on budgetary matters for senior management, elected officials, and other stakeholders. These reports may include visualizations of budget data and other key metrics. These reports will be created using modern analytics platforms, such as Tableau or Power BI.

• Manages special projects related to the City's budget or financial management, such as developing new policies or procedures. These projects may involve collecting and analyzing data to inform decision-making.

• Assists in the development of the City's annual budget, including analyzing budget submissions from departments and identifying areas where data can inform budgetary decisions.

• Ensures the City's budget is effectively managed and allocated to support its goals and priorities using data analytics.

• Oversees the creation and maintenance of data visualizations and analysis for budget publications.

• Researches techniques, methods, and processes to obtain information on specific areas under review.

• Extracts data from various sources, transforms it into usable formats, and loads it into data warehouses or analytics platforms.

• Develops and oversees the maintenance of dashboards used to collect and report on information gathered.

• Conducts in-depth data analysis using statistical tools to identify trends, measure performance, and support decision-making.

• Designs and builds interactive dashboards and visualizations to communicate findings and monitor KPIs.

• Helps develop and implement revised workflows, performance metrics, and procedural standards; monitors impact and adjusts as needed.

• Acts as a hands-on creator, designs and maintains reports and dashboards for City-wide studies.

• Meets with managers to identify the scope of problems and define the objectives of studies. Develops work plans and data collection processes for achieving study objectives.

• Exhibits technical expertise, capable of developing automated processes and complex flows to build front-end analytics.

• Interfaces with senior leadership, program managers, and external stakeholders to identify, evaluate and define opportunities for improved efficiency, cost-savings and process improvements.

• Designs clear, useful, and accessible visualizations that evaluate complex systems, pulling out needed information for decision makers.

• Works in coordination with managers and IT staff across city departments to establish access and connections to data management and enterprise systems throughout the city.

• Constructs complex mathematical models and use computer applications to evaluate data.

• Develops and presents new or revised processes, procedures, and work standards to managers.

• In coordination with subject matter experts, establishes key performance indicators and benchmarks for tracking and monitoring through advanced analytics.

• Works with managers and consultants in program implementation.

• Designs computer applications to automate manual processes, as required.

• Defines specifications for consultants responsible for designing programs that will replace manual operations.

• Facilitates training for staff to ensure successful use and adoption of data analytics reporting.

• Coordinates, assigns, and reviews the work of professional staff engaged in evaluating departments' annual budget requests and operations.

• Participates in the development and revision of policies and procedures to ensure the city's fiscal and budgetary goals are met.

• Participates in the development and implementation of work methods and standards for analyzing departments' budget requests.

• Interprets and explains complex budgetary policies and city-wide fiscal objectives to staff.

• Coordinates and participates in conducting staff training on budgeting and fiscal policies, and procedures.

• Completes performance appraisals for subordinate staff.

• Oversees and participates in the preparation and maintenance of budget, operations, and administrative reports.

• Coordinates and oversees special budget and organizational studies.

• Serves as liaison with operating departments, grantor agencies, and private companies to discuss budgetary matters related to proposed projects.

Additional duties may be required for this position.

Location: 121 N. LaSalle St., Room 604, Chicago, IL 60602

Days: Monday through Friday

Hours: 9:00 AM to 5:00 PM

THIS POSITION IS EXEMPT FROM THE CAREER SERVICE

Graduation from an accredited college or university with a bachelor's degree in business administration, public administration, public policy, political science, finance, economics, or a directly related field, plus five (5) years of budgetary, financial analysis, legislative analysis, program evaluation or program management work experience,

OR

graduation from an accredited college or university with a master's degree or higher in business administration, public administration, public policy, political science, finance, economics, or a directly related field, plus four (4) years of budgetary, financial analysis, legislative analysis, program evaluation or program management work experience.

Desired Skills

* Experience with Extract, Transform, Load (ETL), processes and data cleaning

* Experience with data analytics, data visualization, and creating reports

* Experience with Excel, Tableau, Power BI, and other data analytics tools

* Strong problem-solving and critical thinking skills

* Clear written and verbal communication skills

SELECTION REQUIREMENTS

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

For Information on our employees benefits please visit our benefits website at:

https://www.chicago.gov/city/en/depts/fin/benefits-office.html

For Information on our salary and title structure visit our classifications website at:

https://www.chicago.gov/content/dam/city/depts/dhr/supp_info/JobClassification/2025_Classification_and_Pay_Plan.pdf

APPLICATION EVALUATION: Initial evaluation will be based on information provided on the application and the documents submitted. Department of Human Resource staff will review applications after the final posting date. Staff will follow any and 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 the following ordinances 2-74-020 and 2-74-075. The ordinances provide a preference to applicants who meet minimum qualifications and who are veterans of the Armed Forces, and/or residents of Socio-Economically Disadvantaged Areas (SEDA) and/or Chicago Public School (CPS) high school graduates to be referred to departments for consideration. These hiring preferences do not apply to bidders, as Collective Bargaining Agreements define the hiring process for bidders. For positions covered by a collective bargaining agreement, bidders will be considered before external candidates. To learn more about our hiring practices click here.

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

The City of Chicago is an Equal Employment Opportunity, Military Friendly, and Fair Chance Employer.

City of Chicago

Brandon Johnson, Mayor