• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Data Base Programmer/Analyst

In United States

Save this job

Data Base Programmer/Analyst   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Data Base Programmer/Analyst

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Denver, CO United States

JOB DESCRIPTION:

Requisition ID

22-1001-PDR-01

Requisition Name

Data Base Programmer/Analyst

Customer

CO CDE

Address

Position Location Remote

Address

201 E Colfax Ave Denver, Colorado 80203-0000

Comment

Candidate must be local.

 

No preference

 
 

Additional Location Details (City, State) :

 

This role is remote,

Estimated Duration

08/29/2022 - 06/30/2023

Description

STATEMENT OF WORK

SECTION 1.0 PROJECT OVERVIEW

1.1. The Colorado Department of Education (hereafter referred to as

"CDE" or "the Department") is contracting with uWork.com, Inc. dba

Covendis (the Contractor), 200 Walker Ave St. SW, Atlanta GA, 30313, to

provide a Senior Database ProgrammerCONTRACTOR NAME from VENDOR NAME for the "Empowering Parents" project. This project is

funded through the general fund and includes new

features (ex. drill down) and standardization across the

department's customer facing data for the same look and feel throughout. 

1.2. The contractor will need experience in Informatica

and SQL. This involves using Informatica and SQL to load

tables and generate files for federal reporting. In addition,

this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE staff.

1.3. Covendis Posting Req. ID: 99999 – Senior Database Programmer –

Vendor Name – Contractor Name $XX.00/HR, Not to Exceed $138,000.00.

SECTION 2.0 GENERAL REQUIREMENTS

2.1. The Department's Project Manager for this project is Kevin Smith (Business Intelligence and Data Warehouse Team Supervisor). This contractor will report to

 Kevin Smith or his designee.

2.2. 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 Work.

2.3. The Contractor shall alert the Department's Project Manager, when issues or potential risks are encountered that will affect the project.

2.4. Prior to the covid crisis, nearly all staff, employees and contractors worked on premises at the CDE office located at 201 E. Colfax Ave, Denver, CO 80203.

During the crisis, most staff, employees, and contractors have worked from remote locations. Policies have not been fully formulated for how we will work in the

future. Once they are completed, it is expected to be dependent on the roles

and the need for each role to be in the office. For most roles, it is likely to be

a blend of office and remote work. 

For this role, Database Programmer, applicants can expect to work remotely.

2.4.1.While 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 requirements. Contractor shall provide its their own computer hardware and software necessary to perform

the Work at CDE's facilities. 

2.4.2.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 Work. 

2.5. The Contractor shall provide documentation to the Project Manager. 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 contract.

2.6. The Contractor shall submit detailed status reports or participate in weekly

status meetings as required by the Department during the engagement.

2.7. The Contractor shall 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

Project Manager, Kevin Smith. If Kevin is not available, he will designate a

Department employee for the communication.

2.8. Contractor shall retain all work papers generated for reference through

the duration of the project and project acceptance.

2.9. Contractor shall respond to all telephone calls, voicemail, and e-mail

inquiries from the Department within one business day.

SECTION 3.0 CONFIDENTIALITY AND PROTECTION OF PERSONALLY IDENTIFIABLE INFORMATION

3.1. The Student Data Transparency and Security Act (C.R.S. §§ 22-16-101,

 et seq.) governing the privacy of Personally Identifiable Information requires a confidentiality contract between CDE and Contractor.

3.2. 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 extensions.

SECTION 4.0 DESIGN, IMPLEMENT AND MAINTAIN NEW PRESENTATION LAYER TABLES TO MAKE DATA more ACCESSIBLE

4.1. With the guidance of the CDE Enterprise Architect, the contractor

shall review internal CDE documentation and use this information to design

a reporting layer on Azure environment. 

4.2. Requirements Gathering and Data Modeling Skills

Strong requirements gathering skills: ability to work with customers to gather reporting requirements and translate into a data model for reporting using Tableau,

Power BI, and Ad-hoc queries.

Strong administrative skills including repository

management and knowledge of best practices regarding

aggregate tables and data marts.

4.3. Azure and Data Warehouse ETL Skills

Experience working on Azure and implementing reporting layer tables using

ETL logic which pulls data from an Oracle or SQL Server database.

Experience working with star schemas and loading reporting layer table.

Preferred experience with Informatica or IICS or similar ETL tool.

4.4. Business Intelligence Skills

Experience creating dashboards using Tableau or Power BI. Experience working

with the creation of data sources and actual implementation of visualization

dashboards.

4.5. Strong oral and written communication skills working

with both business users and technical staff

4.6. 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 Manager.

4.7. The contractor be able to advise and provide guidance on the requested

work.

