IT Analyst I at State of Nebraska in Omaha, NE

Summary: The State of Nebraska is seeking a detail-oriented IT Analyst I to join the Children and Family Services Data and Analytics team. In this role, you will manage and improve data systems that support Nebraska’s child welfare programs, design databases, build dashboards, and ensure accurate reporting. 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 Required Qualifications: - 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 Preferred Qualifications: - 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 Required Skills: SQL, Power BI, Excel, Relational databases, Data integration, Dashboard design, Data quality control, Statistical analysis, R, Python, ETL processes, Compliance reporting Benefits: Comprehensive package of pay, benefits, paid time off, retirement and professional development opportunities