Prevention and Intake Data Analyst V - TRAILS, Federal Reporting

Title: Prevention and Intake Data Analyst V - TRAILS / Federal Reporting

Salary $91,320.00 - $117,600.00 Annually

Location Denver Metro, CO

Job Type Full Time

Job Number IHA 05088 08/15/2025

Department Colorado Department of Human Services

Division OCYF (Office of Children, Youth & Families)

FLSA Determined by Position

Type of Announcement This position is open only to Colorado state residents.

Primary Physical Work Address

1575 Sherman Street Denver, CO 80203

Job Description:

This position is open to current Colorado residents only.

Please note: This recruitment may be used to fill multiple vacancies.

Most State of Colorado employees are eligible for a great benefit package! Please see the Supplemental Information section below for details!

Please Note: Monday, Tuesday in the office (1575 Sherman St. Denver) or equivalent in person required. All other days work from home. 

About this Unit:

The Division of Child Welfare (DCW) provides a range of leadership, management and supervisory functions related to the delivery of public child welfare services to children, youth and families. The Division provides administrative supervision for all child welfare programs in Colorado's 64 counties, and delivers technical support, monitoring, program improvement, regulatory oversight and other quality assurance functions.

The Research, Analysis, and Data (RAD) unit exists to provide data management and program evaluation through advanced analytical services that examine the policy context, planning and design, implementation, operation, outcomes, and costs of programs in Child Welfare, and uses these evaluations, where needed, to create business intelligence out of Child Welfare operational data for ongoing decision support. The work unit develops and maintains reporting systems that create information which is essential to the effective management of the Division and County Departments.  The unit is charged with management of the data such that it is available in formats that are useful to all potential users.  Additionally, it must maintain the data such that it is available in formats acceptable to the federal government Adoption and Foster Care Analysis and Reporting System (AFCARS), National Youth in Transition Database (NYTD), and the National Child Abuse and Neglect Data System (NCANDS) requirements.  The unit is also responsible for the approval of independent automated systems and the contractor(s) assigned to those projects.

About this Position:

The position has a unique level of technical expertise in monitoring and maintaining statewide data for the Hotline phone network and intake data from Trails. Specifically, this position will prepare, monitor and present validated data for the Child Welfare Allocation Committee (CWAC), ongoing county monitoring groups, CDHS management, federal agencies and other divisions/agencies that rely on call volume and intake data from Trails. Along with needing to understand child welfare practice, this position needs to hold a unique level of technical expertise to independently monitor and interpret call flow for all 64 counties and the statewide Hotline County Call Center (HCCC). This position travels and trains the counties and HCCC on this software to help the counties understand call volume so the counties and HCCC can properly staff the counties call centers. This position is a key player in keeping Colorado's Hotline operational and stable by notifying the appropriate personnel and technical contractors in real-time when the phone network is not performing at its full capacity. 

This position is delegated as the senior authority in Prevention and Intake data performance management and outcome measurement for the Division of Child Welfare. Management relies on this position to conduct research and engage the appropriate stakeholders to formulate outcome measurement recommendations for the statewide Hotline phone network and Trails Intake reporting. Management and CWAC rely on this position for properly reading and monitoring call data by county such as average call time, call volume, wait time, dropped calls and proper transfer and acceptance of county referrals from HCCC. This position participates on committees working on implementing the Family First Prevention Services Act (HR 1892) by providing reliable intake data to help Colorado monitor and shift its practice from out of home placement to prevention services to maximizing federal funding.

CO HB19-1308 (Enacted, 2019) authorizes the department of human services (department) to establish and implement a foster care prevention services program for families with children and youth who are candidates for foster care but who can safely remain at home with receipt of foster care prevention services. Eligible recipients of foster care prevention services include children and youth and their parents, legal custodians, legal guardians, and kin caregivers when their needs are directly related to the safety, permanent placement, or well-being of the child or youth. If a child or youth is placed in a qualified residential treatment program (QRTP), the court or the Administrative Review Division of the department is required to review the assessment and needs of the child or youth and determine whether placement in the QRTP is appropriate. The bill requires the county department of human or social services (county department) to submit certain evidence to the court during each review and permanency hearing of a child or youth placed in a QRTP. The county department may provide foster care prevention services to a child or youth and the parents or kin caregivers of the child or youth upon the receipt of a report of intrafamilial abuse or neglect or human trafficking. The bill adds the federal Family First as a program to be administered by the department. The bill adds foster care prevention services to the definition of child welfare services.   

