Colorado Locals Only ::: Senior Database Programmer

Full Time, Part Time, Contract W2, Contract Corp-To-Corp, Contract Independent

Job Description

Job Id: 22-1001-PDR-01

Title: Senior Database Programmer

Location: REMOTE - Denver, Colorado 80203

Duration: 12 Months


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.

Dice Id : 10452799
Position Id : OOJ - 6803-10699
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Web Content Designer
  • Calance
  • Denver, CO, USA
Web Content Designer
  • DatamanUSA, LLC
  • Denver, CO, USA
Business Intelligence (BI) Developer
  • E-Business International, Inc.
  • Englewood, CO, USA
Data Analyst
  • Digital Intelligence Systems, LLC
  • Denver, CO, USA
Senior Data Engineer
  • Jobot
  • Denver, CO, USA
Data Engineer
  • Kforce Technology Staffing
  • Greenwood Village, CO, USA
Data Engineer
  • Charles Schwab & Co., Inc.
  • Englewood, CO, USA
Senior Manager- Technology sourcing
  • Atrilogy Solutions Group, Inc.
  • Littleton, CO, USA