SNAP Quality Assurance (QA) Data Specialist

State of Colorado•Denver, CO

6d•Hybrid

About The Position

The Food and Energy Assistance Division is responsible for administering major Federal programs like SNAP, EBT, FDP, S-EBT, and LEAP. The Research, Evaluation, and Data team supports the Supplemental Nutrition Assistance Program (SNAP) by focusing on reporting, data analysis, program evaluation, and process improvement to ensure accurate and timely benefit delivery, program equity, and integrity. This team also supports interagency partnerships for cross-enrollment efforts to combat food insecurity and improve access to social and healthcare services. The team provides direct support to various SNAP units, including Policy, Compliance, Outreach, and SNAP Ed, as well as EBT, Automation, and Food Distribution Program. They also represent SNAP's interests in data sharing and technical assistance for the State’s Strategic Interoperability Plan, collaborating with 64 Colorado counties, HCPF, CDPHE, and the Governor’s Office. The team develops and maintains reporting platforms for county case management and performance monitoring, and ensures compliance with Federal Reporting and Disclosure requirements.

Requirements

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.
Experience applying data management and analysis skills to build evidence that supports performance evaluation with the goal of reducing operational processing errors.
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.
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.

Nice To Haves

SNAP policy experience
Knowledge of statistics & research design
CBMS eligibility system experience
Experience with Oracle database
Experience with Tableau
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.
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.

Responsibilities

Manages SNAP performance data by designing, implementing, maintaining, and ensuring data security, accuracy, and integrity.
Operates across data systems efficiently and effectively.
Uses SQL to reference and integrate data 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.
Develops methods for tracking program information and capturing outcome data for evaluation in a visually understandable context using dashboards, Tableau, and other complex software.
Creates and maintains reports outside of CBMS, FIS, QCS, and Rushmore Case Review Systems databases, requiring the creation and maintenance of data dictionaries to ensure compliance with program reporting requirements.
Extracts data from three to four source databases to capture all necessary information for reporting and corrective action.
Develops and evaluates programming and coding to establish best practices and procedures for combining multiple SNAP data sets.
Communicates strategic performance analysis in internally and externally facing meetings.
Develops reports and dashboards using TOAD, Tableau, and Microsoft Excel to support day-to-day operations and performance management for State SNAP units and counties.
Creates and maintains a library of standard and ad-hoc report code.
Provides information and support to SNAP teams to assist in the development of SNAP federal Corrective Action Plans and CBMS improvements.
Evaluates error trends statewide and in specific areas, providing data for Corrective Action Plans and making recommendations for additional guidance, training, or CBMS improvements.
Performs other duties as assigned, specific to the Department, FEAD, and SNAP Team vision and goals.

Benefits

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
Public Service Loan Forgiveness Program