IT Analyst I - CFS Data and Analytics

The State of Nebraska’s Department of Health and Human Services is seeking an IT Analyst I to support the Children and Family Services Data and Analytics team. The role manages and improves data systems, develops databases and dashboards, performs advanced analysis, and ensures accurate state and federal reporting for child welfare programs.

What you'll do:

• Create, maintain, and troubleshoot relational databases to support operational and reporting needs. Design and optimize data tables, indexes, and relationships to improve performance and data integrity. Implement data quality controls and validation rules within systems
• Develop and run SQL queries, stored procedures, and scripts to extract data from N-FOCUS/DBX and other systems. Automate extract-transform-load (ETL) processes to ensure accurate and timely data flows. Integrate external datasets with internal databases for comprehensive analysis
• Build advanced dashboards and reports in Power BI and Excel. Translate complex datasets into actionable insights for executive leadership, field staff, federal agencies, and public stakeholders. Incorporate predictive analytics and trend analysis into reports to support proactive decision-making
• Conduct statistical and predictive modeling using R or Python. Translate analytical findings into clear business recommendations and technical documentation. Support program evaluations with IT-based analytical frameworks to measure effectiveness and outcomes
• Develop automated processes for compiling, validating, and submitting federal reports (e.g., AFCARS, NCANDS). Monitor reporting systems for errors, troubleshoot issues, and implement IT solutions for compliance. Document technical workflows to ensure reproducibility and audit readiness

What they're looking for:

• Associate Degree in Computer Science/IT and one year experience in a related area such as working with coding computer applications relational databases related business/technical experience involving application programming, software installation and maintenance, systems programming and online programming work. Any equivalent combination of education and experience will be considered
• Knowledge of relational database concepts, data integration, and reporting tools; principles of data quality, validation, and compliance reporting; and best practices for designing dashboards and visualizations
• Skills in SQL programming, database design, and data troubleshooting; building visual reports and dashboards in Power BI/Excel; and communicating technical findings clearly to both technical and non-technical audiences
• Ability to analyze problems logically and identify IT solutions; manage multiple tasks and meet deadlines; and work collaboratively with team members and stakeholders at all levels
• Bachelor's degree in Computer Science, Information Technology, Data Analytics, or a related field
• Strong technical skills in SQL, Power BI, and Excel
• Familiarity with Snowflake, DBX, or similar data warehouse environments
• Experience designing dashboards and reporting solutions for leadership decision-making
• Familiarity with child welfare or human services data systems
• Knowledge of statistical analysis tools such as R or Python

Benefits:

• Paid time off
• Retirement
• Professional development opportunities