The Governor's Office of Information Technology (OIT) is seeking a Senior Data Analyst to leverage data for strategic business decisions within Colorado's State Longitudinal Data System Grant Program (SLDS). The goal is to improve business outcomes through advanced analytics and data-driven insights.
Requirements
- A minimum of five (5) years working experience as a Data Analyst in the public sector of either education or workforce development, with significant expertise in using Snowflake, Python, SQL, R, and Tableau.
- A minimum of three (3) years of experience developing dashboards using data reporting tools (Tableau - preferred, Power BI, R Shiny or PyShiny).
- Deep understanding of applied research methods, specifically program evaluation and quantitative data analysis of longitudinal public sector data.
- At least 5 years experience working with education and/or workforce data.
- Experience in conducting descriptive, diagnostic, and predictive data analysis in the public sector.
- Strong understanding of data modeling, database management, SQL, and ETL processes in the public sector.
- Experience designing, building, implementing, and maintaining data and system integrations and data transformations utilizing Snowflake.
Responsibilities
- Developing and maintaining complex dashboards and reports using Tableau, visualizing data sourced from Snowflake and other data repositories.
- Designing and implementing data models within Snowflake to optimize data storage and retrieval for analytical purposes.
- Communicating complex data insights and analytical findings to technical and non-technical stakeholders effectively.
- Ensuring data quality and governance standards are met within the Snowflake environment.
- Utilizing Python and SQL to extract, transform, and load (ETL) within Snowflake for analysis.
- Working with resource managers and stakeholders to identify and integrate new data sources.
- Leading and participating in cross-functional teams to develop data-driven solutions.
Other
- Experience in the public sector of either education or workforce development.
- Experience working for a governmental organization.
- Familiarity with data governance frameworks and tools, including Informatica.
- Knowledge of other cloud platforms like AWS, GCP or Azure.
- The candidate selected for the position must relocate and reside in Colorado on the first day of their new position.
