OCFMH Data Analyst
OCFMH Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 71500 - 93000
1 Vacancy
Job Description
Department Information
This position is open to current Colorado residents only.
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 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.
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 ( 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:
Standardbackground check and reference check required
Must possess a valid unrestricted U.S. Drivers 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 () 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; contact the State Personnel Board for assistance at ; or refer to 4 Colorado Code of Regulations (CCR) 801-1 State Personnel Board Rules and Personnel Directors Administrative Procedures Chapter 8 Resolution of Appeals and Disputes atunder Rules.
Supplemental Information
Need help with your application Click here.
For additional recruiting questions please contact
About Us:
If your goal is to build a career that makes a difference consider joining the dedicated people of theColorado 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 addition to a great location and rewarding and meaningful work we offer:
Strong secure yet flexible retirement benefits including aPERA Defined Benefit Plan or PERA Defined Contribution Planplus 401(k) and 457 plans
Employer supplementedHealth Savings Account
Paid life insurance
Short- and long-term disability coverage
11 paid holidays per year plus vacation and sick leave
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 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 or call 1-.
Employment Type
Full-Time
Key Skills
Similar Jobs
Dr. Job is an online platform that connects employers with skilled job seekers, facilitating the search for job opportunities and top talent. Established in 2015. Dr. Job Pro has emerged as the world premier job portal, attracting thousands of job seekers every day from all over the world.
Follow Dr.Job
Dr Job FZ LLC. 2025 © All Rights Reserved