Status:
OPEN
Job ID:
25706
Title:
Graphics Designer
Applications Invited from Countries:
United States
Job Description

Requisition Details for: 22-PDR-02

Requisition Details

Summary

Requisition ID : 22-PDR-02

Requisition Name : Web Content Designer IV

Customer : CO CDE - Colorado Department of Education

Quantity Requested : 1

 

Description

Covendis Description:  Individuals with experience designing and developing content for PE websites that includes, but is not limited to the development of graphics, icons and other visual content. Has experience in daily content publishing and writing for multiple audiences; proficiency in the use of content management software, such as Microsoft SharePoint, Ektron, Drupal, Convio, and Kintera. May require an associate's degree or its equivalent and at least 9 years of experience in the field or in a related area.

 

CDE Full Statement of Work:

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 Web Content Developer IV, CONTRACTOR 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/or SQL. This involves using Informatica and/or SQL to load presentation layer tables for the creation of visuals and information which will be displayed on the Colorado Department of Education website. In addition, this individual may be requested to provide recommendations, documentation, and knowledge transfer to the CDE staff.

 

 

SECTION 2.0  GENERAL REQUIREMENTS

 

2.1.     The Department’s Project Manager for this project is Dee Abueldahab (Enterprise Architect).  This contractor will report to Dee Abueldahab or designee

2.2.     Contractor shall work closely and collaboratively with the Department’s Project Manager, the Presentation Layer Developer (technical lead) and the Web Management Team 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, Business Intelligence Developer, 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, Dee Abueldahab. If Dee 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 AND VISUAL REPRESENTATIONS TO MAKE DATA more ACCESSIBLE

4.1.     With the guidance of the CDE Enterprise Architect and Presentation Layer Developer (Team Lead), the contractor shall review internal CDE documentation and use this information to design a reporting layer on Azure environment. 

4.2.      Required Experience:

5 years of experience developing using Drupal.

3 years of experience making web content compliant with the Americans with Disability Act (ADA).

3 years of experience using Tableau Desktop to create visuals.

3 years of experience using SQL.

4.3.     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.4.     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.5.     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.6.     Strong oral and written communication skills working with both business users and technical staff

4.7.     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.8.     The contractor be able to advise and provide guidance on the requested work.

4.9.     The contractor shall develop, maintain, and support Extract Transform and Load processes which are written using Informatica and/or SQL.

4.10.  The contractor shall use Informatica and/or SQL to pull data from the CDE Data Warehouse tables and generate new aggregated data in summary tables which will be utilized for the creation of visuals.

4.11.  The contractor shall have experience in web development using Drupal on an Apache Server. 

4.12.  The contractor shall have experience integrating Tableau or Power BI visuals into the web environment using Drupal on an Apache Server.

4.13.  The contractor shall have experience in implementing ADA accessibility requirements and best practices when developing visuals using Tableau or Power BI.

4.14.  The contract shall have experience in implementing ADA accessibility requirements and best practices when developing web pages.

4.15.  The contractor shall thoroughly test and document each step taken and perform knowledge transfer to the CDE staff.

4.16.  Preferred Skills:

Connecting Drupal to an external database, Oracle preferred.

 

 

Estimated Duration : 10/10/2022 - 06/30/2023

 

Days : Monday  Yes Tuesday  Yes Wednesday  Yes Thursday  Yes Friday  Yes Saturday  No Sunday  No

Hours/Day : 8

Time Zone : MST

 

Shifts

Start Time

 

End Time

 

Description

 

Active

 

Shift 1

8:00 AM

 

5:00 PM

     

Yes

                 
                 

Pricing

 

Max Bill Rate : USD 96.00 Per  Hour

Expenses Allowed :  No

 

 

  

 

Comment

 

Files

 

Company

 

Origin

 

Viewable

 

Created By

 

Created On

   
 

The Rate Range is $76 - $96.

 

 

 

CO CDE

 

Requisition

 

All

 

Myskiw, Diane

 

09/19/2022 7:52 PM EDT

   
 

Please see the "description" field for the full statement of work.

 

 

 

CO CDE

 

Requisition

 

All

 

Myskiw, Diane

 

09/19/2022 7:52 PM EDT

   

Location

Position Location : Remote

Address

  ,    

Custom Fields

 

Location Requirements

 
 

Candidate must be local.

 

No preference

 
 

Additional Location Details (City, State) :

 

Remote.