Datawarehouse Developer - 55945

• Data Integration, IICS, SQL
• Mid-senior

• Intermediate SQL (Oracle, SQL Server, Snowflake, Teradata)
• Intermediate IICS
• Experience with Snowflake data structures, data sharing, optimization
• Standard Microsoft productivity suite
• Experience with data quality tools and processes
• Strong written and oral communication skills for customer and vendor interaction
• Strong data analysis skills and demonstrated ability to learn new datasets quickly

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

• SQL (SAS cloud implementation)
• Microsoft Azure API Management
• Experience with oil and gas production operations datasets
• Experience working large transaction volume time-series datasets
• Experience working with data brokers/pub-sub data exchange (Kafka, HighByte, etc...)

**ALL successful candidates for this position are required to work directly for PRIMUS. No agencies please only W2**

For immediate consideration, please contact:

Rahul Kumar
PRIMUS Global Services
Direct
Desk x 259
Email: