Role: Data Integrator/Developer

Hybrid: Monday, Tuesday, Thursday Onsite

Location: Texas

Key Responsibilities:

Data Integration: Design, develop, and maintain data integration solutions to support oil and gas operations. This includes integrating data from various sources such as Oracle, SQL Server, Snowflake, and other ETL tools. Ability to write complex SQL queries in traditional or virtual databases is required
Database Management: Manage and optimize SQL Server databases to ensure high performance, availability, and security.
ETL Processes: Develop and maintain ETL processes to extract, transform, and load data from various sources into Snowflake and other data warehouses using Informatica Cloud Services. Proficient knowledge of Informatica Cloud Services is required
Data Quality: Ensure data quality and integrity by implementing data validation and cleansing processes. Proficiency with well completions and production data integration in Wellview is preferred.
Collaboration: Work closely with cross-functional teams and business stakeholders to understand data requirements and deliver effective data solutions.
Documentation: Create and maintain comprehensive documentation for data integration processes, database schemas, and ETL workflows.

Qualifications (Basic/Required):

Experience: Intermediate knowledge in oil and gas industry, with good understanding of at least production & completions data side of the Well Life Cycle. Good working knowledge of production and completions data in Wellview
Technical Skills: Proficient in SQL Server, Snowflake, and Informatica Cloud Software for building & maintaining ETL pipelines. Experience with data modeling, database design, and performance tuning.
Analytical Skills: Strong analytical and problem-solving skills, with the ability to analyze complex data sets and derive actionable insights.
Communication: Excellent communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.