Data Base Programmer

2 months ago

Colorado Springs, United States Saxon Global Full time
STATEMENT OF WORK

SECTION 1.0 PROJECT OVERVIEW

The Colorado Department of Education ("CDE" or "the Department") has been awarded a grant which includes the Implementation of Common Education Data Standards (CEDS) databases and an upgrade of the CDE infrastructure. A CDE employee will be partnering with the selected individual to work on the SLDS (Statewide Longitudinal Data System) project and on the on-going daily maintenance work. This statement of work is to engage a contractor for this partnership. Included in the daily work but not limited to, is maintaining the existing Oracle Data Warehouse environment and ETL development.

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. With this partnership the need for knowledge transfer should happen in the normal course of work between the DW team and the contractor.

GENERAL REQUIREMENTS

1.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.

1.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.

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

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.

NOTE: Contractor shall provide its their own computer hardware and software necessary to perform the Work at CDE's facilities.

If working at the CDE office, CDE will provide the contractor with office space, phone, and internet access at CDE's Colfax office subject to all applicable health and safety guidelines and requirements.

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.

1.4 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.

1.5 The Contractor shall submit detailed status reports or participate in weekly status meetings as required by the Department during the engagement.

1.6 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.

1.7 Contractor shall retain all work papers generated for reference through the duration of the project and project acceptance.

1.8 Contractor shall respond to all telephone calls, voicemail, and e-mail inquiries from the Department within one business day.

SECTION 2.0 CONFIDENTIALITY AND PROTECTION OF PERSONALLY IDENTIFIABLE INFORMATION

2.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.

2.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 3.0 Balance SLDS Work With DAILY Maintenance of our existing structure

3.1. With the guidance of the data warehouse manager and in partnership with a DW employee, the contractor shall

3.1.1. Review internal CDE documentation and provide maintenance and support for the existing CDE Informatica and SQL processes.

3.1.2. Review status on the SLDS project and perform tasks as determined by the partnership. This may include, but is not limited to, mapping of data fields to the new environment and structures, migrating data, testing, and other duties as assigned in the MS Azure cloud environment using SQL and possibly Data Factory skills

3.2. Informatica Skills

Strong development skills: ability to develop very difficult or complicated transformation from scratch

Strong administrative skills including repository management and knowledge of best practices regarding Informatica

3.3. Strong oral and written communication skills working with both business users and technical staff

3.4. 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.

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

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

3.7. The contractor shall use Informatica and SQL to load the CDE Data Warehouse tables and generate Ed Facts files for federal reporting.

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

