SNAP Quality Assurance (QA) Data Specialist

Colorado Department of Human Services
Denver, United States of America
11 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 93K

Job location

Remote
Denver, United States of America

Tech stack

Microsoft Word
Microsoft Excel
Data analysis
Computer Programming
Databases
Data Dictionary
Data Mining
Data Security
Data Sharing
Data Systems
Relational Databases
Federal Information Processing Standards (FIPS)
Oracle
Software Systems
SQL Databases
Tableau
Performance Monitor
Toad (Software)
Data Management

Job description

The Food and Energy Assistance Division is responsible for the administration of several major Federal programs, such as the Supplemental Nutrition Assistance Program (SNAP), Electronic Benefit Transfer (EBT) program, Food Distribution Programs (FDP), the Summer Electronic Benefit Transfer (S-EBT) program, and the Low Income Energy Assistance Program (LEAP) and associated support systems and subprograms that address food and energy needs for Coloradans. In a state-run, county-administered system, this unit is responsible for the oversight of county operations. The Research, Evaluation, and Data team exists to support the Supplemental Nutrition Assistance Program (SNAP) in reporting, data analysis and interpretation, program evaluation, and process improvement to ensure the accurate and timely delivery of benefits, program equity, and integrity. Additionally, the team is integral in supporting and pursuing interagency and external partnerships to further cross-enrollment efforts to address food insecurity needs and access to social and healthcare services to help Coloradans achieve economic security and independence.

The Research, Evaluation, and Data team provides direct support to the following units within the Division: SNAP Policy, SNAP Compliance, SNAP Outreach, SNAP Ed. Electronic Benefits Transfer (EBT), Automation, and Food Distribution Program. The team also represents SNAP's interest by providing program-specific data sharing guidance and technical assistance to support the State's Strategic Interoperability Plan, working in partnership with the 64 Colorado counties, Health Care Policy & Finance (HCPF), Colorado Department of Public Health and Environment (CDPHE), and the Governor's Office. The team produces and maintains reporting platforms to ensure the distribution of resources to assist counties with case management and performance monitoring. The unit is also responsible for ensuring compliance with Federal Reporting and Disclosure requirements., This position is a staff authority and pacesetter who has a unique level of technical expertise in SNAP Quality Assurance data reporting systems and analytical applications for the Department, specifically with the combination of multiple data systems to include the Rushmore Case Review System and, Colorado Benefits Management System. EBTedge and Quality Control QSC system. Overall, the position exists to support the Division's policy and programming decisions related to SNAP eligibility data and performance metrics of Application Processing Timeliness (APT), Recertification Processing Timeliness (RPT), Payment Error Rate (PER), and Case and Procedural Error Rate (CAPER). The staff authority directly influences management decisions beyond the agency, such as Office and Division Directors, various internal program managers, staff from the Strategic Operations and Solutions (SOS) team, and the Food and Nutrition Service of the United States Department of Agriculture. This position accesses SNAP performance data from many data systems and designs and builds statewide data reporting systems, which have a transformative impact on how the Division is able to assess and manage performance at the Executive Management level, at the program level, and at the county level. This position represents the Division/CDHS and shares department data at various external meetings and other venues, as required. Specifically, the position manages SNAP performance data by designing, implementing, maintaining, and ensuring data security, accuracy, and integrity, and operates across data systems efficiently and effectively. This position is responsible for using SQL to reference and to integrate data extracted from DSS01, FIS database (EBT edge), federal QCS database, Rushmore Case Review System data, and other source systems to facilitate analysis and improve operational efficiency and decision-making. This position also develops methods for tracking program information and capturing outcome data for evaluation in a visually understandable context using dashboards, Tableau, and other complex software., * This position has been delegated as the staff authority for SNAP Quality and Performance data and has a unique level of knowledge in multiple systems elements, their general architecture and processing, and expertise in extracting appropriate data from multiple data sources to solve a particular question or problem. This position creates and maintains reports outside of CBMS, FIS, QCS, and Rushmore Case Review Systems databases, which require creating and maintaining data dictionaries to ensure compliance with program reporting requirements. This position must be sufficiently skilled to extract data from three to four source databases to capture all the information necessary to inform reporting in order to take action for corrective action. This position develops and evaluates programming and coding to establish best practices and procedures for combining the multiple data sets of SNAP information. Communicates strategic performance analysis in internally and externally facing meetings., * As staff authority in SNAP Quality and Performance Data, this position's knowledge of the content, architecture, and governance regulating the various databases (CBMS, FIS, QCS) are critical for the development of reports and dashboards using TOAD, Tableau, and Microsoft Excel to support day-to-day operations and performance management for the State SNAP units and counties. These systems are complex in nature and often require careful judgment and analysis to determine appropriate extractions. This position is responsible for creating and maintaining a library of standard and ad-hoc report code.

Summary of Corrective Action Plan and CBMS Recommendations:

  • This position provides information and support to the SNAP teams to assist in the development of SNAP federal Corrective Action Plans and CBMS improvements. This position works closely with other FEAD team members to evaluate error trends both statewide and in specific areas. Using the information gathered from this analysis, the position provides data for Corrective Action Plans and makes recommendations for additional guidance, training, or CBMS improvements to prevent future errors.

