Job Description:

 

Enterprise Products Partners L.P. is one of the largest publicly traded partnerships and a leading North American provider of energy services to producers and consumers of natural gas, natural gas liquids, crude oil, refined products and petrochemicals. Headquartered in Houston, Texas, Enterprise Products is ranked 56th on the FORTUNE 500 and has approximately 6,900 employees. Enterprise’s large, integrated portfolio of operationally and geographically diverse assets, highlighted by its approximately 49,000-mile pipeline network, serves as the foundation for organic growth opportunities. As a provider of largely fee-based services, Enterprise is less susceptible to commodity price fluctuations and offers stable sources of revenue. The partnership’s service offerings include onshore and offshore energy gathering, processing, storage, fractionation, terminalling, transportation, import/export capabilities and marketing. Enterprise also has a marine transportation business that operates primarily on the United States inland and Intracoastal Waterway systems and in the Gulf of Mexico. Additionally, energy professionals are discovering rewarding opportunities with Enterprise Products by putting their skills to work in exciting new growth areas, developing markets and pursuing innovative solutions for meeting the needs of customers and promote energy security for the country.

We are currently seeking a geospatial database analyst to join the Asset Integrity Department. As part of the Asset Information Management group you will work closely with asset integrity engineers, regulatory compliance specialists and geospatial asset information management experts to deliver value added data products to business units throughout the company.

Enterprise has recently completed a project to modernize our asset information management practices to utilize modular, open source technology and internal innovation instead of monolithic proprietary systems.

Responsibilities

• Willingness and ability to pro-actively manage a high volume and variety of asset information.


• Willingness and ability to work outside of a single IT specialty and typical IT organizational structure. 


• Working with clients and business analysts to define and meet business requirements.


• Writing PostgreSQL/PostGIS routines for data processing,


• Writing data extract, translate and load (ETL) routines with Python.


• Writing complex spatial functions using the PostGIS 3.x Spatial Extender for PostgreSQL 15.x


• Authoring proposals, design documents, technical specifications for senior staff review.

 

The successful candidate will meet the following qualifications:

Required

• Demonstrates capability for detailed data analysis, critical thinking and problem solving.


• Demonstrates interpersonal, communication, and customer service skills.


• Demonstrates the flexibility to address changing business requirements.


• Follows through on assignments and brings complex tasks and projects to definitive closure.


• 3-5 years experience working in the midstream or pipeline industry.


• 3-5 years experience writing simple to highly complex SQL queries, functions and stored procedures in PostgreSQL 15.x or equivalent platform.


• 3-5 years experience creating spatial data processing routines using the PostGIS 3.x Spatial Extender for PostgreSQL 15.x.


• 1-3 years experience writing Python object-oriented scripts and data processing routines. 


• Technical understanding of semi-structured data forms such as XML, JSON, GeoJSON, GML.


• General working knowledge of QGIS or other commercial GIS software.

 

PreferredDemonstrates conceptual understanding of data architecture.

• Demonstrates general understanding of industry data models such as PODS, PPDM, APDM, ISAT, or UPDM


• Demonstrates general understanding of GeoServer data store configurations and map tile rendering.


• Experience working with JSON encoded document data and schemas.


• Demonstrates capability to manage small projects with business requirements definition and developing/managing proposed scopes of work.


• Demonstrates capability to author technical documents for design proposals.

Apply Now