Information Technology Services (ITS) is a team of dedicated professionals providing core technology and cybersecurity services to agencies statewide, enabling state employees to better serve Idaho's citizens. We sincerely hope you will consider being a part of Information Technology Services’ success.
ITS currently has an opening for a Data Analyst to join the Data Team at ITS.
The position will report to Idaho’s Data Analytics Manager/ Geographic Information Officer at ITS and support a variety of efforts underway to streamline, visualize and analyze data inside ITS, support other state agencies with their data needs and implement a vision where data is managed, governed and leveraged throughout the state to make data-driven decisions.
We are seeking a data professional with strong SQL and Python skills to develop scalable ETL/ELT pipelines, build API integrations across enterprise systems, and automate workflows. Responsibilities include Snowflake and Tableau system administration overseeing user licensing, RBAC, and content governance. This position will also develop visualizations using out-of-the-box tools such as Tableau and Power BI and may at times need to customize visualizations using JavaScript.
The successful candidate will work with a team of data professionals on a large variety of projects and initiatives as well as data management, data governance and work towards a statewide enterprise approach to data. The selected individual will be working in a team environment under minimal supervision, with considerable latitude for the use of initiative and independent judgement.
Please note: The successful candidates will be required to pass multiple, comprehensive fingerprint-based background checks specific to the agencies ITS supports.
Examples of Duties:
- Work with other members of the Data Team to engage with state employees to conduct an inventory of existing data, data needs, data quality, and business cases tied to data for ITS and the State of Idaho.
- Participate in refining, implementing and automating data strategies, including master database design, improving data quality, data governance and data management.
- Write SQL scripts to build databases, schemas, tables and workflows in Snowflake Data warehouse.
- Build Streamlit apps using Python within the Snowflake environment.
- Write Python scripts to connect to various databases and APIs and automate data loads from various sources into Snowflake .
- Support ETL (Extract, Transform, Load) processes using SQL and Python as well as ETL tools in Tableau.
- Analyze data and develop reports, info-graphs and dashboards to visualize data for decision making, monitoring and communication. Create visualizations using Tableau and PowerBI, and complete custom web developme