Database Analyst Programmer

UIC; Vicksburg (MS); On-site; USD 95,000 - 125,000; Full time

Job summary

Bowhead seeks a Database Analyst Programmer to support the ERDC contract in Vicksburg, MS. You will maintain a data warehouse, develop data marts, and ensure data accuracy in Oracle with WebFOCUS reporting. Remote work is offered while serving federal project needs.

The role requires 10+ years in computer science, Security+ readiness, TOAD and Power BI expertise, and strong communication to coordinate with senior staff and RM users.

Qualifications

• BA/BS in Computer Science or related field; 10+ years of experience.
• CompTIA Security+ certification may be required.
• Experience with TOAD and Power BI.
• Intermediate to advanced Microsoft Office skills.
• Strong communication and teamwork abilities.
• Ability to work independently and in a team.

Responsibilities

• Reviews data loaded into the data warehouse for accuracy.
• Supports design, development, and maintenance of enterprise data warehouse and data marts.
• Troubleshoots and tunes data warehouse applications.
• Establishes development standards and enterprise model integration.
• Develops database solutions and administration tools.
• Collaborates with senior staff to complete projects.
• Creates reports to track and manage funds by projects.
• Diagnoses data vs application errors using TOAD/WebFOCUS logs.
• May provide work leadership for junior staff.

Skills

Power BI

TOAD

Microsoft Office

Data warehousing

Education

Bachelor of Science in Computer Science

Tools

TOAD

WebFOCUS

Oracle

Tomcat

Job description

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
• Expirience with TOAD and Power BI experience
• Intermediate to advanced level skills in Microsoft Office software suite - Word, Excel, Outlook, PowerPoint
• Ability to communicate effectively with all levels of employees and outside contacts
• Strong interpersonal skills and good judgment with the ability to work alone or as part of a team

Physical Demands: Must be able to lift up to 25 pounds Must be able to stand and walk for prolonged amounts of time Must be able to twist, bend, and squat periodically

Target salary range is between $95,000 - $125,000 commensurate with experience.

Please note that the salary information is a general guideline only. Bowhead considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as, market and business considerations when extending an offer.

SECURITY CLEARANCE REQUIREMENTS: Must be able to obtain a security clearance at the Public Trust level. US Citizenship is a requirement for Public Trust clearance at this location.

#LI-KC1