Programmer Analyst

POSITION SUMMARY

Under the direction of the Supervisor, creates and maintains application systems, performing front-end, back-end, and database development using an Agile methodology.   Responsibilities include collaborating with the Application Support team and business users to define project objectives and interpreting those requirements to produce an appropriate physical database design and user interface.  Codes and tests new applications, system enhancements, and bug fixes.  In addition, performs training on the use of new features and system modifications while providing ongoing support.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Key Responsibilities

1. Analysis & Design
   • Meets with Application Support team and business users to identify system, interface, and reporting requirements.
   • Creates and modifies database objects as appropriate to support system objectives.  Understands and updates entity relationship diagrams and documentation to reflect changes to table structures.
2. Application Coding
   • Constructs system prototypes early in the development lifecycle based on user specifications.  Demonstrates prototypes to users to obtain feedback on the accuracy of the system requirements.
   • Creates multi-user systems using a three-tier application structure.   Codes user interfaces and reports based on requirements.
   • Develops front-end user interfaces using C#, Kendo UI, Angular, HTML, JavaScript, and CSS.
   • Builds back-end interfaces with C# and Microsoft's entity framework.
   • Implements stored procedures using Oracle PL/SQL.
   • Integrates HDS systems with externally developed modules and packages.
3. Unit and System Testing
   • Writes scripts to perform integration and unit testing to ensure accuracy of system changes.
   • Assists Application Support team and users in developing test plans and scenarios.
4. Training and User Support
   • Assists with training key personnel on the use of new features and system enhancements.
   • Responds to questions from Application Support team and business users.
5. Documentation and Source Code Control
   • Creates program documentation to assist with future development and system maintenance.  Writes deployment scripts used to move systems to production.
   • Follows departmental policies for program changes.  Complies with HDS procedures to ensure that all modified source code is checked into the version control system.
   • Assists Information Technology department in answering and troubleshooting helpdesk calls as necessary during high volume periods or during periods of low staffing.

MINIMUM QUALIFICATIONS AND EXPERIENCE

Education

Bachelor’s degree in Information Systems, Computer Science, or an equivalent combination of education, training or work experience.

Experience 

1. Two years of experience in application development, or an equivalent combination of education, training or work experience.
2. Knowledge of basic SQL query language and database design principles, preferably for Oracle.
3. Experience with Visual Studio, MVC, .NET, Entity Framework, Nuget packages, Oracle PL/SQL, and Git.
4. Familiarity with website design using HTML, JavaScript, CSS, C#, Kendo UI, Angular, and Drupal.  Experience with Apache and Internet Information Services (IIS)  is preferred.
5. Background working in an Agile environment using a project tracking tool such as Jira.
6. Familiarity using Windows and Microsoft Office (e.g. Outlook, Word, Excel, and PowerPoint).

Skills and Knowledge

1. Ability to organize, analyze and solve complex problems with attention to detail and accuracy.
2. Ability to handle multiple tasks and prioritize with some distractions.
3. Ability to handle information in a confidential manner and maintain compliance with HDS policies and federal/state laws.
4. Ability to communicate both orally and in writing with all levels of staff, customers, and vendors on sensitive matters.

Note: The above information in this description has been designed to indicate the general nature and level of work performed by an employee in this classification.  It is not to be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications of employees assigned to this job.  Hawaii Dental Service has the right to add to, revise, or delete information in this description.  Reasonable accommodation will be made to enable qualified individuals with disabilities to perform the essential functions of this position.