4.8. The contractor shall develop, maintain, and support Extract Transform and

Load processes which are written using Informatica and SQL.

4.9. The contractor shall use Informatica and SQL to load the CDE

Data Warehouse tables and generate Ed Facts files for federal reporting.

4.10. The contractor shall thoroughly test and document each step taken

and perform knowledge transfer to the CDE staff. 

 

Position Details

POSTED:

Jan 17, 2023

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S16619904330463216

LOCATION:

United States

CITY:

Denver, CO

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Data Base Programmer/Analyst    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<table style="border:none"> <tbody> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:1px solid black; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Requisition ID</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:1px solid black; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">22-1001-PDR-01</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Requisition Name</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Data Base Programmer/Analyst</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Customer</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">CO CDE</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif">Address</span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Position Location Remote</span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Address</span></span></span></span></span></span></span></span></span></span></span></span></p> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">201 E Colfax Ave Denver, Colorado 80203-0000</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Comment</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <table style="background-image:initial; background-position:initial; background-size:initial; background-repeat:initial; background-origin:initial; background-clip:initial"> <tbody> <tr> <td style="width:25%; padding:0in"> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Candidate must be local.</span></span></span></span></span></span></p> </td> <td style="width:2%; padding:0in"> </td> <td style="padding:0in"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">No preference</span></span></span></span></span></span></p> </td> <td style="padding:0in"> </td> </tr> <tr> <td style="padding:0in"> </td> <td style="width:25%; padding:0in"> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Additional Location Details (City, State) :</span></span></span></span></span></span></p> </td> <td style="width:2%; padding:0in"> </td> <td style="padding:0in"> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">This role is remote,</span></span></span></span></span></span></p> </td> </tr> </tbody> </table> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Estimated Duration</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">08/29/2022 - 06/30/2023</span></span></span></span></span></span></span></span></span></span></span></span></p> </td> </tr> <tr> <td style="border-bottom:1px solid black; width:144px; padding:0in 7px; height:142px; border-top:none; border-right:1px solid black; border-left:1px solid black" valign="top"> <p><span style="font-size:11pt"><span style="line-height:normal"><span style="font-family:Calibri, sans-serif"><span style="font-family:"Calibri Light", sans-serif"><span style="color:#333333">Description</span></span></span></span></span></p> </td> <td style="border-bottom:1px solid black; width:480px; padding:0in 7px; height:142px; border-top:none; border-right:1px solid black; border-left:none" valign="top"> <p align="center" style="text-align:center; margin-top:24px; margin-bottom:24px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-weight:bolder"><span style="font-size:16pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">STATEMENT OF WORK</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">SECTION 1.0</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">PROJECT OVERVIEW</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">1.1.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Colorado Department of Education (hereafter referred to as </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">"CDE" or "the Department") is contracting with uWork.com, Inc. dba </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Covendis (the Contractor), 200 Walker Ave St. SW, Atlanta GA, 30313, to </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">provide a <span style="background:yellow">Senior Database Programmer</span>, </span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">CONTRACTOR NAME</span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> from </span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">VENDOR NAME</span></span></span><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> for the </span></span></span><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">"Empowering Parents" project. This project is</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">funded through the general fund and includes new</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">features (ex. drill down) and standardization across the </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">department's customer facing data for the same look and feel throughout. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><a name="m_8290344389315439796__Hlk81224401"></a><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">1.2.</span></span></span> <span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">The contractor will need experience in Informatica </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">and SQL. This involves using Informatica and SQL to load</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">tables and generate files for federal reporting. In addition,</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE staff.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">1.3.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Covendis Posting Req. ID: </span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">99999</span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> – </span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">Senior Database Programmer – </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:53px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:red">Vendor Name – Contractor Name $XX.00/HR, Not to Exceed $138,000.00.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">SECTION 2.0</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">GENERAL REQUIREMENTS</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="background:yellow"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.1.</span></span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Department's Project Manager for this project is <span style="background:yellow">Kevin Smith (Business Intelligence and Data Warehouse Team Supervisor).</span> This contractor will report to</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> <span style="background:yellow">Kevin Smith or his designee.</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.2.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Contractor shall work closely and collaboratively with the Department's</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Project Manager throughout the duration of the Purchase Order to discuss </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">suggestions or issues and incorporate guidance from the Department while </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">performing the work described within this Statement of Work.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.3.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Contractor shall alert the Department's Project Manager, when issues or potential risks are encountered that will affect the project.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.4.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Prior to the covid crisis, nearly all staff, employees and </span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">contractors worked on premises at the CDE office located at 201 E. Colfax Ave, Denver, CO 80203. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">During the crisis, most staff, employees, and contractors have worked from remote locations. Policies have <i>not</i> been fully formulated for how we will work in the </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">future. Once they are completed, it is expected to be dependent on the roles</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">and the need for each role to be in the office. For most roles, it is likely to be </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">a blend of office and remote work. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-weight:bolder"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">For this role, Database Programmer, applicants can expect to work remotely.</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.4.1.</span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">While working at the CDE office, CDE will provide the contractor with </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">office space, phone, and internet access at CDE's Colfax office subject to </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">all applicable health and safety guidelines and requirements. Contractor shall provide <s>its</s> their own computer hardware and software necessary to perform</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">the Work at CDE's facilities. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.4.2.</span></span></span><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">While working remotely at locations other than CDE's office, CDE will</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">provide the contractor with virtual access to the data and systems </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:72px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">necessary for completion of the Work. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.5.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Contractor shall provide documentation to the Project Manager. This documentation must provide details on the work provided and at a level a </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Department employee can use the information to support the work at the end of the contract.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.6.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Contractor shall submit detailed status reports or participate in weekly</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">status meetings as required by the Department during the engagement.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.7.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Contractor shall 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 </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Project Manager, <span style="background:yellow">Kevin Smith.</span> If Kevin is not available, he will designate a </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Department employee for the communication.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.8.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Contractor shall retain all work papers generated for reference through </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">the duration of the project and project acceptance.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">2.9.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Contractor shall respond to all telephone calls, voicemail, and e-mail</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">inquiries from the Department within one business day.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">SECTION 3.0</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">CONFIDENTIALITY AND PROTECTION OF PERSONALLY IDENTIFIABLE INFORMATION</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">3.1.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The Student Data Transparency and Security Act (C.R.S. §§ 22-16-101,</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> <i>et seq.</i>) governing the privacy of Personally Identifiable Information requires a confidentiality contract between CDE and Contractor.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">3.2.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Attached hereto and incorporated herein by reference and agreed to by the </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">parties is a Confidentiality and Protection of Personally Identifiable Information</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Agreement ("Confidentiality Agreement"). Terms of the Confidentiality Agreement</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">shall be considered binding upon the execution of the Purchase Order and shall</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">remain in effect during the term of the Purchase Order including any extensions.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">SECTION 4.0</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">DESIGN, IMPLEMENT AND MAINTAIN NEW PRESENTATION LAYER TABLES TO MAKE DATA more ACCESSIBLE</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.1.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">With the guidance of the CDE Enterprise Architect, the contractor </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">shall review internal CDE documentation and use this information to design </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">a reporting layer on Azure environment. </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.2.</span></span></span> <span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Requirements Gathering and Data Modeling Skills</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Strong requirements gathering skills: ability to work with customers to gather reporting requirements and translate into a data model for reporting using Tableau, </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Power BI, and Ad-hoc queries.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333"> Strong administrative skills including repository </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">management and knowledge of best practices regarding </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">aggregate tables and data marts.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.3.</span></span></span> <span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Azure and Data Warehouse ETL Skills</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Experience working on Azure and implementing reporting layer tables using</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">ETL logic which pulls data from an Oracle or SQL Server database.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Experience working with star schemas and loading reporting layer table.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Preferred experience with Informatica or IICS or similar ETL tool.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.4.</span></span></span> <span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Business Intelligence Skills</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Experience creating dashboards using Tableau or Power BI. Experience working</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">with the creation of data sources and actual implementation of visualization </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">dashboards.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.5.</span></span></span> <span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Strong oral and written communication skills working </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:11.5pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">with both business users and technical staff</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.6.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The contractor shall demonstrate their understanding of the overall </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">project goals and the specific goals as pertains to the contractor's assignment </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">for this project to the satisfaction of the Project Manager.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.7.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The contractor be able to advise and provide guidance on the requested</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">work.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.8.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The contractor shall develop, maintain, and support Extract Transform and </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Load processes which are written using Informatica and SQL.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.9.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The contractor shall use Informatica and SQL to load the CDE</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">Data Warehouse tables and generate Ed Facts files for federal reporting.</span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:black">4.10.</span></span></span> <span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">The contractor shall thoroughly test and document each step taken </span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px; margin-left:36px"><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"><span style="font-size:9pt"><span style="font-family:Helvetica, sans-serif"><span style="color:#333333">and perform knowledge transfer to the CDE staff.</span></span></span></span></span></span></span></span></span></span></span></span><span style="font-size:11pt"><span style="line-height:normal"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial"><span style="font-family:Calibri, sans-serif"> </span></span></span></span></span></span></span></span></span></p> </td> </tr> </tbody> </table> <div> <div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr"> <div dir="ltr"> </div> </div> </div>


Please wait..!!