This engagement will provide data and integration support for the gas lift project pilot and any subsequent production implementation. Resources supplied under this agreement will be responsible for the following activities when/if determined necessary :
Data Preparation for Pilot:
Work with senior staff to identify necessary data within internal systems
Develop and optimize SQL for vendor to directly acquire data with their solution
Develop data exports as needed to supply necessary data to vendor solution where direct access is not permissible or technically possible
Developing integrations to combine data from disparate systems for easier consumption by vendor solution
QA/QC of data supplied to solution
Data Analysis and Support during pilot:
Work with the vendor to identify any supplemental data within internal systems.
Debug and support integrations and data access needs identified during the pilot
Work with staff, solution vendor, and pilot users to identify and resolve data issues
QA/QC of data issues and working with source system owners to resolve data issues
Production Implementation: (all activities below will be as needed pending implementation details)
Develop, test, and implement data structures (views/tables) in snowflake
Develop, test, and implement integration processes as necessary to consolidate similar data from disparate systems.
Optimization of data structures and integrations
Develop, test, and implement data integrations to provide files, as necessary, to vendor solution per vendor specifications
Coordinate with source systems owners, staff, and vendor resources to develop and implement data quality rules for any integrations or data structures
Work with source system owners to identify proper data sources and design processes to integrate that for the vendor solution
Work with end users, vendor, and other staff to identify, debug, and resolve data issues
Provide production support of data and integration processes
Work activities identified below are only required during normal business hours. After-hours support will not be included as part of this effort.