Opioid Settlement Funds Performance & Data Analyst
Job Description
Advance performance measurement that helps Salt Lake County plan, track, and improve efforts tied to the Opioid Settlement Fund (OSF). This onsite role within Human Services combines program administration, analytics, and stakeholder coordination to support a five-year, data-informed approach to reduce opioid misuse, overdoses, and overdose deaths.
You will design and maintain performance data products, collaborate with IT on data collection and management using approved County platforms and standards, and help analyze how OSF projects and funding affect outcomes for the opioid epidemic and the broader community. Your work will inform policy makers through performance-based budgeting and clear reporting for both internal management and public-facing needs.
Responsibilities
- Drive performance management goals and metrics, partnering with Information Technology (IT) to design and support data collection and management solutions using approved County platforms and standards.
- Conduct quantitative and qualitative research to support OSF planning and measurement.
- Ensure all data access, handling, and reporting comply with County IT policies, security standards, and applicable federal and state regulations.
- Serve as a flexible, departmentwide resource on the Human Services executive team, working across divisions and County departments to implement the OSF Plan.
- Blend program administration, data analytics, stakeholder coordination, and contract management to support high-impact, evidence-based initiatives.
- Analyze how OSF projects and dollars impact opioid outcomes and the broader community.
- Develop metrics and visualizations that inform policy makers, including performance-based budgeting.
- Design, develop, and maintain data products such as reports, dashboards, visualizations, presentations, and data narratives aligned with County data standards and approved analytics platforms.
- Collaborate with IT to design and enhance data solutions, analytical tools, and reporting infrastructure.
- Collect, manage, analyze, interpret, and report performance and operational data within IT data access controls and governance processes.
- Provide training, technical assistance, and feedback on data tools, analytic methods, and reporting standards consistent with County-approved practices.
- Advise on data collection best practices, including survey design, data quality standards, and appropriate use of administrative and external public data sources aligned with County governance standards.
- Identify and lead data-focused research, analytic pilots, and short-term projects to improve measurement, insight generation, and decision support.
- Research and evaluate national best practices, analytic methodologies, and emerging data technologies related to performance measurement and analytics.
- Contribute to and implement data management, data sharing, and data quality policies and procedures in alignment with County data governance standards.
- Support agency data governance and privacy initiatives, promoting consistent compliance with applicable federal and state laws and County policies, including CJIS and other criminal justice data requirements in coordination with IT Security and Compliance teams.
- May supervise staff engaged in data analytics, reporting, or data governance functions.
Requirements
- Bachelor’s degree from an accredited college or university in Data Analytics, Information Science, Economics, Sociology, Business Administration, Public Administration, Public Policy, or related field plus four (4) years of related experience; or an equivalent combination of related education and experience.
- Must pass a required background check through fingerprinting and enrollment in the continuous RAP Back program in accordance with current County Human Resources policy requirements.
- Knowledge of quantitative and qualitative research methods.
- Knowledge of data visualization tools.
- Knowledge of data programming languages/tools.
- Knowledge of SQL and relational database.
- Knowledge of database extraction, data cleaning, data wrangling, and basic data analysis.
- Knowledge of advanced features and formulas in Excel or Smartsheet.
- Knowledge of data sharing, security, privacy, and related regulations.
- Knowledge of project management methods and tools.
- Knowledge of personnel supervision, management, and development.
- Knowledge of data security frameworks and regulatory compliance (e.g., CJIS, HIPAA).
Technologies
- SQL
- Excel
- Smartsheet
- CJIS
- HIPAA
- Artificial Intelligence
Benefits
- 12 Holidays
- Up to 24 vacation days
- 12 sick days
- One personal day every year
- Retirement options for hybrid pension/401(k) or 401(k) only with a 10% contribution
- Medical coverage including a 100% county paid premium option
- Dental and Vision coverage including coverage for adult designees
- Health Savings account with a county contribution up to $1200/year
- Flexible Spending Account
- 100% county-paid Long-Term Disability and Short-Term Disability option
- Professional Development including professional membership fees paid
- Tuition Reimbursement
- Onsite medical clinic and gym; pet insurance and auto and home insurance options; discounts at County facilities
Working Conditions
Work duties are typically performed in a general office setting, sitting or standing for long periods of time at a computer.
Additional Position Information
- Hybrid schedule: Monday through Friday, 8:00 AM to 5:00 PM.
- There is a strong likelihood the role will be housed and managed at the executive level of the Human Services Department.
- The SLCo Health Department is in the Human Services portfolio, and this role will work closely with Health Department analysts.
The Salt Lake County Department of Human Services brings together seven service areas, operating at the intersection of public policy, direct service delivery, and community partnership. The department addresses complex, overlapping challenges including criminal justice involvement, substance misuse, mental health, and public health.