Data Analytics Associate (Roads to Recovery) – Department of Public Health and Environment

About Our Job

With competitive pay, great benefits, and endless opportunities, working for the City and County of Denver means seeing yourself working with purpose — for you, and those who benefit from your passion, skills and expertise. Join our diverse, inclusive and talented workforce of more than 11,000 team members who are at the heart of what makes Denver, Denver.

What We Offer

The City and County of Denver offers a competitive salary commensurate with education and experience. The salary range for this position is $65,523.00 - $108,113.00. We also offer generous benefits for full-time employees which include but are not limited to:

• A guaranteed life-long monthly pension, once vested after 5 years of service

• 457B Retirement Plan

• 140 hours of PTO earned within first year + 11 paid holidays, 1 personal holiday and 1 volunteer day per year

• Competitive medical, dental and vision plans effective within 1 month of start date

This is a limited position with an expected end date of December 31, 2025, with the possibility of extension.

Location

The City and County of Denver supports a hybrid workplace model. In this position, you can expect to work in the office a minimum of 3 days per week. Employees must work within the state of Colorado on their off-site days. The office for this position is located at 101 W. Colfax Ave a minimum of 3 days per week.

What You’ll Do

Denver's Department of Public Health and Environment (DDPHE) is dedicated to advancing Denver's environmental and public health goals. DDPHE works collaboratively with city, state and community partners to conduct education, community engagement, and enforcement to promote healthy people, healthy pets, and a sustainable environment. DDPHE oversees a number of services related to public health and the environment and is comprised of seven divisions: Shared Services and Business Operations; Community & Behavioral Health; Public Health Investigations; Denver Animal Protection; the Office of Medical Examiner; Emergency Management and Medical Operations; and Environmental Quality. For more information on DDPHE’s programs and services, visit the DDPHE website at: Denver Department of Public Health and Environment.

We foster an inclusive culture by respecting the values, customs, and authenticity of everyone and by implementing equitable public health strategies so Denver communities can thrive.

The Epidemiology and Data Science section, within the Division of Shared Services and Business Operations, has an opening for a Data Analytics Associate beginning on January 1, 2025. This analyst will work for 2/3 of their time on the Roads to Recovery program, while the remaining third will be applied to other data systems, analysis, and reporting projects with various DDPHE divisions. Roads to Recovery is a Mayoral Initiative providing intensive case management to justice-involved Denver residents with high-acuity behavioral health challenges. Roads to Recovery works across city agencies and service providers to move participants struggling with substance use or mental health out of the criminal justice system and into a coordinated intervention, treatment, and rehabilitation pipeline.

Specifically, as the Data Analytics Associate, you will:

• Managing and further developing the Roads to Recovery program database (housed in SharePoint lists), data collection tools, related workflows, and reporting.

• Supporting the Roads to Recovery program team with data-related needs and support on an ad hoc basis, including building new workflows, updating dashboards, writing queries, conducting analysis, and providing training to data users.

• Creating dashboards reporting key Roads to Recovery program metrics.

• Cleaning and maintaining Roads to Recovery program data.

• Analyzing and visualizing quantitative and qualitative program data.

• As needed, completing other data-related projects for the department, including projects related to animal protection, residential and restaurant inspections, air and water quality testing, behavioral health programming, population health analysis, internal operational improvements, etc.  Projects may include building, maintaining, and refreshing dashboards; writing queries for ad hoc data needs and analysis, creating data visualizations and providing data-related support and training.

• Along with all DDPHE staff, actively participate in emergency preparedness and response team activities to support DDPHE’s responsibilities outlined in the City’s Emergency Operations Plan. This may require being ‘on-call’ from time to time respond to emergencies. Training will be provided.

• Other duties as assigned.

What You’ll Bring

We value diversity of ethnicity, race, socioeconomic status, sexual identity, gender, religion, language, ability, and experience and exemplify this through the makeup of our team at all levels. You'll be right at home here if you cultivate strong relationships and push yourself, your work, the people around you and Denver to the next level.

Our ideal candidate has some or all the following experience, skills, and characteristics:

• Bachelor’s or Master’s degree in a data-related field (Biostatistics, Computer Science, Mathematics, Statistics, etc.) or public health-related field with additional study or work experience in data science or analytics.

• The ability to work with and analyze large data sets, including writing queries, cleaning, and validating data, conducting analyses, and creating visualizations to report your findings.

• The ability to develop and manage ETL (Extract, Transform, Load) processes to extract and transform data from multiple sources, ensuring data quality and alignment with business requirements.

• Experience utilizing Microsoft PowerBI, Tableau or other analytics/visualization tools to build data visualization dashboards for operational and public reporting.

• Experience with Microsoft tools, including SharePoint lists.

• Experience with open-source programming languages and tools used for data engineering and analysis (SQL, DAX or M, Python, R/R Studio, etc.) and/or the interest and aptitude to build programming skills as required.

• Familiarity with qualitative methods and experience using qualitative analysis software tools (e.g., NVivo, Atlas.ti, MAXQDA, Dedoose) for coding, data organization, and analysis.

• Strong time management, project management, and collaboration skills, including the ability to juggle multiple projects, work with a team, and deliver on a deadline with support from a supervisor or lead analyst.

• Strong communication skills, including the ability to present analytical findings in a concise and engaging way, written or in person, especially to audiences who may have a range of comfort levels with data and analysis.

• A commitment to public service, equity, and improving health for all members of our Denver community.

Required Minimum Qualifications

• Education requirement: Bachelor's Degree in Computer Science, Information Systems, Statistics, Actuarial Science, Business Administration, or other related field.

• Experience Requirement: Two (2) year of professional level experience with data extraction, data management and programming, and using data and reporting to answer audit questions.

• Education/Experience Equivalency: One (1) year of the appropriate type and level of experience may be substituted for each required year of post-high school education. Additional appropriate education may be substituted for experience requirements.

• License/Certifications: None.

Application Deadline

This position is expected to stay open until Tuesday, January 14, 2025. Please submit your application as soon as possible and no later than this date at 11:59 p.m. to ensure consideration.

To be considered for this position, you must include the following on your job application (upload the attachment(s) to the Resume/CV section on the My Experience tab):

• Brief cover letter

• Resume

About Everything Else

Job Profile

CD3307 Data Analytics Associate

To view the full job profile including position specifications, physical demands, and probationary period, click here.

Position Type

Limited (Fixed Term)

Position Salary Range

$65,523.00 - $108,113.00

Starting Pay

$65,523.00 - $88,988.00

Agency

Dept of Public Health & Environment

The City and County of Denver provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, national origin, disability, genetic information, age, or any other status protected under federal, state, and/or local law. 

It is your right to access oral or written language assistance, sign language interpretation, real-time captioning via CART, or disability-related accommodations. To request any of these services at no cost to you, please contact Jobs@Denvergov.org with three business days’ notice.

Applicants for employment with the City and County of Denver must have valid work authorization that does not require sponsorship of a visa for employment authorization in the U.S.

For information about right to work, click here for English or here for Spanish.