Calance Job Opening

Job TitleDatabase Programmer/Analyst - ID:35148
Duration9 Months
Start DateASAP
Job SkillsDatabase Development
LocationDenver, CO
Date Posted01/13/2020

Generated button

Our client, a leading provider of computing, applications management, IT procurement, network, and telecommunications services to public organizations, is looking to hire a Database Programmer/Analyst.
. Consults with users to identify current operating procedures and clarify program objectives.
. Develops database from project specifications and statement of problem and procedures to create or modify computer data base programs applying knowledge of programming techniques and computer systems. Plan, coordinate, and implement security measures to safeguard computer databases.  
. The Contractor shall assist our client in reviewing a data model and implementing a new solution to the existing organization and school directory dimensions in client’s data warehouse and reporting environment.
. Design and develop code to create conversion code to migrate data from existing school directory dimensions to the newly designed school directory dimension.
. Validate the new dimensions and work with the data warehouse and reporting teams to migrate the new dimensions into existing processes.  
. Submit detailed status reports or participate in weekly status meetings as required by the Department during the engagement.
. Attend required meetings with the required project stakeholders as directed by the Department. These meetings will be scheduled by a Department employee. All questions and communication should go through the Business Intelligence Supervisor, Kevin Smith or the Data Warehouse Manager, Dan Pappas. If Kevin and Dan are not available they will recommend a Department employee for the communication.
. Alert the Business Intelligence Supervisor and/or Department’s Data Warehouse Manager, when issues or potential risks are encountered that will affect the project.
. Provide documentation to the Business Intelligence Supervisor and Data Warehouse Manager. This documentation must provide details on the work provided and at a level a Department employee can use the information in order to support the work at the end of the contract

Requirements and Skills
. Knowledge and Skill sets include Oracle, DB2, Sybase, ADABAS, SQL Server, Informix, Linux, and decision support systems such as COGNOS, and BOA.  Coordinate changes to computer databases, test and implement the database applying knowledge of database management systems. 
. Prepares or receives from Data Base Analyst flowcharts and diagrams to illustrate sequence of steps program must follow and to describe logical operations involved.
. At least eight (8) years of development experience with complex SQL queries.
. Demonstrated experience with Data Warehousing and Business Intelligence Architecture concepts (including database design, data modelling, data flow diagrams).
. Experience with gathering requirements from users. This could include Face-to-Face meetings and interviews, and/or virtual meetings, and/or a combination of both.  Also, The ETL Developer may need to do some data modeling design sessions to help the requirements to be more accurately defined by the business users. 
. Availability and flexibility to work nights and weekends as required by the implementation to reduce impact to CDE operations. As with many technology implementations, some of the work often has to be done in off hours as it often requires system outages. 
. A bachelor’s degree in area of specialty (or equivalent experience), and 8 years or more experience in the field or in a related area.
. Contractor shall be required to pass a criminal background check.

Who is Calance?
Calance is a global IT company with operations in the United States, Canada and India. Over the years, Calance has grown organically and has acquired numerous successful IT Services firms along the way. As a result, the company today is a mix of diverse cultures, talents and expertise that collaborate globally to bring our best capabilities and thinking to clients. Calance also offers benefits which includes Medical, Dental, Vision care and 401K.

Calance - the place to grow.

Send To Email / Remind Me



Mission Viejo, CA ~ (800) 732-4680
Atlanta, GA ~ (866) 951-1151

Calance is a global IT Services firm specializing in end-to-end solutions for Development, Managed Service,
Security, SAP, Project Control Integration and IT Staffing.Operating in the United States and India,
Calance helps clients bring their ideas and strategies to life through talent, technology and tenacity.

2019 All rights reserved.