Required Skills : - ETL 4-6 years - Informatica 4-6 years - Oracle Data Warehouse 4-6 years - SQL 4-6 years
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Architecture/Design
Master Job Title :ETL Developer
Branch Code :Colorado Springs

  • Entry Level Python Programmer/Data scientist/Analyst

    3 months ago

    Colorado Springs, United States SynergisticIT Full time

    t SynergisticIT, we aim to bring aboard IT professionals to help them build a rewarding career in cutting-edge technologies. Being in the industry for more than 10 years, we provide a splendid range of lucrative opportunities to sustain a position in our top tech clients like Google, Apple, Cognizant, Client, PayPal, to name a few. Our seasoned team firmly...

  • CNC Programmer

    2 weeks ago

    Colorado Springs, United States Cogitic Corporation Full time

    Are you a highly skilled CNC Programmer? This is a rare opportunity to join an elite machining and engineering team dedicated to crafting unique sophisticated parts used in every submarine in the U.S. Navy. Earn up to $135,000 a year in a very collaborative environment where you will have the latest technology at your fingertips along with highly structured...

  • CMM Programmer

    2 months ago

    Harbor Springs, United States Belcan Full time

    CMM Programmer Job Number: 350057 Category: -MFG & Supply Chain SBU Description: Job Title: CMM Programmer Pay Rate: $40.00-$50.00/hour Locations: Remote with travel as needed to Harbor Springs, MI 49740 *25% Travel* Area Code: 810 Shift: 1st Full time, Contract W2 Duration: 3 months #cmmprogramming #aerospacesmanufacturing #pcdmis Job Summary: We are...

  • Enterprise Data Strategist

    1 month ago

    Colorado Springs, United States Indotronix International Corporation Full time

    STATEMENT OF WORK (COVENDIS) SECTION 1.0 PROJECT OVERVIEW The Colorado Department of Education ("CDE" or "the Department") is looking for a contractor to provide Data Governance services in support of the Statewide Longitudinal Data Systems (SLDS) federal grant efforts. CDE received the grant award in 2020, and it will continue through February 2025. The...

  • CMM Programmer

    2 months ago

    Harbor Springs, United States Belcan Full time

    Description: Job Title: CMM Programmer Pay Rate: $40.00-$50.00/hour Locations: Remote with travel as needed to Harbor Springs, MI 49740 *25% Travel* Area Code: 810 Shift: 1st Full time, Contract W2 Duration: 3 months Job Summary: We are seeking a skilled CMM Programmer with experience in PCDMIS to join our team on a 3-month contract, with the possibility of...

  • Engineering Manager

    11 hours ago

    Colorado Springs, Colorado, United States The Aerospace Corporation Full time

    About the RoleThe Aerospace Corporation is seeking a highly skilled and experienced Engineering Manager to lead a diverse team of engineers, data scientists, and programmers in the Data Science Applications Section. As a key member of our team, you will be responsible for managing a team of technical professionals, providing technical guidance, and ensuring...

  • Data Scientist

    1 week ago

    Colorado Springs, United States nou Systems Full time

    nou Systems, Inc. (nSI) is here to solve diverse and challenging technical problems in an enjoyable, stimulating environment while providing unsurpassed value to our customers. We are pleased to announce the opening for a Data Scientist in Colorado Springs, CO who will join our innovative team and become part of our rapidly growing technology company...

  • Data Scientist

    3 months ago

    Colorado Springs, United States Nou Systems Inc Full time

    Job DescriptionJob Descriptionnou Systems, Inc. (nSI) is here to solve diverse and challenging technical problems in an enjoyable, stimulating environment while providing unsurpassed value to our customers.We are pleased to announce the opening for a Data Scientist in Colorado Springs, CO who will join our innovative team and become part of our rapidly...

  • AI Content Writer

    3 months ago

    Colorado Springs, United States Data Annotation Full time

    DataAnnotation is committed to creating quality AI. Join our team to help train AI chatbots while gaining the flexibility of remote work and choosing your own schedule. We are looking for a professional content writer and copy editor to join our team and teach AI chatbots. You will have conversations with chatbots in order to measure their progress, as well...

  • Senior Director of Technology Solutions

    4 days ago

    Colorado Springs, Colorado, United States Vantage Data Centers Full time

    About Vantage Data CentersVantage Data Centers is a leading provider of data center solutions, committed to delivering high-quality services to its customers. We strive to create a workplace of inclusion, equity, respect, and acceptance, celebrating diversity and promoting a culture of innovation and collaboration.Job SummaryWe are seeking a highly...

  • Data Scientist

    1 month ago

    Colorado Springs, United States U.S. Space Command Full time

    The United States Space Command (USSPACECOM) in Colorado Springs, CO is searching for well-qualified candidates to fill (2) Data Scientist NH-1560-03 positions. Come join our amazing team who helps ensure there is never a day without space!There’s a reason Colorado Springs has ranked in the top 10 U.S. cities to live for the past several years. There is so...

  • Senior Data Engineer

    1 week ago

    Colorado Springs, United States KBR Full time

    Title: Senior Data Engineer The KBR team in Colorado Springs, CO is seeking a highly motivated Senior Data Engineer to join us in supporting our great nation, specifically on the Air Force Tactical Exploitation of National Capabilities (TENCAP) HOPE contract. Air Force TENCAP exploits National capabilities to deliver rapid, cost-dominant, and innovative...

  • Spatial Data Scientist

    17 hours ago

    Colorado Springs, Colorado, United States AVA Energy Full time

    AVA Energy is partnering with a leading Consulting firm in the Energy sector to expand their GIS team. We are seeking experienced candidates to conduct Geospatial Analysis focused on electric and gas utility infrastructure.Key Responsibilities:Create GIS-based models and dashboards to support projects across utility operations and assets.Provide subject...

  • Data-Driven Innovation Leader

    21 hours ago

    Colorado Springs, Colorado, United States DISH Full time

    About DISHDISH, an EchoStar company, has been revolutionizing the future of connectivity for over 40 years. Our business scope encompasses satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and the development of America's First Smart NetworkTM.Our portfolio includes EchoStar,...

  • Data Governance Analyst

    22 hours ago

    Colorado Springs, Colorado, United States SAIC Full time

    Job SummarySAIC is seeking a highly experienced and skilled Configuration Analyst to support the US Space Force, Space Systems Command, in performing operational maintenance and sustainment of ground-based radars critical to U.S. and Allied strategic missile surveillance, warning, defense, and space surveillance missions.Key ResponsibilitiesEnsure that...

  • Data Science Engineer

    1 week ago

    Colorado Springs, United States Tatitlek Federal Services, Inc (TFSI) Full time

    Data Science Engineer Job Locations US-CO-Colorado Springs ID 2024-1995 Category Information Technology Position Type Regular Full-Time Overview We are seeking a highly qualified Data Science Enginner to support the Dean of Faculty (DF) in advancing the academic and research mission. The selected contractor will provide expert guidance on data science...

  • Enterprise Data Architect

    2 months ago

    Colorado Springs, United States Ent Credit Union Full time

    Job DescriptionJob DescriptionCompany DescriptionEnt Credit Union exists to improve the financial quality of life of the people we serve. This mission drives us every day, but we are more than our mission. We're also individuals using our unique abilities to make our organization, and the communities we serve, better than they were yesterday. We're a...

  • Enterprise Data Architect

    2 months ago

    Colorado Springs, United States Ent Credit Union Full time

    Job DescriptionJob DescriptionCompany DescriptionEnt Credit Union exists to improve the financial quality of life of the people we serve. This mission drives us every day, but we are more than our mission. We're also individuals using our unique abilities to make our organization, and the communities we serve, better than they were yesterday. We're a...

  • Financial Reconciliation Analyst

    4 days ago

    Colorado Springs, Colorado, United States Integrated Data Services Full time

    Company Overview:Integrated Data Services (IDS) stands as a premier provider of tailored software solutions and financial management services for government entities. Established in 1997, IDS has experienced significant growth and now operates multiple offices across the nation, delivering fast, efficient, and reliable information systems and support...

  • Mechanical Engineer

    2 weeks ago

    Colorado Springs, United States Procon Consulting Full time

    Procon Consulting is seeking a Mechanical Engineer. The candidate will have responsibilities that include but not limited to construction, design/build, architecture and engineering, space management, facilities management, real estate, and leasing of complex construction projects. This role requires 5 years of experience in construction management on...