Database Warehouse Analyst jobs in Honolulu, HI

• 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 develops 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.
• Prepares 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.

• graduation from an accredited college or university with a bachelor's degree in computer science, management information systems, or a related field (scan and attach 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

• an official college transcript,
• a valid driver's license,
• a temporary assignment verification, 
• professional licenses, and/or
• certificates.