Colorado
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!
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 Masters 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. 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 applicants 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 departments 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. How to Apply Need help with your application? Click here. The 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 (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
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://www.youtube.com/watch?v=K6gjqMdD39s #J-18808-Ljbffr
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 Masters 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. 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 applicants 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 departments 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. How to Apply Need help with your application? Click here. The 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 (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
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://www.youtube.com/watch?v=K6gjqMdD39s #J-18808-Ljbffr