IT Data Analyst

City of Streamboat Strings•Steamboat Springs, CO

1d•$73,585 - $106,698•Onsite

About The Position

The IT Data Analyst advances the city’s data‑driven decision‑making by partnering with departments to build a clear understanding of their data assets, develop high‑quality reporting and analytics, and strengthen data stewardship and governance practices. This role inventories data sources and reporting tools, designs and builds standardized reports and dashboards, and partners with data owners to improve collection methods, automate pipelines, and strengthen data quality and accessibility. When joining the City of Steamboat Springs, you can expect to work for an organization with: A team that strives to make this the best place you’ve ever worked! A focus on supporting our employees’ mental, physical, and financial well-being A commitment to diversity, equity, and inclusion that creates a welcoming city A highly engaged workforce proudly serving our community with excellence and distinction A passion for strategically providing outstanding municipal services A promise to each other to support the work we all do for the city, community & Yampa Valley Uniqueness Fuels Our Innovative Spirit Our commitment to inclusion across race, gender, age, religion, identity and experiences drives us forward every day. It's the collective sum of our experiences that makes Steamboat Springs and the Yampa Valley a powerful, insightful and welcoming community. The City of Steamboat Springs is hiring an IT Data Analyst to join their team!

Requirements

Bachelor’s degree in Data Science, Statistics, Computer Science, Information Systems, or a related field; or an equivalent combination of education and experience.
Five (5) or more years of professional experience in data analytics, business intelligence, or reporting in a multi‑system, multi‑department environment; public‑sector experience preferred.
Experience with system integrations, data conversion and migration, and advanced, custom report development in enterprise systems; Workday experience preferred.
Excellent written, verbal, and presentation skills; ability to translate complex analysis into clear, actionable insights for diverse audiences.
Strong organization, prioritization, and problem‑solving skills; ability to manage multiple requests and deadlines in a dynamic environment.
Advanced proficiency with SQL Server and relational databases.
Demonstrated expertise with data modeling and enterprise reporting tools (Power BI and SSRS preferred).
Experience with ETL tools (SSIS, Power Query) and scripting languages (PowerShell, Python, R).
Working knowledge of data governance, classification, and quality assurance best practices.
Understanding of accessibility principles for data presentation and dashboard design.

Nice To Haves

public‑sector experience preferred
Workday experience preferred
Power BI and SSRS preferred

Responsibilities

Serves as an ambassador of the City of Steamboat Springs and upholds City values of Service, Teamwork, Integrity, Well-being, Respect and Compassion, while prioritizing safety at all times.
Collaborates with departments to understand their data and priorities, assess needs and gaps, and develop effective datasets for analysis and reporting.
Facilitates discovery sessions and elicits requirements from business stakeholders, converting them into clear specifications to guide data analysis and reporting development.
Provides training and support for staff on how to navigate and update reports and dashboards.
Translates technical concepts for nontechnical audiences, improving data literacy and reporting adoption across the organization.
Cleanses, analyzes, and interprets raw data to provide meaningful findings that inform operational and strategic decisions.
Builds and maintains secure, reliable data pipelines and integrations (e.g., APIs, ETL, SFTP) to optimize collection, transformation, and delivery of datasets across systems.
Develops automated processes to keep key datasets accurate and up to date.
Supports efforts to streamline workflows and consolidate reporting platforms where feasible.
Leads migration or archival of historical datasets to modern platforms, including mapping, cleansing, testing, and cutover planning.
Designs, builds, and maintains dashboards and reports that surface actionable insights, using tools such as Power BI and SSRS.
Responds to ad hoc data requests by delivering timely, accurate analysis tailored to the needs of the stakeholders.
Creates advanced, custom reporting in Workday, delivering cross-functional analytics to support the city’s financial and human capital management needs.
Serves as the technical system owner for the city’s strategy management solution, supporting the development, maintenance, and publication of strategic and operational performance metrics for both internal users and public‑facing dashboards.
Develops and maintains an inventory of data assets, including source systems, ownership, refresh cadences, and reporting tools, based on insights gathered through departmental collaboration.
Works closely with departments to support: Improving data quality, consistency, and reliability. Standardizing data definitions, naming conventions, and business rules. Implementing classification, retention, and risk management best practices.
Contributes to policies and standards for data governance, validation, and accessibility to ensure reliable, secure, and compliant reporting.
Participates in after-hours work as needed for data refreshes, upgrades, outages, and emergency response.
Performs other duties and special projects as assigned.