(Casual Hire) IT Specialist for System Analysis & Documentation

The IT Specialist for Systems Analysis & Documentation supports Hawai’i P–20’s statewide longitudinal data systems and related information technology initiatives. The position assists with documenting enterprise data systems, databases, business processes, data flows, SQL code, stored procedures, functions, and data integration workflows to support operational continuity, knowledge transfer, system modernization, and organizational sustainability. The position also supports systems analysis, data extraction, data loading, quality assurance, technical documentation, and project activities. Working closely with technical and program staff, the incumbent helps maintain documentation standards, improve operational processes, and support the ongoing development of Hawai’i P–20’s education and workforce data infrastructure., System Analysis and Documentation

• Document enterprise databases, data systems, business processes, workflows, data flows, and system architectures.
• Analyze and document SQL queries, stored procedures, functions, scripts, ETL processes, and related technical components.
• Assist in documenting data integration processes, business rules, system interfaces, and operational workflows.
• Develop and maintain technical documentation, data dictionaries, metadata repositories, system inventories, and standard operating procedures.
• Maintain organized documentation repositories and version-controlled knowledge bases to support organizational sustainability and knowledge transfer.

Data Management and Technical Support

• Assist with data loading, extraction, transformation, validation, and quality assurance activities using SQL and related tools.
• Support the preparation, organization, and validation of datasets for reporting, analytics, research, and program evaluation activities.
• Assist in troubleshooting data, system, and workflow issues and documenting resolutions.
• Support maintenance of databases, reporting environments, and related information systems as assigned.

Project and Operational Support

• Assist with project tracking, task management, implementation activities, testing, and operational support.
• Support the preparation of reports, presentations, summaries, diagrams, and other project documentation.
• Coordinate with staff, vendors, consultants, and stakeholders to gather information and support documentation and analysis activities.

Other duties as assigned.

• Possession of Graduation from an accredited four-year college or university with a bachelor’s degree in Information Systems, Computer Science, Data Science, Information Technology, Management Information Systems, Engineering, Mathematics, Statistics, or a related field, and three (3) years of progressively responsible professional experience with responsibilities for systems analysis, database administration, database development, or technical documentation; or an equivalent combination of education and relevant experience.
• Considerable working knowledge of principles, practices and techniques in the area of systems analysis, database development, or technical documentation as demonstrated by the broad knowledge of the full range of pertinent standard and evolving concepts, principles and methodologies.
• Considerable working knowledge and understanding of applicable federal and state laws, rules, regulations and theories and systems associated with data systems, data sharing, and student privacy (FERPA).
• Demonstrated ability to resolve wide ranging complex problems through the use of creative reasoning and logic to accurately determine the cause of the problems and the resolution of the problems in an effective, innovative and timely manner.
• Demonstrated ability to interpret and present information and ideas clearly and accurately in writing, verbally and by preparation of reports and other materials.
• Demonstrated ability to establish and maintain effective working relationships with internal and external organizations, groups, team leaders and members, and individuals.
• Experience working with relational databases and SQL, including the ability to create and modify SQL queries and understand database objects such as views, stored procedures, and functions.
• Experience analyzing and documenting technical systems, business processes, data workflows, or information systems.
• Familiarity with database concepts, data structures, and system analysis methodologies.
• Basic understanding of data integration, data pipelines, or ETL processes.
• Proficiency with Microsoft Office applications, particularly Excel, Word, and Visio or similar diagramming tools.
• Strong analytical, organizational, problem-solving, and documentation skills, with attention to detail and the ability to maintain accurate technical documentation.
• Ability to communicate effectively, both orally and in writing.
• Ability to work independently and collaboratively in a team environment.
• Willingness and ability to learn new technologies, systems, and data management practices., * Experience documenting legacy systems, business processes, technical workflows, operational procedures, or system architectures.
• Experience with Microsoft SQL Server, including development and optimization of complex SQL queries, stored procedures, functions, and performance tuning techniques.
• Experience with data integration, workflow automation, ETL/ELT tools, enterprise data pipelines, or related technologies.
• Experience with reporting, dashboard development, business intelligence, data visualization, or analytics platforms.
• Experience with scripting or programming languages such as Python, PowerShell, R, or similar technologies.
• Familiarity with version control and documentation management practices, such as Git.
• Knowledge of metadata management, data governance, data quality management, master data management, identity resolution, record linkage, or related enterprise data management practices.
• Experience working with education, workforce, research, government, or other large-scale integrated data systems.
• Experience supporting data governance, system modernization, knowledge management, organizational documentation, or business process improvement initiatives.

Pulled from the full job description

• Paid holidays

The University of Hawai’i is an Equal Opportunity Institution and is committed to a policy of nondiscrimination in employment, including on the basis of veteran and disability status. For more information, visit: https://www.hawaii.edu/offices/eeo/policies/ Employment is contingent on satisfying employment eligibility verification requirements of the Immigration Reform and Control Act of 1986; reference checks of previous employers; and for certain positions, criminal history record checks.

In accordance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act, annual campus crime statistics for the University of Hawai’i may be viewed at: https://www.hawaii.edu/titleix/help/campus-security/, or a paper copy may be obtained upon request from the respective UH Campus Security or Administrative Services Office.

Accommodation Request: The University of Hawai’i complies with the provisions of the Americans with Disabilities Act (ADA). Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the EEO coordinator directly. Determination on requests for reasonable accommodation will be made on a case-by-case basis. For further information, please refer to the following link: https://www.hawaii.edu/offices/eeo/accommodation-request/

You must create an Indeed account before continuing to the company website to apply