State of Colorado
OCFMH Data Analyst
Print (https://www.governmentjobs.com/careers/colorado/jobs/newprint/5038167)
Apply
OCFMH Data Analyst
Salary
$71,500.00 - $93,000.00 Annually
Location
Denver, CO
Job Type
Full Time
Job Number
IIC 06996 08/08/2025
Department
Colorado Department of Human Services
Division
OBH (Office of Behavioral Health)
Opening Date
08/08/2025
Closing Date
8/17/2025 11:59 PM Mountain
FLSA
Determined by Position
Type of Announcement
This position is open only to Colorado state residents.
Primary Physical Work Address
1575 Sherman St. Denver, CO 80203
FLSA Status
Exempt; position is not eligible for overtime compensation.
Department Contact Information
melissa.baca@state.co.us
How To Apply
Please submit an online application for this position at https://www.governmentjobs.com/careers/colorado. Reach out to the Department Contact to apply using a paper application, including any supplemental questions. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received by the appropriate Human Resources office before the closing date and time listed.
Description
Benefits
Questions
Department Information
This position is open to current Colorado residents only.
Most State of Colorado employees are eligible for a great benefit package! Please see the Supplemental Information section below for details! (https://dhr.colorado.gov/state-employees/state-of-colorado-employee-benefits)
Description of Job
Hybrid work arrangements (minimum of two days on-site or more depending on business need).
Please note: These working arrangements are subject to change.
What you will be doing:
This position collaborates with the Office of Civil and Forensic Mental Health (OCFMH) Senior Leadership and the Health Information Technology (HIT) Team to lead the creation and delivery of the Colorado Department of Human Services (CDHS) Special Master’s Consent Decree monthly and annual reports. It conducts analyses and produces reports and visualizations using tools such as Excel, Google Sheets, and Tableau. The position also extracts data from relational data warehouses using SQL, and leverages R for statistical computing and automated reporting to meet project requirements.
The position manages projects in an agile environment, primarily using Jira. It gathers requirements from customers within CDHS, including the Mental Health Hospitals in Denver and Pueblo, OCFMH, and the Forensic Services Division, to fulfill data-related requests. This includes providing timely communication regarding status, updates, and changes.
The position uses reporting tools to identify patterns or trends that may affect patient and/or staff safety, and designs, compiles, and maintains reporting systems that serve as a reference for available data needs. It is expected to gain an in-depth understanding of OCFMH clinical and operational programs and participate in program meetings. The role also supports other OCFMH reporting needs, including compliance and regulatory reporting (e.g. The Joint Commission, Colorado Open Records Act.).
The position may occasionally be required to accept, perform, oversee or delegate unforeseen duties or tasks not described above, as assigned by the OCFMH Data and Evaluation Supervisor or their designees.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Experience Only:
Seven (7) years of experience in data analysis, data visualization, query writing (e.g., SQL), data interpretation, reporting and dashboarding or a closely related field.
OR
Education and Experience:
A combination of education in data science, computer science, statistics, mathematics, information systems, economics, or other qualitative disciplines and/or relevant experience in data analysis, data visualization, query writing (e.g., SQL), data interpretation, reporting and dashboarding or a closely related field equal to seven (7) years.
Preferred Qualifications:
Experience working with large-scale data warehouses ( e.g.,Snowflake, BigQuery, Oracle, Redshift)
Proficiency writing complex SQL queries to extract and analyze data from relational databases or data warehouses
Proficiency in R for data analysis, visualization, and automated reporting
Proficiency in building data visualization dashboards such as Tableau or PowerBI
Familiarity with project management tools and methodologies (e.g. Jira, Asana, Trello)
Experience working with healthcare data, including both operational and legal databases, or other regulated industry data
Skilled in requirements gathering through interviews, documentation review, and cross-functional communication
Comfortable working in fast-paced, Agile environment with evolving priorities
Conditions of Employment:
Standard background check and reference check required
Must possess a valid, unrestricted U.S. Driver's License
Former State employees who were disciplinarily terminated or resigned in lieu of termination must (1) disclose that information on the application (2) provide an explanation why the prior termination or resignation should not disqualify the applicant from the current position, (3) provide the employee number from the applicant’s prior State employment. Absent extraordinary circumstances, prior disciplinary termination or resignation in lieu of termination and failure to provide this information will disqualify the applicant from future State employment with CDHS.
Appeal Rights:
If you receive notice that you have been eliminated from consideration for this position, you may file an appeal with the State Personnel Board or request a review by the State Personnel Director.
An appeal or review must be submitted on the official appeal form, signed by you or your representative. This form must be delivered to the State Personnel Board by email (dpa_state.personnelboard@state.co.us), postmarked in US Mail or hand delivered (1525 Sherman Street, 4th Floor, Denver CO 80203), or faxed (303.866.5038) within ten (10) calendar days from your receipt of notice or acknowledgement of the department’s action.
For more information about the appeals process, the official appeal form, and how to deliver it to the State Personnel Board; go to spb.colorado.gov ; contact the State Personnel Board for assistance at (303) 866-3300; or refer to 4 Colorado Code of Regulations (CCR) 801-1, State Personnel Board Rules and Personnel Director's Administrative Procedures, Chapter 8, Resolution of Appeals and Disputes, at spb.colorado.gov under Rules.
Supplemental Information
How to Apply (https://cdhs.colorado.gov/information-for-job-applicants#how-to-apply)
Need help with your application? Click here.
The Assessment Process (https://cdhs.colorado.gov/information-for-job-applicants#assessment-process)
For additional recruiting questions, please contact melissa.baca@state.co.us
About Us:
If your goal is to build a career that makes a difference, consider joining the dedicated people of the Colorado Department of Human Services (https://www.colorado.gov/cdhs) (CDHS). Our professionals strive to design and deliver high quality human and health services that improve the safety, independence, and well-being of the people of Colorado. In addition to a great location and rewarding and meaningful work, we offer:
Strong, secure, yet flexible retirement benefits including a PERA Defined Benefit Plan or PERA Defined Contribution Plan www.copera.org plus 401(k) and 457 plans
Medical and dental health plans
Employer supplemented Health Savings Account
Paid life insurance
Short- and long-term disability coverage
11 paid holidays per year plus vacation and sick leave
BenefitHub state employee discount program
Employee Wellness program (https://coloradostateofhealth.com/)
Excellent work-life programs, such as flexible schedules, training and more
Remote work arrangements for eligible positions
*Some positions may qualify for the Public Service Loan Forgiveness Program. For more
information, go to https://www.colorado.gov/pacific/dhr/student-loan-forgiveness-programs .
Our Values:
We believe in a people-first approach: To serve the people of Colorado, we develop a culture and work environment that creates an energized, inspired, and healthy team capable of giving their best to Coloradans .
Balance creates quality of life: We want our team to be resilient through a supportive workplace that values flexibility, health and wellness, and employee engagement.
We hold ourselves accountable: We take responsibility through our actions, programs, and results for the state of health and human services in Colorado.
Transparency matters: We are open and honest with employees, our partners, the Coloradans we serve, and the public.
We are ethical: We abide by what is best for those we serve by doing what is right, not what is easy.
Collaboration helps us rise together: We work together with all partners, employees, and clients to achieve the best outcomes for Coloradans.
We are committed to increasing the diversity of our staff and providing culturally responsive programs and services. Therefore, we encourage responses from people of diverse backgrounds and abilities.
ADA Accommodations: CDHS is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADA Coordinator, Nancy Schmelzer, at cdhs_ada@state.co.us or call 1-800-929-0791.
~THE STATE OF COLORADO IS AN EQUAL OPPORTUNITY EMPLOYER~ (https://cdhs.colorado.gov/information-for-job-applicants#eoe)
https://www.youtube.com/watch?v=K6gjqMdD39s
The State of Colorado offers permanent employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: www.colorado.gov/pacific/dhr/benefits
Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.
01
The bottom of this job announcement provides links to additional information on how to apply, the assessment process, toll free applicant technical support, and about how the State of Colorado is an equal opportunity employer. Please acknowledge below that you have read the information provided in these links.
This information is available to me and I have read this information.
I am unable to access the links with this information on the job posting. (If you select this option, please contact the recruiter, whose information is listed on this announcement, so that they can send this information directly to you.)
02
Your legal name is used in the hiring process for background checks. Did you use your full legal name in your application? If not, please update your information before submitting your application.
Yes
No
03
If you are a current or former State of Colorado employee, please list your employee number (starts with 997…). Failure to provide this requested information may render your application incomplete, and you may no longer be considered for the position.
04
Former State employees who were disciplinarily terminated or resigned in lieu of termination must disclose the information on the application. In the space below, please provide an explanation as to why the prior termination or resignation should NOT disqualify your application from the current position.
05
If you are a former or current state employee, please identify what state agency you work(ed) with and how many years of relevant state service you have related to the position you are applying for. (Ensure this is listed on your application under work experience).
06
Please rate SQL proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience with SQL, including writing queries, less than 1 year experience
4= proficient in SQL, including writing complex queries, and 1 or more years of experience
5= advanced SQL skills, including writing complex queries, and 2 or more years experience
07
Please rate R programming proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience with R, including basic data analysis and visualization, less than 1 year experience
4= proficient in R, including custom functions, statistical modeling, or building automated reports, and 1 or more years of experience
5= advanced R skills, including custom functions, statistical modeling, or building automated reports, and 2 or more years of experience
08
Please rate building data visualization dashboards proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience building dashboards, less than 1 year experience
4= proficient in building dashboards using tools like Tableau, PowerBI, or Looker, and 1 or more years of experience
5= advanced experienced designing interactive, user-focused dashboards with advanced features using tools like Tableau, PowerBI, or Looker, and 2 or more years of experience
09
Please describe a business problem you helped solve by using data from a warehouse. In your response include: ( the nature of the problem, steps you took to solve it, and any specific data tools or technologies you used).
10
Please describe a data visualization dashboard you created in the past year. In your response include: (the tool and specific features used, how the dashboard was used, the business need or question the dashboard addressed).
11
I acknowledge that I have reviewed the salary range for this position.
I acknowledge.
Required Question
Employer
State of Colorado
Address
See the full announcement by clicking
the "Printer" icon located above the job title
Location varies by announcement, Colorado, --
Website
https://careers.colorado.gov/
Apply
Please verify your email addressVerify Email
Print (https://www.governmentjobs.com/careers/colorado/jobs/newprint/5038167)
Apply
OCFMH Data Analyst
Salary
$71,500.00 - $93,000.00 Annually
Location
Denver, CO
Job Type
Full Time
Job Number
IIC 06996 08/08/2025
Department
Colorado Department of Human Services
Division
OBH (Office of Behavioral Health)
Opening Date
08/08/2025
Closing Date
8/17/2025 11:59 PM Mountain
FLSA
Determined by Position
Type of Announcement
This position is open only to Colorado state residents.
Primary Physical Work Address
1575 Sherman St. Denver, CO 80203
FLSA Status
Exempt; position is not eligible for overtime compensation.
Department Contact Information
melissa.baca@state.co.us
How To Apply
Please submit an online application for this position at https://www.governmentjobs.com/careers/colorado. Reach out to the Department Contact to apply using a paper application, including any supplemental questions. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received by the appropriate Human Resources office before the closing date and time listed.
Description
Benefits
Questions
Department Information
This position is open to current Colorado residents only.
Most State of Colorado employees are eligible for a great benefit package! Please see the Supplemental Information section below for details! (https://dhr.colorado.gov/state-employees/state-of-colorado-employee-benefits)
Description of Job
Hybrid work arrangements (minimum of two days on-site or more depending on business need).
Please note: These working arrangements are subject to change.
What you will be doing:
This position collaborates with the Office of Civil and Forensic Mental Health (OCFMH) Senior Leadership and the Health Information Technology (HIT) Team to lead the creation and delivery of the Colorado Department of Human Services (CDHS) Special Master’s Consent Decree monthly and annual reports. It conducts analyses and produces reports and visualizations using tools such as Excel, Google Sheets, and Tableau. The position also extracts data from relational data warehouses using SQL, and leverages R for statistical computing and automated reporting to meet project requirements.
The position manages projects in an agile environment, primarily using Jira. It gathers requirements from customers within CDHS, including the Mental Health Hospitals in Denver and Pueblo, OCFMH, and the Forensic Services Division, to fulfill data-related requests. This includes providing timely communication regarding status, updates, and changes.
The position uses reporting tools to identify patterns or trends that may affect patient and/or staff safety, and designs, compiles, and maintains reporting systems that serve as a reference for available data needs. It is expected to gain an in-depth understanding of OCFMH clinical and operational programs and participate in program meetings. The role also supports other OCFMH reporting needs, including compliance and regulatory reporting (e.g. The Joint Commission, Colorado Open Records Act.).
The position may occasionally be required to accept, perform, oversee or delegate unforeseen duties or tasks not described above, as assigned by the OCFMH Data and Evaluation Supervisor or their designees.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Experience Only:
Seven (7) years of experience in data analysis, data visualization, query writing (e.g., SQL), data interpretation, reporting and dashboarding or a closely related field.
OR
Education and Experience:
A combination of education in data science, computer science, statistics, mathematics, information systems, economics, or other qualitative disciplines and/or relevant experience in data analysis, data visualization, query writing (e.g., SQL), data interpretation, reporting and dashboarding or a closely related field equal to seven (7) years.
Preferred Qualifications:
Experience working with large-scale data warehouses ( e.g.,Snowflake, BigQuery, Oracle, Redshift)
Proficiency writing complex SQL queries to extract and analyze data from relational databases or data warehouses
Proficiency in R for data analysis, visualization, and automated reporting
Proficiency in building data visualization dashboards such as Tableau or PowerBI
Familiarity with project management tools and methodologies (e.g. Jira, Asana, Trello)
Experience working with healthcare data, including both operational and legal databases, or other regulated industry data
Skilled in requirements gathering through interviews, documentation review, and cross-functional communication
Comfortable working in fast-paced, Agile environment with evolving priorities
Conditions of Employment:
Standard background check and reference check required
Must possess a valid, unrestricted U.S. Driver's License
Former State employees who were disciplinarily terminated or resigned in lieu of termination must (1) disclose that information on the application (2) provide an explanation why the prior termination or resignation should not disqualify the applicant from the current position, (3) provide the employee number from the applicant’s prior State employment. Absent extraordinary circumstances, prior disciplinary termination or resignation in lieu of termination and failure to provide this information will disqualify the applicant from future State employment with CDHS.
Appeal Rights:
If you receive notice that you have been eliminated from consideration for this position, you may file an appeal with the State Personnel Board or request a review by the State Personnel Director.
An appeal or review must be submitted on the official appeal form, signed by you or your representative. This form must be delivered to the State Personnel Board by email (dpa_state.personnelboard@state.co.us), postmarked in US Mail or hand delivered (1525 Sherman Street, 4th Floor, Denver CO 80203), or faxed (303.866.5038) within ten (10) calendar days from your receipt of notice or acknowledgement of the department’s action.
For more information about the appeals process, the official appeal form, and how to deliver it to the State Personnel Board; go to spb.colorado.gov ; contact the State Personnel Board for assistance at (303) 866-3300; or refer to 4 Colorado Code of Regulations (CCR) 801-1, State Personnel Board Rules and Personnel Director's Administrative Procedures, Chapter 8, Resolution of Appeals and Disputes, at spb.colorado.gov under Rules.
Supplemental Information
How to Apply (https://cdhs.colorado.gov/information-for-job-applicants#how-to-apply)
Need help with your application? Click here.
The Assessment Process (https://cdhs.colorado.gov/information-for-job-applicants#assessment-process)
For additional recruiting questions, please contact melissa.baca@state.co.us
About Us:
If your goal is to build a career that makes a difference, consider joining the dedicated people of the Colorado Department of Human Services (https://www.colorado.gov/cdhs) (CDHS). Our professionals strive to design and deliver high quality human and health services that improve the safety, independence, and well-being of the people of Colorado. In addition to a great location and rewarding and meaningful work, we offer:
Strong, secure, yet flexible retirement benefits including a PERA Defined Benefit Plan or PERA Defined Contribution Plan www.copera.org plus 401(k) and 457 plans
Medical and dental health plans
Employer supplemented Health Savings Account
Paid life insurance
Short- and long-term disability coverage
11 paid holidays per year plus vacation and sick leave
BenefitHub state employee discount program
Employee Wellness program (https://coloradostateofhealth.com/)
Excellent work-life programs, such as flexible schedules, training and more
Remote work arrangements for eligible positions
*Some positions may qualify for the Public Service Loan Forgiveness Program. For more
information, go to https://www.colorado.gov/pacific/dhr/student-loan-forgiveness-programs .
Our Values:
We believe in a people-first approach: To serve the people of Colorado, we develop a culture and work environment that creates an energized, inspired, and healthy team capable of giving their best to Coloradans .
Balance creates quality of life: We want our team to be resilient through a supportive workplace that values flexibility, health and wellness, and employee engagement.
We hold ourselves accountable: We take responsibility through our actions, programs, and results for the state of health and human services in Colorado.
Transparency matters: We are open and honest with employees, our partners, the Coloradans we serve, and the public.
We are ethical: We abide by what is best for those we serve by doing what is right, not what is easy.
Collaboration helps us rise together: We work together with all partners, employees, and clients to achieve the best outcomes for Coloradans.
We are committed to increasing the diversity of our staff and providing culturally responsive programs and services. Therefore, we encourage responses from people of diverse backgrounds and abilities.
ADA Accommodations: CDHS is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or to perform essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to our ADA Coordinator, Nancy Schmelzer, at cdhs_ada@state.co.us or call 1-800-929-0791.
~THE STATE OF COLORADO IS AN EQUAL OPPORTUNITY EMPLOYER~ (https://cdhs.colorado.gov/information-for-job-applicants#eoe)
https://www.youtube.com/watch?v=K6gjqMdD39s
The State of Colorado offers permanent employees a variety of benefits including medical, dental, life and disability insurance, as well as a comprehensive leave program. Please click the following link for detailed information: www.colorado.gov/pacific/dhr/benefits
Please note that each agency's contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the "Print" icon.
01
The bottom of this job announcement provides links to additional information on how to apply, the assessment process, toll free applicant technical support, and about how the State of Colorado is an equal opportunity employer. Please acknowledge below that you have read the information provided in these links.
This information is available to me and I have read this information.
I am unable to access the links with this information on the job posting. (If you select this option, please contact the recruiter, whose information is listed on this announcement, so that they can send this information directly to you.)
02
Your legal name is used in the hiring process for background checks. Did you use your full legal name in your application? If not, please update your information before submitting your application.
Yes
No
03
If you are a current or former State of Colorado employee, please list your employee number (starts with 997…). Failure to provide this requested information may render your application incomplete, and you may no longer be considered for the position.
04
Former State employees who were disciplinarily terminated or resigned in lieu of termination must disclose the information on the application. In the space below, please provide an explanation as to why the prior termination or resignation should NOT disqualify your application from the current position.
05
If you are a former or current state employee, please identify what state agency you work(ed) with and how many years of relevant state service you have related to the position you are applying for. (Ensure this is listed on your application under work experience).
06
Please rate SQL proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience with SQL, including writing queries, less than 1 year experience
4= proficient in SQL, including writing complex queries, and 1 or more years of experience
5= advanced SQL skills, including writing complex queries, and 2 or more years experience
07
Please rate R programming proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience with R, including basic data analysis and visualization, less than 1 year experience
4= proficient in R, including custom functions, statistical modeling, or building automated reports, and 1 or more years of experience
5= advanced R skills, including custom functions, statistical modeling, or building automated reports, and 2 or more years of experience
08
Please rate building data visualization dashboards proficiency on a scale of 1-5.
1= no training or experience
2= basic training or coursework, but no practical experience
3= some practical experience building dashboards, less than 1 year experience
4= proficient in building dashboards using tools like Tableau, PowerBI, or Looker, and 1 or more years of experience
5= advanced experienced designing interactive, user-focused dashboards with advanced features using tools like Tableau, PowerBI, or Looker, and 2 or more years of experience
09
Please describe a business problem you helped solve by using data from a warehouse. In your response include: ( the nature of the problem, steps you took to solve it, and any specific data tools or technologies you used).
10
Please describe a data visualization dashboard you created in the past year. In your response include: (the tool and specific features used, how the dashboard was used, the business need or question the dashboard addressed).
11
I acknowledge that I have reviewed the salary range for this position.
I acknowledge.
Required Question
Employer
State of Colorado
Address
See the full announcement by clicking
the "Printer" icon located above the job title
Location varies by announcement, Colorado, --
Website
https://careers.colorado.gov/
Apply
Please verify your email addressVerify Email