CASUAL HIRE - Database Developer & Systems Analyst

• Develops secure database architecture using a commercial no-code platform, that is easily administered by an in-house data specialist.
• Audits and documents all data and reporting requests made across an academic year by various stakeholders.
• Centralizes disparate data formats currently held by multiple parties, integrating them cleanly into a unified database structure.
• Catalogs existing data types, formats, and sources across multiple parties and establishes security protocols based on institutional data governance requirements.
• Designs and implements robust data backup and recovery systems.
• Ensures the system architecture is feature-rich and flexible for a seamless integration with other existing platforms.
• Implements testing procedures to proactively identify and resolve database errors.
• Implements web-accessible data analytics and visualization tools tailored for faculty and staff use.
• Builds specific, reporting templates focused on student retention analytics.
• Creates thorough technical documentation, data dictionaries, and user guides to ensure smooth handoff.
• Trains administrators and users on how to use the system.
• Perform other duties as assigned., 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.

In accordance with Article 10 of the unit 08 collective bargaining agreement, bargaining unit members receive priority consideration for APT job vacancies. As a result, external or non BU 08 applicants may not be considered for some APT vacancies. BU 08 members with re-employment rights or priority status are responsible for informing the hiring unit of their status.

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

Do you have experience in Schema design?, Do you have a Bachelor's degree?, * Possession of baccalaureate degree in Computer Science, Information Technology, Data Analytics, Database Administration, or Management Information System and three (3) years of progressively responsible professional information technology experience with responsibilities for database design, development, and data modeling (e.g., SQL, PostgreSQL, MySQL).

• Considerable working knowledge of database design, development, and data modeling as demonstrated by the broad knowledge and understanding of the full range of pertinent standard and evolving information technology concepts, principles and methodology.
• Considerable working knowledge and understanding of the broad technology, systems, hardware and software associated with database design, development, and data modeling.
• Demonstrated ability to recognize a wide range of intricate problems, use reasoning and logic to determine accurate causes, and apply principles and practices to determine, evaluate, integrate, and implement practical and thorough solutions in an effective and timely manner.
• Proven ability to comprehend, interpret and implement administrative directives and guidance to ensure IT operations align with organizational standards and industry best practices.
• 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.
• Demonstrated experience in ETL (Extract, Transform, Load) processes, specifically merging disparate data formats and consolidating decentralized data silos.
• Demonstrated experience in building or integrating web front-ends with databases and implementing data visualization tools (e.g., Power BI, Tableau, or custom web-based dashboards).
• Demonstrated understanding of the Family Educational Rights and Privacy Act (FERPA.)., * Strong verbal and written skills to translate complex, technical data concepts into actionable advice for non-technical users.
• Project experience using any of the following platforms: Airtable, Knack, Smartsheet, Tableau

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