IT Analyst I

The work we do matters! Hiring Agency: Health & Human Services - Agency 25 Location: Lincoln, NE Hiring Rate: $29.348 Job Posting: JR2025-00019779 IT Analyst I (Open) Applications No Longer Accepted On (If no date is displayed, job is posted as open until closed): 10-02-2025 Job Description: 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. As an IT Analyst I, you will: Database Development and Administration • 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. Data Extraction and Integration • 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. Data Visualization and Reporting • 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. Advanced Data Analysis • 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. Federal and State Reporting Compliance • 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. Requirements/Qualifications: Minimum 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. Knowledge, Skills, & Abilities Knowledge of: • Relational database concepts, data integration, and reporting tools. • Principles of data quality, validation, and compliance reporting. • 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. • 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. • Work collaboratively with team members and stakeholders at all levels. Benefits We offer a comprehensive package of pay, benefits, paid time off, retirement and professional development opportunities to help you get the most out of your career and life. Your paycheck is just part of your total compensation. Check out all that the State of Nebraska has to offer! Benefit eligibility may vary by position, agency and employment status. For more information on benefits, please visit: Equal Opportunity Statement The State of Nebraska values our teammates as well as a supportive environment that strives to promote diversity, inclusion, and belonging. We recruit, hire, train, and promote in all job classifications and at all levels without regard to race, color, religion, sex. age, national origin, disability, marital status or genetics. Current employees of the State of Nebraska should NOT apply on this external career. Instead go to Workday and access the Jobs Hub - Internal Apply app from your home landing page. Apply tot his job