We support many of our clients by developing, maintaining and hosting enterprise applications that span consumer websites to back-end business processes. We are looking for a Database and ETL Developer to supplement one of our client teams.
Develop and enhance database and ETL solutions for enterprise applications:
Architect a database and ETL solution for new applications by understand the business requirements developing a database architecture that utilizes database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc).
Document database architecture in MS Visio.
Create test plans that will ensure the database architecture meets customer specifications.
Create interface diagrams that include function maps to the application.
Write scripts to create database, create tables, create constraints, functions, triggers.
Support existing databases by performing maintenance tasks
Conduct ad-hoc analysis to help answer clients’ business questions.
Deploy scripts into production.
Address production issues as they arise.
Work with team members. Due to the sophistication of the application, BMK uses a team approach that utilizes Database Developer, Application Developer, and Business Manager.
Work respectively with team members
Manage issues and conflict responsibly
Escalate issues as required to team and others
Bachelor’s degree in Computer Science or MIS from four-year college or university
SQL Development Experience (Postgres experience preferred)
ETL Development Experience (Japser ETL preferred)
Proficient at writing SQL commands: Selects, Inserts, Delete, Create Tables, Table Constraints, Triggers, Events, etc
SVN Experience (Tortoise SVN preferred)
MS Visio Experience
The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the associate is regularly required to sit and use hands to operate computer controls. The associate frequently is required to reach with hands and arms and talk or hear. The associate is occasionally required to stand; walk; climb; stoop or crouch. The associate must regularly lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
This is a Full-time position
9:00 a.m. – 5:00 p.m., Monday-Friday, core work hours.
This position does not have any supervisory responsibilities
Note, this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the associate for this job. Duties, responsibilities, and activities may change at any time with or without notice.