Larimer County Department of Human Services is seeking a Data Analyst to extract insight from data to improve business and program outcomes, and provide business intelligence insights to support organizational decision-making.
Requirements
- Experience with SQL, Python, R, Tableau, Business Objects, or related tools.
- Knowledge of databases such as Oracle, SQL Server, SAP HANA, or Google BigQuery.
- Experience developing and maintaining ETL processes using SSIS.
- Familiarity with human services programs such as child welfare, adult services, and public benefits.
- Experience with state systems such as TRAILS or CBMS.
- Strong experience designing and executing data collection, extraction, and analysis methodologies that support organizational decision-making.
- Experience with data visualization tools
Responsibilities
- Managing data collection, analysis, visualization, and communication of insights to support organizational decision-making and strengthen program outcomes.
- Partnering with department units to surface new data needs and opportunities that inform strategy; providing support and training to ensure teams can use existing reporting tools effectively.
- Working with stakeholders to define outcome measures and performance indicators, and delivering accurate, timely data across Larimer County.
- Preparing data for analytics—extracting, integrating, and consolidating datasets; ensuring data quality; profiling inaccuracies; recommending process or system improvements; and creating clean, final analytic datasets.
- Developing, enhancing, and maintaining reports and dashboards using tools such as Tableau and Crystal Reports.
- Writing complex SQL queries and stored procedures to support analysis, quality control, data integrity, and reporting.
- Managing data quality and integrity
Other
- Clear, concise communication—written and verbal—with technical and non-technical audiences.
- Skill in presenting analytical findings in an engaging, easy-to-understand way.
- Strong relationship-building skills to work effectively with County staff, partner agencies, and the community.
- Commitment to public service and the Larimer County community.
- Ability to work independently and collaboratively, with strong attention to detail
