Database Analyst Programmer

Overview

DATABASE ANALYST PROGRAMMER (ERDC):

Bowhead seeks a Database Analyst Programmer to support the Engineering Research and Development Center (ERDC) contract located in Vicksburg, MS. The Database Analyst Programmer will support a data warehouse environment which includes data design, database architecture, metadata and repository creation.

This position is fully remote.

Responsibilities

• Reviews data loaded into the data warehouse for accuracy.

• Responsible for the development, maintenance, and support of complex enterprise data warehouse system and corresponding data marts.

• Troubleshoots and tunes complex data warehouse applications. Conducts research into new data warehouse applications and determines viability for adoption.

• Establishes development standards, evaluates existing subject areas stored in the data warehouse and incorporates existing subject areas into an enterprise model.

• Ability to independently analyze, compile requirements, and develop database solutions for full featured database systems and related tools.

• Ability to plan, design, develop, and modify complex databases structures, and database administration tools using current products and programming languages.

• Ability to work with other senior technical and user staff to complete projects.

• Responsible for keeping the ERDC Data Warehouse updated and to create reports for users and customers to view the data to track and manage funds by projects. Users will request new reports, changes, and report errors to the Resource Management (RM) office through the ERDC Data Warehouse helpdesk.

• Responsible for correcting the error or complete the request in a development environment. Once completed, will notify RM through email that the changes are ready to be validated on development. Once RM validates the changes, the changes are moved to the production environment.

• Responsible for troubleshooting the ERDC Data Warehouse to determine if it is an error in the data in the Oracle database or if it is an application error in WebFOCUS, our reporting software. If the error is in the database, TOAD will be used to modify the package or procedure used to gather the data. If the error is in the report, Tomcat and WebFOCUS logs on our UNIX application server will be used to track the error in the application software.

• May provide work leadership for lower level employees.

Qualifications

• BA/S in Computer Science or related field and an additional eight to ten (10+) years of professional experience.

• A CompTIA Security+ certificate may be required prior to starting this position

• Experince with TOAD and Power BI experience