ASSISTANT BUDGET DIRECTOR

About the role

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.

Responsibilities

• 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.
• Collaborates with staff 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.
• Prepares reports and presentations on budgetary matters for senior management, elected officials, and other stakeholders.
• Manages special projects related to the City's budget or financial management, such as developing new policies or procedures.
• 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 Key Performance Indicators (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.
• Makes presentations to senior leadership, program managers, and external stakeholders to discuss budgetary matters related to proposed projects.

Qualifications

• 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.

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

Benefits

For Information on our employees benefits please visit our benefits website at: https://www.chicago.gov/content/dam/city/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