Data Analyst

Data Analyst

The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities.

The Department of Health Care Policy & Financing (HCPF) oversees and operates Health First Colorado (Colorado's Medicaid Program), Child Health Plan Plus (CHP+), and other state public health programs for qualified Coloradans. Our mission is to improve health care equity, access and outcomes for the people we serve while saving Coloradans money on health care and driving value for Colorado.

We are looking for a Data Analyst for the Data & Analytics Division of the Cost Control and Quality Improvement Office (CCQI)!

The purpose of CCQI's Data and Analytics Division is to create and disseminate business intelligence and analytic insights for HCPF. The Division's analysis is to support data driven policy decisions, to support and inform HCPF's executive funding requests, to share with contractors, to enable the performance of vital business functions, and to create and support required federal reports. In addition, the Division's analyzes data for Medicaid and other health programs administered by HCPF, including inpatient and outpatient hospital, medical services, supplies and durable medical equipment, transportation, pharmacy, long term services and supports, dental, client eligibility and behavioral health and other subject areas. Data analysis is performed for the preparation of decision items, fiscal notes, and analysis of ongoing trends in the Medicaid program.

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.

As part of the State of Colorado, HCPF offers a competitive benefits package:

• PERA retirement benefits including PERA Defined Benefit Plan, PERA Defined Contribution Plan, plus 401K and 457 plans
• Medical, Dental, and Vision insurance coverage
• Automatic Short-Term and Optional Long-Term Disability Coverage
• Life and AD&D Insurance
• Flexible Spending Accounts (FSAs)
• Family Medical Leave Act (FMLA) job protection and State of Colorado Paid Family Medical Leave (PFML)
• 11 Paid Holidays Annually and Accrued Annual and Sick Leave
• Accrued Sick Leave for State of Colorado Temporary Employees
• Flexplace and Flextime work arrangements
• Variety of discounts on services and products available through the State of Colorado's Work-Life Employment Discount Program
• Free RTD EcoPass to all eligible State Employees
• Reduced college tuition through CSU Global
• Credit Union of Colorado Membership Eligibility
• Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, go to .

We are onboarding new employees using a hybrid approach. The Department supports flexible work arrangements. Depending on the business need and description of the position, we have options that range from hybrid to full-time in the office. Specific discussions about the schedule will be discussed during the offer stage.

**Please note - equipment provisioning and certain onboarding tasks will take place in person, in our downtown Denver office, on the first day of employment.**

Description of Job

What You'll Be Doing as Data Analyst:

• Under supervision, operates as a data analyst and performs duties such as data querying and analysis and statistical analysis.
• Utilizes business intelligence software such as COGNOS or TOAD for Data Analysts to write complex queries to extract data from relational databases.
• Writes complex coding to manipulate data to provide actionable information to answer very specific questions around the operations and evaluation of the Colorado Medicaid program.
• Summarizes the data into understandable reports and communicates findings to internal and external customers.
• Performs work for any unit within the Department but will be specifically supporting the HCPF Office of Community Living (OCL) as part of an agreement with the Federal DOJ.
• Supports Departmental efforts to divert members away from long term facility admission using predictive analytics and risk assessment.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

Residency Requirement:

This posting is only open to residents of the State of Colorado at the time of submitting your application.

Class Code & Classification Description:

I1B1XX Statistical Analyst I Minimum Qualifications: There are two ways to qualify for this position:

Option 1:

Experience Only:

Four (4) total years of professional experience in data analysis, business analytics, health program evaluation, or another field related to the work assignment.

Option 2:

Education and Experience:

A combination of related education and/or relevant experience in data analysis, business analytics, health program evaluation, or related field equal to four (4) years.

Appropriate education will substitute for the required experience on a year-for-year basis. Relevant education will be calculated as the following:

• An associates will count as two years of experience
• A bachelors will count as four years of experience
• A masters degree will count for six years of experience
• A doctorate or juris doctorate degree will count for seven years of experience

Note: Per the Job Application Fairness Act (Download PDF reader), you may redact information that identifies your age, date of birth, or dates of attendance at or graduation from an educational institution on your transcripts.

Preferred Qualifications

• Previous relevant professional state experience
• Professional experience:
• Coding in SQL or R to query large databases
• Working as a data analyst in a healthcare-related field
• Using statistical methods to analyze data and evaluate program impact
• Using Tableau for creative and innovative data visualization

Definition of Professional Experience: Work that involves exercising discretion, analytical skill, judgment, personal accountability, and responsibility for creating, developing, integrating, applying, and sharing an organized body of knowledge that characteristically is uniquely acquired through an intense education or training regimen at a recognized college or university; equivalent to the curriculum requirements for a bachelor's or higher degree with major study in or pertinent to the specialized field; and continuously studied to explore, extend, and use additional discoveries, interpretations, and application and to improve data, materials, equipment, applications and methods.

Conditions of Employment

• All positions at HCPF are security sensitive positions and require that the individuals undergo a criminal record background check as a condition of employment.
• Employees who have been disciplinary terminated, resigned in lieu of disciplinary termination, or negotiated their termination from the State of Colorado must disclose this information on the application.

Appeal Rights:

An applicant who has been removed from an employment list or removed from consideration during the selection process may request a review by the State Personnel Director.

As an applicant directly affected by the results of the selection or comparative analysis process, you may file a written appeal with the State Personnel Director.

Review of the completed, signed, and submitted appeal will be timely on the basis of written material submitted by you, using the official appeal form signed by you or your representative. This form must be completed and delivered to the State Personnel Board by email at View email address on click.appcast.io within ten (10) calendar days from your receipt of notice or acknowledgment of the Department's action.

For further information on the Board Rules, you can 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/board-rules .

How to Apply (Please Read Carefully)

Please note that ONLY your State of Colorado job application will be reviewed during the initial screening; if you submit a resume and cover letter, they will be reviewed in later stages of the selection process. Therefore, it is paramount that you clearly describe all your relevant experience