• 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:

Position: Data Base Programmer/Analyst
REQ ID:  22-1001-PDR-01
Duration: 08/29/2022 - 06/30/2023
Direct Client: State of Colorado -  CO CDE

Job Location:  201 E Colfax Ave Denver, Colorado 80203-0000

 

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 the Azure environment. 

4.2. Requirements Gathering and Data Modeling Skills

Strong requirements gathering skills: the ability to work with customers to gather reporting requirements and translate them 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 tables.

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:

S16619904330183210

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!

<div><b><font face="verdana, sans-serif"><font color="#000000"><span style="text-align:justify">Position: </span></font></font><span style="font-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif">Data Base Programmer/Analyst</span></span></span></b></div> <div><b><font face="verdana, sans-serif"><font color="#000000"><span style="text-align:justify">REQ ID: </span> </font></font><span style="font-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif">22-1001-PDR-01</span></span></span></b></div> <div><b><font face="verdana, sans-serif"><font color="#000000">Duration: </font></font><span style="font-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif">08/29/2022 - 06/30/2023</span></span></span></b></div> <div><b><font face="verdana, sans-serif"><font color="#000000"><span style="text-align:justify">Direct Client: </span>State of Colorado - </font></font> <span style="font-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif">CO CDE</span></span></span> </b></div> <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"><b><span style="font-size:small"><span style="font-family:Arial, Helvetica, sans-serif"><font face="verdana, sans-serif"><font color="#000000"><span lang="EN-US" style="line-height:13.91px"><span style="text-align:justify">Job Location: </span></span> </font></font></span></span><span style="font-size:12px"><span style="color:#333333"><span style="font-family:Helvetica, sans-serif">201 E Colfax Ave Denver, Colorado 80203-0000</span></span></span></b></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:9px"> </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"><b><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></b></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 shall review internal CDE documentation and use this information to design a reporting layer on the 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: the ability to work with customers to gather reporting requirements and translate them into a data model for reporting using Tableau, 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 management and knowledge of best practices regarding 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 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 tables.</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 with the creation of data sources and actual implementation of visualization 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 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 project goals and the specific goals as pertains to the contractor's assignment 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 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 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 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 and perform knowledge transfer to the CDE staff.</span></span></span></span></span></span></span></span></span></span></span></span></p> <div> </div>


Please wait..!!