Summary of All Other Duties as Assigned:

  • Other duties as assigned, specific to the Department, FEAD, and SNAP Team vision and goals., * Must pass a Name Check Only Background ONLY: This position has NO direct contact with vulnerable persons. Name check only includes: CBI check (no fingerprints), Colorado Court Database check, and Medicare Fraud Database.

  • Motor Vehicle Record Check: This position drives a state-owned vehicle, either in an ongoing capacity while performing their normal day-to-day job duties, OR on occasion for trainings/meetings/client visits/etc.

  • Travel: In-state travel to county offices may be required.

  • This position requires State of Colorado residency at the time of application (unless otherwise identified in the posting), and residency within the state throughout the duration of employment in this position.

  • Former State employees who were disciplinarily terminated or resigned in lieu of termination must:

  • Disclose that information on the application.
  • Explain why the prior termination or resignation should not disqualify you from the current position.
  • Provide your employee number from your 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.

CDHS Selection Process Explanation Employment history is calculated on a full-time basis (40/hrs per week). Part-time employment is calculated on a prorated basis to determine qualifications. Be sure your application specifically addresses your qualifications, experience, work products, and accomplishments as they relate to the position and minimum requirements., A Human Resources Analyst will review the work experience/job duties sections of the online job application to determine whether your experience meets the minimum qualifications for the position. You must complete the official State of Colorado online application. Cover letters and resumes WILL NOT be reviewed during the minimum qualifications screening process. You must specifically document your work experience and qualifications in the application form. Do not use "see resume" or "see attached." You must meet the minimum qualifications to continue in the selection process. Part-time work experience will be prorated. Comparative Analysis Process - Structured Application Review

After minimum qualification screening, the comparative analysis process will involve reviewing and rating of all the information you submit. The comparative analysis step may also include your results from standardized testing. Your Work Experience/Job Duties Document your work experience/job duties to the extent to which you possess the skills, education, experience, minimum qualifications, and preferred qualifications.

If listed, answer all supplemental questions as your answers to these questions will be evaluated during this phase. Provide at least 4-8 sentences for each supplemental question. Supplemental Questions

Answer the supplemental questions completely and thoughtfully. We will rate your answers based on the content of your response and your writing skills (spelling, grammar, and clarity of your writing)., * We believe in a people-first approach: We prioritize the needs, well-being, and dignity of the individuals, families and communities we serve. We commit to respect, fairness and access in every decision, policy and interaction. We engage client voices and experiences in the development and implementation of the services we provide.

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

ADA Accommodations

CDHS is committed to a Colorado for 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. This includes completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or performing 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 cdhs_ada@state.co.us. EEO Statement

The State of Colorado is an equal opportunity employer

We are committed to increasing a "Colorado for ALL" of our staff and providing culturally responsive programs and services. Therefore, we encourage responses from people of all backgrounds and abilities. The State of Colorado believes that a "Colorado for ALL" drives 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. Additional Support For Your Application Toll Free Applicant Technical Support If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) call NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application 1) ensure your documents are PDF or Microsoft Word files and 2) close the document before you attempt to upload (attach) it.

Requirements

Do you have experience in Technical Proficiency?, Seven (7) years of relevant experience in conducting data management, data reporting, and data analysis, including analysis of large, complex relational databases, data extraction and manipulation. Must have experience applying data management and analysis skills to build evidence that supports performance evaluation with the goal of reducing operational processing errors. Must demonstrate proficiency in extracting relational data using SQL, interpreting complex metrics to form actionable programmatic recommendations, and effectively communicating insights to stakeholders to drive quality improvement., A combination of related education in Public Health, Economics, Public Policy, Research and Methodology, Statistics, Mathematics and/or relevant experience in conducting data management, data reporting, and data analysis, including analysis of large, complex relational databases, data extraction and manipulation equal to seven (7) years. Requires 4+ years of experience applying data management and analysis skills to build evidence that supports performance evaluation with the goal of reducing operational processing errors. Must demonstrate proficiency in extracting relational data using SQL, interpreting complex metrics to form actionable programmatic recommendations, and effectively communicating insights to stakeholders to drive quality improvement., * SNAP policy experience

  • Knowledge of statistics & research design
  • CBMS eligibility system experience
  • Experience with Oracle database
  • Experience with Tableau
  • COWINS Partnership Agreement: Relevant years of State service, prorated for part-time, that contribute to a candidate's position-related knowledge, skill, ability, behavior, or other posted competency should be considered as a preferred qualification and given weight under the process.
  • TRANSFERS ONLY : Relevant years of State service will be considered as a preferred qualification and given the weight of at least 15% of the overall score under the process., + Relevant years of state service experience.

Benefits & conditions

1525 Sherman Street, Denver, CO 80203 Hybrid work $71,544 - $93,012 a year - Full-time, Pulled from the full job description

  • Loan forgiveness
  • 401(k)
  • Health insurance
  • Health savings account
  • Dental insurance
  • Life insurance
  • Disability insurance, If your goal is to build a career that makes a difference, join 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. Each of us is committed to contributing to a safe and accessible CDHS. 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 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
  • State of Colorado Employee BenefitHub Resource Center
  • 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.

Apply for this position