Address
Form of workSalary: $65,700.00 - $97,044.00 Annually
Location : Denver Metro, CO
Job Type: Full Time
Job Number: UHA05738 - 11/2023
Department: Department of Health Care Policy and Financing
Division: Cost Control and Quality Improvement Office
Opening Date: 11/20/2023
Closing Date: 12/7/2023 11:59 PM Mountain
FLSA: Determined by Position
Primary Physical Work Address: 303 E 17th Ave, Denver CO 80203
FLSA Status: Exempt; position is not eligible for overtime compensation.
Department Information
STATE OF COLORADO RESIDENCY REQUIRED AT TIME OF APPLICATION
NOTE: This announcement may be used to fill multiple openings.
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 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.
We are looking for a Junior Data Analyst to join our Analytic and Quality Divisionteam!
As part of the State of Colorado, HCPF offers a competitive benefits package:
information, go to https://www.colorado.gov/pacific/dhr/student-loan-forgiveness-programs. https://dhr.colorado.gov/dhr-resources/student-loan-forgiveness-programs
The Data Analysis Section (DAS) creates analytical work products using Medicaid claims data as well as other data sets. DAS analytic products support internal policy-making decisions, budget requests, fiscal notes, performance measurement, and program improvement. DAS creates external reports for mandatory State and Federal requirements, data for audits by regulatory agencies and other external purposes such as research partnerships. DAS' work enables the performance and improvement of vital business functions by analyzing trends in Medicaid utilization and expenditures.
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 fully remote, hybrid, to full-time in the office. Specific discussions about the schedule will be discussed during the offer stage.
Description of Job
What you'll be doing:
The position utilizes business intelligence software such as COGNOS or TOAD for Data Analysts to write complex queries to extract data from relational databases. The position writes complex coding to manipulate data to answer very specific questions about the Colorado Medicaid program. The position summarizes the data into understandable reports and communicates findings to internal and external customers. The position performs work for any unit within the Department but will be specifically using HCPF Office of Community Living (OCL) and Case Management data to support the Colorado Choice Transitions (CCT) or successor programs. Along with developing expertise in OCL data the cross trains in other areas of DAS' work to meet business need. This position specializes in data found in multiple systems, some of which are not widely accessible to other positions.
Duties include, but are not limited to:
•Develops and completes a range of analyses and reports using inferential statistical measures commonly used in the field.
•Interprets results of these analyses, provides explanation for variances or unexpected results, and offers recommendations based on the analyses.
•Consults on statistical sampling techniques, database alternatives, organizing and conducting analyses of operations or research activities, and offers interpretations of analytical findings understandable to non-data staff. Statistical projects include estimates, projections, frequencies, distributions, correlations, regressions, and other measurements of collected data. Reports include summaries, conclusions, assumptions, and recommendations based on judgement and inferential techniques.
•Offers insights and recommendations to program staff based on a general understanding of Medicaid programs. Work typically includes modifying computerized statistical packages that compile or manipulate data, and the application of the packages to such data.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Residency Requirement: (New)
This posting is only open to residents of the State of Colorado at the time of submitting your application.
MINIMUM QUALIFICATIONS:
Education and Experience:
Bachelor's degree from an accredited institution in Mathematics, Statistics, Economics, Social Science quantitative study, or a closely related field
AND
Two years of professional experience in professional statistical analysis experience.
Substitutions:
Preferred Qualifications & Special Qualifications:
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
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 dpa_state.personnelboard@state.co.us within ten (10) calendar days from your receipt of notice or acknowledgement 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.
Supplemental Information
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 on the application itself. Applications left blank or marked "SEE RESUME" will not be considered.
Your application will be reviewed against the minimum qualifications for the position. If your application demonstrates that you meet the minimum qualifications, you will be invited to the comparative analysis process, which is described below.
Comparative Analysis Process
The comparative analysis process will consist primarily of a review of applications against the minimum and preferred qualifications of this position. Applications will be reviewed in comparison to all others in the applicant pool in order to identify a top group of candidates who may be invited for a final interview. Depending on the size of the applicant pool, additional selection processes may be utilized to identify a top group of candidates. Applicants will be notified of their status via email.
Failure to submit properly completed documents by the closing date will result in your application being rejected.
ADAAA Accommodations: The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.
The Department of Health Care Policy & Financing 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 ADAAA Coordinator, Virginia Miller, at virginia.miller@state.co.us.
The Department of Health Care Policy & Financing does not offer sponsored visas for employment purposes.
NA
01
All HCPF positions are security-sensitive positions and require potential employees to undergo a criminal record background check. As a condition of employment, you will be required to submit to pre-employment screening if offered the position. Are you willing to meet this requirement?
02
Do you have any relatives or significant others working at the Department of Health Care Policy & Financing? If so, please list their names here. Otherwise, please list N/A.
03
If you are a current or former State of Colorado employee, please provide your EID (employee identification numbers will start with 99...). If not, please type N/A.
04
Are you willing to accept an offer within the posted salary range?
05
Do you understand that this is a term-limited position with funding through June 30, 2027?
06
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. Otherwise, please list N/A.
07
List any additional relevant experience you would like us to consider in determining if you meet the qualifications of this position. Please, include the months and years relevant to the experience ...
Location : Denver Metro, CO
Job Type: Full Time
Job Number: UHA05738 - 11/2023
Department: Department of Health Care Policy and Financing
Division: Cost Control and Quality Improvement Office
Opening Date: 11/20/2023
Closing Date: 12/7/2023 11:59 PM Mountain
FLSA: Determined by Position
Primary Physical Work Address: 303 E 17th Ave, Denver CO 80203
FLSA Status: Exempt; position is not eligible for overtime compensation.
Department Information
STATE OF COLORADO RESIDENCY REQUIRED AT TIME OF APPLICATION
NOTE: This announcement may be used to fill multiple openings.
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 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.
We are looking for a Junior Data Analyst to join our Analytic and Quality Divisionteam!
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
- Credit Union of Colorado Membership Eligibility
- 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. https://dhr.colorado.gov/dhr-resources/student-loan-forgiveness-programs
The Data Analysis Section (DAS) creates analytical work products using Medicaid claims data as well as other data sets. DAS analytic products support internal policy-making decisions, budget requests, fiscal notes, performance measurement, and program improvement. DAS creates external reports for mandatory State and Federal requirements, data for audits by regulatory agencies and other external purposes such as research partnerships. DAS' work enables the performance and improvement of vital business functions by analyzing trends in Medicaid utilization and expenditures.
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 fully remote, hybrid, to full-time in the office. Specific discussions about the schedule will be discussed during the offer stage.
Description of Job
What you'll be doing:
The position utilizes business intelligence software such as COGNOS or TOAD for Data Analysts to write complex queries to extract data from relational databases. The position writes complex coding to manipulate data to answer very specific questions about the Colorado Medicaid program. The position summarizes the data into understandable reports and communicates findings to internal and external customers. The position performs work for any unit within the Department but will be specifically using HCPF Office of Community Living (OCL) and Case Management data to support the Colorado Choice Transitions (CCT) or successor programs. Along with developing expertise in OCL data the cross trains in other areas of DAS' work to meet business need. This position specializes in data found in multiple systems, some of which are not widely accessible to other positions.
Duties include, but are not limited to:
•Develops and completes a range of analyses and reports using inferential statistical measures commonly used in the field.
•Interprets results of these analyses, provides explanation for variances or unexpected results, and offers recommendations based on the analyses.
•Consults on statistical sampling techniques, database alternatives, organizing and conducting analyses of operations or research activities, and offers interpretations of analytical findings understandable to non-data staff. Statistical projects include estimates, projections, frequencies, distributions, correlations, regressions, and other measurements of collected data. Reports include summaries, conclusions, assumptions, and recommendations based on judgement and inferential techniques.
•Offers insights and recommendations to program staff based on a general understanding of Medicaid programs. Work typically includes modifying computerized statistical packages that compile or manipulate data, and the application of the packages to such data.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights
Residency Requirement: (New)
This posting is only open to residents of the State of Colorado at the time of submitting your application.
MINIMUM QUALIFICATIONS:
Education and Experience:
Bachelor's degree from an accredited institution in Mathematics, Statistics, Economics, Social Science quantitative study, or a closely related field
AND
Two years of professional experience in professional statistical analysis experience.
Substitutions:
- Additional appropriate experience will substitute for the degree requirement on a year-for-year basis.
- A combination of work experience in the occupational field or specialized subject area of the work assigned to the job, which provided the same kind, amount, and level of knowledge acquired in the required education, may be substituted on a year-for-year basis for the bachelor's degree.
- A master's or doctorate degree from an accredited college or university in a field of study related to the work assignment may be substituted for the bachelor's degree and at the agency's discretion, one or two years of general experience respectively. Additional appropriate experience will substitute for the degree requirement on a year-for-year basis.
Preferred Qualifications & Special Qualifications:
- Experience querying large databases using SQL
- Experience using statistical methods to analyze data and evaluate program impact
- Experience with creative and innovative data visualization, preferably in Tableau
- Healthcare data experience
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.
- This is a term-limited position with funding through June 30, 2027 . Successful candidates will sign a Waiver of Retention Rights and normal personnel rules regarding retention will not apply.
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 dpa_state.personnelboard@state.co.us within ten (10) calendar days from your receipt of notice or acknowledgement 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.
Supplemental Information
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 on the application itself. Applications left blank or marked "SEE RESUME" will not be considered.
Your application will be reviewed against the minimum qualifications for the position. If your application demonstrates that you meet the minimum qualifications, you will be invited to the comparative analysis process, which is described below.
Comparative Analysis Process
The comparative analysis process will consist primarily of a review of applications against the minimum and preferred qualifications of this position. Applications will be reviewed in comparison to all others in the applicant pool in order to identify a top group of candidates who may be invited for a final interview. Depending on the size of the applicant pool, additional selection processes may be utilized to identify a top group of candidates. Applicants will be notified of their status via email.
Failure to submit properly completed documents by the closing date will result in your application being rejected.
ADAAA Accommodations: The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law.
The Department of Health Care Policy & Financing 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 ADAAA Coordinator, Virginia Miller, at virginia.miller@state.co.us.
The Department of Health Care Policy & Financing does not offer sponsored visas for employment purposes.
NA
01
All HCPF positions are security-sensitive positions and require potential employees to undergo a criminal record background check. As a condition of employment, you will be required to submit to pre-employment screening if offered the position. Are you willing to meet this requirement?
- Yes
- No
02
Do you have any relatives or significant others working at the Department of Health Care Policy & Financing? If so, please list their names here. Otherwise, please list N/A.
03
If you are a current or former State of Colorado employee, please provide your EID (employee identification numbers will start with 99...). If not, please type N/A.
04
Are you willing to accept an offer within the posted salary range?
05
Do you understand that this is a term-limited position with funding through June 30, 2027?
- Yes
- No
06
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. Otherwise, please list N/A.
07
List any additional relevant experience you would like us to consider in determining if you meet the qualifications of this position. Please, include the months and years relevant to the experience ...
