Data Analyst

The City of Ammon offers an on site Data Analyst role in Ammon, Idaho, focused on turning data into actionable insight across City departments. You will collaborate on data analytics, reporting, business intelligence, and data integration initiatives, building dashboards, reports, data models, and analytical tools to support operational decisions, strategic and infrastructure planning, growth forecasting, and service delivery. The position is onsite with a compensation range of USD 27 to 40 per hour and a strong emphasis on cross‑department teamwork.

Responsibilities

• Gather and curate data from multiple City departments, internal systems, and external sources; validate and clean data to maintain quality.
• Support the creation and upkeep of dashboards, reports, scorecards, and visualizations using Power BI and related BI tools.
• Develop, modify, and run SQL queries to extract, transform, validate, and analyze data.
• Assist with integrating data from finance, utility, permitting, infrastructure, operations, and GIS sources.
• Help establish and maintain repeatable data preparation, transformation, and reporting workflows.
• Document data sources, definitions, metadata, refresh schedules, business rules, and validation procedures.
• Ensure accuracy, completeness, and consistency of datasets used in reports, dashboards, and analyses.
• Support GIS data preparation, analysis, mapping, and integration with BI platforms.
• Conduct basic statistical, operational, and trend analyses to identify patterns, issues, and opportunities.
• Contribute to long range planning efforts including growth forecasting, infrastructure planning, service demand analysis, and performance measurement projects.
• Prepare reports, summaries, charts, graphs, dashboards, and presentations to support management decisions.
• Help establish practical approaches for using AI assisted tools with City data, prioritizing data integrity, privacy, security, human review, and improved analytics.
• Collaborate with City staff to enhance data quality, reporting capabilities, and information accessibility.
• Attend meetings with City departments, consultants, academic partners, and external organizations as assigned.
• Maintain confidentiality of sensitive and protected information.
• Perform duties in alignment with City policies, procedures, and applicable laws.
• Build and maintain positive working relationships with City officials, employees, consultants, and the public.
• Other duties as assigned.

Requirements

• On site work is required; routine remote work is not available.
• Strong technical aptitude, analytical thinking, and attention to detail with the ability to explain information to both technical and non technical audiences.
• Proficiency with SQL: writing, modifying, and executing queries to extract, transform, validate, and analyze data.
• Experience with Power BI and related business intelligence tools for dashboards, reports, scorecards, and visualizations.
• Experience integrating data from finance, utility, permitting, infrastructure, operational, and GIS systems.
• Ability to document data sources, data definitions, metadata, refresh schedules, business rules, and validation procedures.
• Ability to verify data accuracy, completeness, and consistency in reports, dashboards, and analyses.
• Experience with GIS related data preparation, analysis, mapping, and integration with BI platforms.
• Ability to perform basic statistical, operational, and trend analyses.
• Experience contributing to long range planning initiatives such as growth forecasting, infrastructure planning, service demand analysis, and performance measurement projects.
• Ability to prepare reports, summaries, charts, graphs, dashboards, and presentations for management decision making.
• Willingness to support AI assisted tools with data governance, emphasizing data integrity, privacy, security, human review, and better decision making.
• Ability to collaborate with City staff to improve data quality, reporting capabilities, and information accessibility.
• Willingness to participate in meetings with City departments, consultants, academic partners, and external organizations.
• Commitment to maintaining the confidentiality of sensitive information.
• Ability to perform duties in line with City policies, procedures, and applicable laws.
• Ability to develop and maintain positive working relationships with City officials, employees, consultants, and the public.
• Flexibility to perform other duties as assigned.
• Some local travel may be required.
• Valid Idaho driver’s license and proof of valid insurance.
• Technologies used in this role include Power BI, SQL, and GIS.