JOB
General Purpose
The principal function of an employee in this position is to support the City's data analytics, reporting, business intelligence, and data integration initiatives through the collection, validation, analysis, visualization, and management of data from multiple City departments and systems. The position assists with the development of dashboards, reports, data models, and analytical tools that support operational decision-making, strategic planning, infrastructure planning, growth forecasting, and service delivery.
The Data Analyst performs professional-level analytical work involving data collection, preparation, validation, documentation, reporting, and visualization. The position works closely with City departments to improve data quality, accessibility, consistency, and usability across the organization. The work requires technical aptitude, analytical thinking, attention to detail, and the ability to communicate information effectively to both technical and non-technical audiences. Because the position regularly collaborates with City staff, accesses City systems and infrastructure, participates in meetings, and supports operational needs across multiple departments, the position is required to perform its duties on-site and is not eligible for routine remote work.
The position works under the general supervision of the City Administrator and may assist with a variety of projects related to data services, GIS integration, business intelligence, and operational analytics.
Supervision Received
Supervision Exercised
EXAMPLE OF DUTIES
Essential Duties and Responsibilities (Illustrative Only)
Collect, organize, validate, clean, and maintain data from multiple City departments, systems, and external sources.
Assist with the development and maintenance of dashboards, reports, scorecards, and data visualizations utilizing Power BI and related business intelligence tools.
Write, modify, and execute SQL queries to extract, transform, validate, and analyze data.
Support the integration of data from finance, utility, permitting, infrastructure, operational, and GIS systems.
Assist in the development and maintenance of repeatable data preparation, transformation, and reporting processes.
Document data sources, data definitions, metadata, refresh schedules, business rules, and validation procedures.
Verify the accuracy, completeness, and consistency of datasets used in reports, dashboards, and analytical projects.
Assist with GIS-related data preparation, analysis, mapping support, and integration with business intelligence platforms.
Perform basic statistical, operational, and trend analysis to identify patterns, issues, and opportunities.
Assist with long-range planning initiatives including growth forecasting, infrastructure planning, service demand analysis, and performance measurement projects.
Prepare reports, summaries, charts, graphs, dashboards, and presentations to support management decision-making.
Assist in developing practical and responsible approaches for using AI-assisted tools with approved City data, emphasizing data integrity, privacy, security, human review, improved analytics, and better decision-making.
Collaborate with City staff to improve data quality, reporting capabilities, and information accessibility.
Participate in meetings with City departments, consultants, academic partners, and external organizations as assigned.
Maintain confidentiality of sensitive and protected information.
Perform all duties in accordance with City policies, procedures, and applicable laws.
Develop and maintain positive working relationships with City officials, employees, consultants, and the public.
Perform other duties as assigned.
Peripheral Duties
Assist with special studies, research projects, and pilot analytics initiatives.
Support testing and implementation of new data systems, reporting tools, and business intelligence platforms.
Attend training, conferences, and professional development opportunities related to data analytics, business intelligence, GIS, and information management.
Provide analytical support to City departments as assigned.
Perform other duties consistent with the responsibilities of the position.
SUPPLEMENTAL INFORMATION
Work Environment
Position performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities, generally involving minor muscular strain, such as walking, standing, stooping, sitting, and reaching. Talking, hearing and seeing are necessary to perform essential functions. Rapid work speed required to perform keyboard operations. Common eye, hand, finger, dexterity required. Mental application utilizes memory for details, verbal instructions, emotional stability, critical thinking and some creative problem solving.
Travel Requirements
Disclaimer
Must perform the essential duties and responsibilities with or without reasonable accommodation efficiently and accurately without causing a significant safety threat to self or others. The above statements are intended to describe the general nature and level of work being assigned to this position. They are not intended to be construed as an exhaustive list of all responsibilities, duties and/or skills required of individuals in the job. This job description is not an employment agreement and/or an expressed or implied employment contract. Management has the exclusive right to alter this job description at any time without notice.