To demonstrate that the state conducted the independent systematic review and met the criteria outlined in section 471(e)(4)(C) of the Act and Attachment C to ACYF-CB-PI-18-09, the Prevention and Intake Analyst position was updated to support the analysis, reporting and evaluation needs for FFPSA and Colorado Statute requirements. The position serves as the primary data and reporting lead to develop reports and to provide data, data analysis and evaluation for the FFPSA services and programs to ensure the compliance with the law. The Prevention Data and Reporting Analyst is instrumental in designing and propagating quantitative evaluation methodologies for the statewide FFPSA data collection, analysis and reporting.

Summary of Job Duties:

The Research, Analysis, and Data Team (RAD) is a technical team of SQL writers that exists within the Division of Child Welfare. Our team directly engages with child welfare program leaders in the State of Colorado as well as other County and external stakeholders to solicit, develop and deliver time sensitive ad-hoc data requests and ongoing reports. Furthermore, the team is responsible for the technical aspects of all federally mandated reporting and liaising with our IT partners to QA our data. Finally, we maintain our technical stack of SQL Server as well as our ETL process to support our reporting/analytic platform.

Data collection, Reporting and Data analysis:

• Extracts Prevention and Intake system data from the Child Welfare case management system (Trails), or other related data sources, and uses this data to report data trends and analyses on measures that track county and state performance outcomes.
• Manage accuracy, validity, access, and analysis of Prevention and Intake system data using Trails data and the Results Oriented Management (ROM) reporting database to provide data and analysis for system performance management activities. 
• Performs modification and updates of complex stored procedures to ensure accurate reporting parameters for Colorado's Results Oriented Management Reports (ROM). Creates regulated reports for state and county partners, including daily reports for the state, Hotline County Connection Center (HCCC), and counties by county and hour, weekly reports, monthly reports, and annual reports. Responsible for working directly with ROM vendor.
• Collaborate with county and state program staff as the primary data and reporting lead to assist in monitoring the Human Trafficking screening Tool in compliance with HB16-1224. Serve as State subject matter expert in data analysis related to Prevention and Intake.
• Travel as needed to county hotline call centers to provide technical training on hotline applications which helps counties understand how to properly staff call centers.
• Extraction of the vendor data, including Genesys Interactive Insights, Hosted IVR by CenturyLink, Genesys Desktop, CCPulse using scraping methods to clean, manipulate and integrate for analysis.
• Evaluates the statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency, and accuracy and evaluating sources of information to determine any limitations in terms of reliability or usability. 
• Provides research and data analysis to support the date driven decision making on the evidence based and Trauma informed FFPSA program design, reporting and evaluation.
• Collaborates with the programs and counties to develop a reliable, valid, and Systematic administration of `target outcome' measures.
• Collaborates with county and state program staff as the primary data and reporting lead to design effective tools to monitor the progress and outcomes for prevention programs or services to be rated as promising, supported, or well-supported practices according to the federal guided Programs or Services Rating Criteria.
• Serves as the data, reporting and evaluation expert and provides inputs and guidance for the FFPSA programs, services and practices design in compliance with the federal laws/ policies.
• Analyzes and interpret outcomes data to identify statistically significant differences among sub-populations of candidacy.
• Evaluates the statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency, and accuracy and evaluates sources of information to determine any limitations in terms of reliability or usability.
• Works with the finance unit to help prepare the FFPSA required reports to help Colorado receive the maximum Title IV-E federal funding. 
• Collaborate with the Federal Data Analyst to update and submit Prevention data reporting to Federal portals.

Technical leadership:

• Oversee the ongoing operations of the statewide child abuse and neglect hotline reporting system. Ensure the hotline complies with statute. 
• Co-Chair the ROM work group to gather the reporting requests from counties and other stakeholders, develop the syntax for ROM server stored procedures to import data for ROM system; adjust syntax for database changes; serve as the primary representative to work with ROM vendor.
• Attend meetings, special committees, and/or public forums as the State expert on Prevention and Intake data.
• Participates in the FFPSA program design and attend implementation committee meetings to provide inputs, data and research support.
• Oversees the on-going designs and operations of the statewide FFPSA reporting system.
• Provides the technical support to ensure the design of the FFPSA reports in compliance with the federal laws/ policies.
• Serves as the State lead to provide needed data, information, analysis, and recommendations regarding the FFPSA programs and services to ensure compliance in law. 
• Monitors and diagnoses data from external vendors and OIT for data integrity issues. 
• Prepares data from multiple data systems for the FFPSA reports that cross multiple systems when needed.
• Serves as a liaison and technical expert for the state, county and federal for FFPSA reporting needs.
• Partner with Prevention Subject Matter Experts (SMEs) in the Child Protection and Prevention Services (CPPS) Unit to oversee prevention efforts for State and Federal-defined initiatives.
• Serves as the FFPSA operational lead within the Division of Child Welfare. Facilitates workgroups with internal and external stakeholders and acts as a front-facing leader in the subject area.

Special Duties and Other Duties as assigned:

• Provide training and guidance to other CDHS and county staff on incorporating new data elements and analyses to inform and enhance current practice and policy decisions around child welfare.
• Provide technical expertise to RAD analysts on the Trails database including ROM, SQL, TOAD for Oracle, Crystal Reports and Q&A on Child Welfare knowledge and practice. 
• Maintain the Division's SQL Server database and supervise ROM production. ROM allows counties secure access to outcomes data used in State and Federal performance management processes. This software is being used by the Division to develop and test SQL processes to extract data from Trails for the ROM application, assist in creating data matching processes between Trails and external data systems, and more efficiently extract data from Trails for analysis by the work unit. This position will maintain the SQL Server database within the work unit, create and test new SQL procedures, and extract data using SQL Server for analysis as needed.
• Performs other duties as assigned.

Please note we will be hiring two positions from this posting, the Intake Data Analyst V is substantially similar to the Federal Reporting Analyst: 

The federal reporting liaison position will be working as an intermediary to translate federal reporting requirements into technical data requirements and communicating those needs to IT to make the appropriate changes. The liaison will also be responsible for testing the results of these changes to make sure that they are executed as intended and fulfill the federal reporting requirements. The federal reporting liaison will also be performing ad hoc data requests as necessary. 

We will also be hiring an Intake Data Analyst V, working in similar capacity of this position. The intake data analyst will serve as the expert in all things Child Welfare hotline, referral, assessments to prevention services data in the State of Colorado. The intake analyst will be responsible for gathering business requirements for data requests and translate them into technical SQL code to solve business data needs.

Important Note: Please review your application to ensure completion. For the most equitable applicant experience, CDHS' hiring teams consider only the contents of your application to determine meeting minimum qualifications and for the comparative analysis process. Experience is calculated on a full-time equivalency basis, therefore, it is important to accurately notate the hours you averaged per experience section entry. Volunteer work or related type of experience may be used to meet the qualifications, but must be clearly documented. It is paramount that in the experience portion of the application, the applicant describes the extent to which they possess the education, experience, competencies and background as they relate to the duties outlined in the job announcement.  

MINIMUM QUALIFICATIONS: 

Experience:

• 8 years of SQL and technical data analysis experience or a combination of related education and/or relevant experience in an occupation related to 8 years. 
• Please note: This experience must be clearly documented on your application and the supplemental questions must be answered.

Preferred Qualifications:

• Experience with complex SQL query (will be assessed by manager via a technical test).

• Familiarity with stored procedures would be helpful.

• Experience with data visualization tools such as tableau or power bi would be helpful. 

• Experience in SPSS, Microsoft Office applications, Crystal Reports, SQL query writing, and experience in working with large relational databases.

• This position requires an understanding of performance management in a social services environment. The qualified applicant should understand how decisions on policy and practice impact outcomes and how data can be used to guide these decisions.  

Conditions of Employment:

• This position may require travel within the state of Colorado.
• Standard Background - Name check, TRAILS, CMS and JBITS
• Former State employees who were disciplinarily terminated or resigned in lieu of termination must disclose the information on the application and provide an explanation why the prior termination or resignation should not disqualify the applicant from the current position.  Absent extraordinary circumstances, prior disciplinary termination or resignation in lieu of termination 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 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.

A standard appeal form is available at: www.colorado.gov/spb. If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. The ten-day deadline and these appeal procedures also apply to all charges of discrimination.

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 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 MotivateMe
• 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. 

ADAA 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 ADAAA Coordinator, Nancy Schmelzer.

~THE STATE OF COLORADO IS AN EQUAL OPPORTUNITY EMPLOYER~