IT Analyst I

State of Nebraska•Lincoln, NE

1d•Onsite

About The Position

DHHS is seeking a detail-oriented IT Analyst I to join the Children and Family Services (CFS) Data and Analytics team. In this role, you’ll help manage and improve data systems that support Nebraska’s child welfare programs. You’ll design, maintain, and analyze databases, build dashboards that inform decision-making, and ensure accurate state and federal reporting. This position is ideal for someone who enjoys working with data, solving problems, and contributing to better outcomes for children and families across Nebraska. This is an in-office position.

Requirements

Associate Degree in Computer Science/IT and one year of experience in a related area such as working with coding computer applications, relational databases, or related technical/business experience involving application programming, software installation and maintenance, systems programming, or online programming work.
Any equivalent combination of education and experience will be considered.
SQL programming
database design
data troubleshooting
Building visual reports and dashboards in Power BI/Excel
Communicating technical findings clearly to both technical and non-technical audiences
Analyze problems logically and identify IT solutions.
Manage multiple tasks and meet deadlines.
Work collaboratively with team members and stakeholders at all levels.

Nice To Haves

Bachelor’s degree in computer science, Information Technology, Data Analytics, or 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.

Responsibilities

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.