Database Analyst

Duties Summary

Designs, develops, and/or modifies electronic database management systems and procedures for a department; analyzes and evaluates operating methods and practices relative to the information needs of specific programs and activities; develops database application programs to meet reporting requirements; develops procedural support manuals; performs other related duties as required.

There is one (1) immediate permanent full-time vacancy with the Office of Aging - ACCESS Division in Hilo.

The eligible list may be used for other permanent and temporary vacancies as they arise during the life of the list. Temporary appointment may lead to conversion to permanent appointment.

Examples of Duties

Analyzes departmental requirements by interviewing users, researching documentation, and observing operations.

Maintains a department's database system and software; extracts, validates, and analyzes data for recommendations and reporting purposes.

Analyzes the information gathered to determine data characteristics, relationships, accessing criteria, reporting formats, Federal and/or State reporting requirements, etc., and reviews the resulting reports with the user to determine validity or to determine if adjustments are needed.

Analyzes detailed requirements and designs database structures with appropriate accessing capabilities and relationships between data elements to satisfy all user requirements.

Analyzes, designs, codes, tests, and performs other programming tasks required to establish, maintain, and modify an information system.

Prepares detailed operating procedures and develops an efficient workflow design for the proper input and maintenance of data and the effective use of the data; continually evaluates and recommends revisions to improve workflow and efficiency.

Designs and develop new forms as necessary for integration with electronic database management system.

Serves as the department's system administrator or co-administrator; assigns user logons and monitors all system usage to ensure security and database integrity.

Participates in the development of requests for proposals and in evaluating proposals in the selection of a vendor.

Prepare reports of findings with recommendations.

Coordinates and installs the hardware, system software, and application software.

Participates in the implementation, maintenance, and troubleshooting of local area networks and/or the department's database management system.

Performs field surveys using GPS; assists with collecting, correcting, analyzing, and summarizing data.

Trains departmental employees in database management systems and procedures; resolves problems where necessary.

Supervises data entry; reviews and controls output data for completeness and accuracy; reviews work in progress to ensure timeliness; takes corrective actions as necessary.

Coordinates support from hardware and/or software vendors in resolving problems and questions encountered by users.

Keeps abreast of current developments in the field of electronic database management systems.

Performs other related duties as required.

Minimum Qualification Requirements

Training and Experience:

A combination of education and experience substantially equivalent to:

graduation from an accredited college or university with a bachelor's degree (scan and attach a copy of your official college transcript to your application), and

one and one-half (1-1/2) years of experience in any combination of the following:

programming, analysis, and design of database management systems, or

installation, maintenance, and troubleshooting of database management software, and

possession of a valid State of Hawai‘i driver's license (Class 3) or any other valid comparable driver’s license at time of filing. (You will be required to submit your valid driver's license at time of hire.)

Examination: All applicants who meet the minimum qualification requirements will be assigned a score of 70 points. An education and experience evaluation will be conducted based on the applicant's training, education and experience as presented in the application.

Please read the minimum qualification requirements carefully. Be certain to list all pertinent training and experience, as this may be important in determining your examination score. It is essential that the applicant describe fully the duties and responsibilities of each position held, specify the date of each position held (from and to, month and year), and indicate the number of hours worked per week.

Attach all required documentation (e.g. official transcript, professional license(s)/certification(s), DD-214, etc.) at the time of submitting your application.

Note: In-person interviews and/or further testing in Hawai'i County may be required at the discretion of the hiring department/agency. If in-person interviews and/or further testing are required, applicants who are referred to the hiring department/agency must be available to participate in person and at their own expense at that phase of the selection process.

Knowledge of: electronic database management systems and their analysis, design, development, implementation, and support; the operation, characteristics, and capabilities of various types of electronic database management systems, hardware, software, and telecommunications; and research and statistical methods and techniques.

Ability to: gather, analyze, correlate, and evaluate facts, and make sound judgments; determine feasibility of converting various work processes to computerized operations; extract and analyze; plan efficient data flow procedures and processes and integrate these into the overall database management system; prepare clear and concise reports on operating procedures; follow oral and written instructions; and work cooperatively with consultants, vendors, departmental officials, and employees.

Physical Requirements: Persons seeking appointment to positions in this class must meet the health and physical condition standards deemed necessary and proper to perform the essential functions of the position with or without reasonable accommodations.

Physical Effort Grouping: Light

Benefits of County employment: The County of Hawai‘i offers a competitive compensation package. Your total compensation is comprised of your salary and a generous range of valuable benefits, subject to eligibility requirements.

Flexible Working Arrangements: Options may include alternate work schedules (4-10) and flexible working hours. (Not all Departments/Agencies participate and not all positions are eligible.)

Vacation: Start accruing paid vacation time immediately upon hire – up to 21 days per year.

Sick Leave: Start accruing paid sick leave time immediately upon hire – up to 21 days per year.

Holidays: The County provides 13 paid holidays per year (plus General Election Day when applicable).

Training and Development: The County has a variety of training and development opportunities for employees.

County Tuition Reimbursement Program: This scholarship program rewards employees who take the initiative to advance their education and learning.

Public Service Loan Forgiveness (PSLF) Program: You may be eligible for this federal program which forgives portions of federal student loans for individuals working in public service.

Retirement Plan:The Employees’ Retirement System is a qualified defined benefit public pension plan that provides retirement, disability, survivor and other benefits to all eligible full-time and part-time county employees in the State of Hawaii as well as their beneficiaries.

Deferred Compensation: Save additional money for retirement - this voluntary supplemental retirement savings plan allows for the investment of tax-deferred contributions.

Flexible Spending Plan: Use pre-tax dollars to pay for qualified dependent care and/or medical expenses, as well as insurance premiums.

Health Benefit Plans: The County of Hawai‘i offers a variety of health benefit plans for eligible employees.

Employee Assistance Program (EAP): This voluntary assistance program provides employees and their family members with free professional and confidential assistance in overcoming personal and work-related problems.

Group Life Insurance: Free life insurance policy for active employees.

Credit Union Membership

Other Leaves: You may be eligible for other leaves, including Family Leave, Funeral Leave, Leave Sharing, Military Leave, Donor Leave, Victims Protection Leave, as well as leave for Parent-Teacher Conferences, Disaster Relief, Blood Bank Donations, and Jury Duty.

All benefits are subject to eligibility requirements and change due to legislative actions and/or changes negotiated through collective bargaining. Please check out the benefits tab for additional information.

Supplemental Information

Please scan and attach these supporting documents to your on-line application, if required:

an official college transcript,

a valid driver's license,

a temporary assignment verification,

professional licenses, and/or

certificates.

Veterans applying for veteran's preference points shall also scan and attach their DD-214 form and as needed, their VA claim letter to the on-line application.

ELECTRONIC NOTIFICATION TO APPLICANTS:

Please ensure that the email address and mobile phone number you provide is current, secure, and readily accessible to you. We will not be responsible in any way if you do not receive our emails and text messages or fail to check your email box or NEOGOV account INBOX in a timely manner. Checking your NEOGOV account INBOX daily is recommended and is the most secure method to check on notices sent to you. This is a new feature created by our vendor, NEOGOV.

Please add to your contact list. Open your NEOGOV account using your user name and password. In the upper right hand corner of the account is your name, and under your name, click on INBOX to view all notices sent you. The notices will appear here in the INBOX even in the event you don't receive it on your cell phone, computer, or other electronic device. This is the best way to check and view all notices sent to you.

You will receive a confirmation email upon successfully submitting your application. Failure to receive this confirmation email, indicates that your application was not submitted.