صاحب العمل نشط
Requisition ID
ETL BU
Requisition Name
Data Base Programmer/Analyst
Customer
CO CDE
Address
Position Location Remote
Denver, Colorado 80203-0000
Description
STATEMENT OF WORK
PROJECT OVERVIEW
The Colorado Department of Education ("CDE" or "the Department") has been awarded a grant which includes the Implementation of Common Education Data Standards (CEDS) databases and an upgrade of the CDE A CDE employee will be partnering with the selected individual to work on the SLDS (Statewide Longitudinal Data System) project and on the on-going daily maintenance This statement of work is to engage a contractor for this Included in the daily work but not limited to, is maintaining the existing Oracle Data Warehouse environment and ETL
The contractor will need experience in Informatica and This involves using Informatica and SQL to load tables and generate files for federal In addition, this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE With this partnership the need for knowledge transfer should happen in the normal course of work between the DW team and the
GENERAL REQUIREMENTS
The Department's Project Manager for this project is Kevin Smith (Business Intelligence and Data Warehouse Team Supervisor). This contractor will report to Kevin
Contractor shall work closely and collaboratively with the Department's Project Manager throughout the duration of the Purchase Order to discuss suggestions or issues and incorporate guidance from the Department while performing the work described within this Statement of
The Contractor shall alert the Department's Project Manager, when issues or potential risks are encountered that will affect the
Prior to the Covid crisis, nearly all staff, employees and contractors worked on premises at the CDE office located at 201 Colfax Ave, Denver, CO During the crisis, most staff, employees, and contractors have worked from remote Policies have not been fully formulated for how we will work in the futur Once they are completed, it is expected to be dependent on the roles and the need for each role to be in the offic For most roles, it is likely to be a blend of office and remote
For this role, Database Programmer, applicants can expect to work
NOTE: Contractor shall provide its their own computer hardware and software necessary to perform the Work at CDE's
If working at the CDE office, CDE will provide the contractor with office space, phone, and internet access at CDE's Colfax office subject to all applicable health and safety guidelines and
While working remotely at locations other than CDE's office, CDE will provide the contractor with virtual access to the data and systems necessary for completion of the
The Contractor shall provide documentation to the Project This documentation must provide details on the work provided and at a level a Department employee can use the information to support the work at the end of the
The Contractor shall submit detailed status reports or participate in weekly status meetings as required by the Department during the
The Contractor shall attend required meetings with the required project stakeholders as directed by the These meetings will be scheduled by a Department employe All questions and communication should go through the Project Manager, Kevin If Kevin is not available, he will designate a Department employee for the
Contractor shall retain all work papers generated for reference through the duration of the project and project acceptanc
Contractor shall respond to all telephone calls, voicemail, and e-mail inquiries from the Department within one business
SECTION CONFIDENTIALITY AND PROTECTION OF PERSONALLY IDENTIFIABLE INFORMATION
The Student Data Transparency and Security Act (, et ) governing the privacy of Personally Identifiable Information requires a confidentiality contract between CDE and
Attached hereto and incorporated herein by reference and agreed to by the parties is a Confidentiality and Protection of Personally Identifiable Information Agreement ("Confidentiality Agreement"). Terms of the Confidentiality Agreement shall be considered binding upon the execution of the Purchase Order and shall remain in effect during the term of the Purchase Order including any
SECTION Balance SLDS Work With DAILY Maintenance of our existing structure
With the guidance of the data warehouse manager and in partnership with a DW employee, the contractor shall
Review internal CDE documentation and provide maintenance and support for the existing CDE Informatica and SQL
Review status on the SLDS project and perform tasks as determined by the This may include, but is not limited to, mapping of data fields to the new environment and structures, migrating data, testing, and other duties as assigned in the MS Azure cloud environment using SQL and possibly Data Factory skills
Informatica Skills
Strong development skills: ability to develop very difficult or complicated transformation from scratch
Strong administrative skills including repository management and knowledge of best practices regarding Informatica
Strong oral and written communication skills working with both business users and technical staff
The contractor shall demonstrate their understanding of the overall project goals and the specific goals as pertains to the contractor's assignment for this project to the satisfaction of the Project
The contractor be able to advise and provide guidance on the requested
The contractor shall develop, maintain, and support Extract Transform and Load processes which are written using Informatica and
The contractor shall use Informatica and SQL to load the CDE Data Warehouse tables and generate Ed Facts files for federal
The contractor shall thoroughly test and document each step taken and perform knowledge transfer to the CDE
Skills
ETL, Informatica, SQL, Oracle Data warehouse
Skills : SQL,ETL,Oracle date warehouse,Informatica
دوام كامل