IT Analyst II

State of Nebraska

1d • $35

About The Position

DHHS is seeking a detail-oriented IT Analyst II to join the Children and Family Services (CFS) Data and Analytics team. In this role, you will help manage and enhance data systems that support Nebraska’s child welfare programs. You will design, maintain, and analyze databases, build dashboards that inform decision-making, and support 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 II, you will:

Requirements

• Associate Degree in Computer Science or related field of study and three years related experience or A bachelor’s degree or equivalent in computer science, information systems, mathematics, engineering or other related field and two years of experience. Experience may include application programming, software installation and software maintenance, including systems programming, online programming, database design, analysis and programming using IFS and/or SQL/DS and database administration. Any equivalent combination of education and experience will be considered.
• Knowledge of: database backup and recovery procedures; operating systems and platforms used in organization; commonly used query languages, such as SQL; database management concepts, principles and methods including database logical & physical design, normalization, storage capacity management and backup and recovery; sources, characteristics and uses of the organization’s data assets; data mining and warehousing principles/methods; characteristics of data storage media; data administration and data standardization policies, standards and methods; IT database security principles/methods; technical documentation procedures; project management principles and methods; assigned agency’s IT infrastructure; interrelationships among multiple IT specialties; computer hardware and software, including applications and programming; basic math; principles and processes involved in business and organizational planning, coordination and execution. project management practices; personnel management practices; principles and processes involved in business and organizational planning; administering relational database software; internal system program code and functions within SQL/DS software; capacity planning concepts and processes; SQL language; software product MACRO coding concepts; Network software protocols and products, such as TCP/IP, SNA, APPN, APPC and CM/2; Network hardware component configuration and capabilities (ie: PC's, LAN's, Network connections for hardware, communication lines); Computer Operations duties, requirements and procedures; Network concepts and facilities and hardware components.
• Skill in: writing computer programs for various purposes; using math to solve problems; reading comprehension; analyzing needs and product requirements to create a design (operations analysis); technology design (generating or adapting equipment and technology to serve user needs); testing – conducting tests to determine whether equipment, software or procedures are operating as needed; communicating, both orally and in writing; problem identification; information gathering – knowing how to find information and identifying essential information; information organization; implementation; information planning - developing approaches for implementing an idea; synthesis/reorganization of information to better approach problems or tasks; observing and evaluating the outcomes of a problem solution to identify lessons learned or redirect efforts; systems evaluation; systems perception – determining when important changes have occurred in a system or are likely to occur; troubleshooting; time management; technical documentation/developing user instructions; modifying systems and database configurations to correct problems that affect the confidentiality, integrity and availability of data; monitoring the performance of others; applying data mining, storage and warehousing methods; researching alternative technical solutions. analytical thinking; judgment and decision making; when tuning the multiple processing platforms or evaluating software products; training lesser skilled or knowledgeable personnel; presentation of information/instructional material via formal class presentation or one-on-one; developing constructive and cooperative working relationships with others; information organization; solving problems; testing; troubleshooting; time management; monitoring processes; problem identification
• Ability to: read and understand information and ideas presented verbally and in writing; communicate information and ideas, both orally and in writing, so others will understand; reason deductively – apply general rules to specific problems to come up with logical answers; deciding if an answer makes sense; correctly follow a given rule or set of rules in order to arrange things or actions in a certain order; reason inductively – combine separate pieces of information or specific answers to problems to form general rules or conclusions; come up with a logical explanation for why a series of seemingly unrelated events occur together; design, develop and maintain database operations; create reports and manipulate data in response to customer requirements; monitor database performance and tune database operations; generate complex queries and reports; define and allocate storage capacity in the design of data management systems; develop data dictionary definitions, data models, metadata repositories and other data management tools; apply new and improved approaches to the design, development and implementation of data mining, warehousing and related storage and retrieval systems; execute a variety of database utility functions; assist customers in navigating and accessing databases using various interface methods; implement operating systems procedures for running timed or scheduled events such as file backups; produce database design schema for integrating source data into data management systems; use modeling tools and approaches to meet the unique requirements of the assignment; return disrupted database systems to normal operations; optimize database performance & tune database operations; adapt new and improved approaches to the design, development and implementation of data mining, warehousing and related storage and retrieval systems. prepare clear and concise evaluations of monitoring results; interact with a wide range of highly technical oriented personnel; develop objectives and strategies; communicate with vendors in highly technical language; read and interpret system dumps; determine time, cost, resources or materials needed to perform an assignment; provide guidance and direction to workers; reason inductively (combine separate pieces of information to form general conclusions/come up with a logical explanation for why a series of seemingly unrelated events occur together); resolve conflict with others; develop long range objectives and strategies to achieve the objectives.

Nice To Haves

• 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

Responsibilities

• 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 using Power BI and Excel Translate complex datasets into actionable insights for executive leadership, field staff, federal agencies, and public stakeholders Incorporate trend analysis and predictive insights into reporting to support proactive decision-making
• Advanced Data Analysis Conduct statistical and predictive analysis using tools such as R or Python Translate analytical findings into clear business recommendations and technical documentation Support program evaluations through IT-based analytical frameworks
• Federal and State Reporting Compliance Develop and maintain automated processes for compiling, validating, and submitting federal reports (e.g., AFCARS, NCANDS) Monitor reporting systems for errors, troubleshoot issues, and implement technical solutions to ensure compliance Document technical workflows to support reproducibility and audit readiness
• Leadership Mentor junior IT Analysts May lead during logical database design sessions

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.
• For more information on benefits, please visit: https://statejobs.nebraska.gov/index.html#benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree