Join the City of Dubuque as a Data Analyst and help Public Works operations run on clear, reliable insight. In this onsite role, you will collect and interpret complex operational, financial, asset, infrastructure, geographic, and performance data to support planning, compliance, and continuous improvement. You will also build dashboards, reports, visualizations, models, and decision-support tools that help leadership and key stakeholders make confident, data-driven choices.
What you’ll do
- Gather, integrate, maintain, and analyze operational, financial, asset, geographic, regulatory, and infrastructure data from primary and secondary sources.
- Use appropriate statistical and analytical techniques to interpret results, identify trends and patterns, and deliver ongoing reporting and recommendations.
- Develop and maintain business intelligence reports, performance dashboards, data visualizations, and automated departmental reporting.
- Identify, develop, monitor, and report Key Performance Indicators and other measures of operational and organizational performance.
- Analyze departmental operations to support resource allocation, service delivery, budgeting, process improvement, and leadership decision making.
- Conduct analyses across budget, expenditures, workload, productivity, and operational performance.
- Support fleet management and capital planning by analyzing fleet utilization, equipment performance, maintenance, replacement, and lifecycle information.
- Build and improve departmental data governance practices, including data definitions, standards, ownership, quality, accessibility, and reporting consistency.
- Evaluate data quality by identifying duplicate, incomplete, inconsistent, or obsolete information and coordinating corrective actions.
- Support implementation, configuration, administration, and continuous improvement of Enterprise Asset Management and related departmental information systems.
- Develop and maintain asset inventories, asset hierarchies, condition information, data standards, and lifecycle information.
- Coordinate integration of Enterprise Asset Management, Geographic Information Systems (GIS), work management, financial, fleet, and other departmental systems.
- Create analytical tools and reporting to support preventive and predictive maintenance, infrastructure condition assessment, asset lifecycle management, and replacement planning.
- Analyze sanitary sewer and storm sewer system information, including Inflow and Infiltration (I&I), inspection, maintenance, condition, work history, and system performance data.
- Support regulatory reporting, compliance monitoring, documentation, and analysis tied to Public Works infrastructure and operations.
- Analyze infrastructure condition, risk, performance, and lifecycle data to inform capital improvement planning and prioritization.
- Collect information through observation, interviews, surveys, system records, field information, and other suitable methods.
- Conduct research and benchmarking related to Public Works operations, infrastructure management, technology, service delivery, and industry practices.
- Determine suitable analytical methods, presentation formats, visualizations, and reporting tools based on audience and decision needs.
- Prepare statistical and narrative reporting, recommendations, presentations, dashboards, maps, charts, graphs, and other analytical products for departmental and City leadership, City Council, regulatory agencies, and stakeholders.
- Collaborate with Public Works managers, supervisors, technical staff, administrative staff, other City departments, consultants, vendors, and external partners to identify information needs and develop analytical solutions.
- Provide analytical support for departmental strategic planning, budgeting, capital planning, performance management, technology implementation, and continuous improvement initiatives.
- Develop documentation, procedures, data dictionaries, reporting standards, and materials needed to maintain sustainable departmental data systems.
- Assist users in understanding and using departmental data, reports, dashboards, and analytical systems.
- Update knowledge on emerging technologies, analytical practices, asset management methods, and industry trends.
- Measure and report progress toward applicable City Council goals and priorities, departmental objectives, strategic plans, regulatory requirements, and adopted performance measures.
- Cross-train across operational and infrastructure analytical functions to maintain continuity, resiliency, and departmental coverage.
- Perform other duties as assigned.
What you bring
- Bachelor’s degree in Data Analytics, Business Analytics, Statistics, Mathematics, Economics, Finance, Accounting, Computer Science, Information Systems, Geography/GIS, Engineering, Public Administration, Business Administration, or a related field; OR an equivalent combination of education and progressively responsible experience.
- Experience collecting, organizing, analyzing, and presenting complex data.
- Experience using spreadsheets, databases, business intelligence, statistical, GIS, or comparable analytical tools.
Tools you’ll work with
- Spreadsheets, databases, business intelligence tools, and data visualization systems
- Enterprise Asset Management
- Geographic Information Systems (GIS)
- Work management systems
- Statistical tools
- Computerized Maintenance Management Systems
- Work-order management systems
Location, schedule, and salary
Dubuque, IA (onsite). Salary range: USD 72,841 - 95,208 per year.
Residency and employment status
- FLSA status: Exempt
- Supervisory status: None
- Residency requirement: Establish principal residence within 50 miles of the corporate limits of the City of Dubuque as soon as practicable after appointment, but within two years of appointment.
Physical requirements and work environment
Work is primarily performed in a standard office environment with frequent computer use and desk work. Assignments may require visits to Public Works facilities, infrastructure sites, field operations, construction or maintenance locations, and other City facilities to observe operations, understand business processes, validate information, or coordinate data and asset-management activities.
The role requires the ability to sit for extended periods; stand, walk, bend, reach, grasp, and perform repetitive motions; communicate effectively verbally and in writing; operate standard office equipment; and use computers, databases, analytical software, GIS, and related technology. It also requires the ability to review detailed information on computer screens and documents, with occasional lifting, carrying, pushing, or pulling of office materials and equipment.
It further requires the ability to analyze complex information; maintain accuracy and attention to detail; manage multiple assignments; exercise professional judgment; communicate technical information to technical and non-technical audiences; and maintain the confidentiality and integrity of departmental information.
