Job Description

Enterprise Products Partners L.P. is one of the largest publicly traded partnerships and a leading North American provider of midstream energy services to producers and consumers of natural gas, NGLs, crude oil, refined products and petrochemicals. Our services include: natural gas gathering, treating, processing, transportation and storage; NGL transportation, fractionation, storage and import and export terminals; crude oil gathering, transportation, storage and terminals; petrochemical and refined products transportation, storage and terminals; and a marine transportation business that operates primarily on the United States inland and Intracoastal Waterway systems. The partnership’s assets include approximately 50,000 miles of pipelines; 260 million barrels of storage capacity for NGLs, crude oil, refined products and petrochemicals; and 14 billion cubic feet of natural gas storage capacity.

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

Enterprise is currently executing a project to modernize our geospatial asset information management practices to leverage modular, open source technology in a scalable and flexible way. This is an exceptional opportunity for a motivated candidate.

Responsibilities Include:

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.
Work with clients and business analysts to define specific business requirements.
Write PostgreSQL routines for spatial and tablular data processing.
Write data extraction ,translation and loading (ETL) routines with Python/Postgres Functions.
Write complex spatial operations using the PostGIS 3.x Spatial Extender for PostgreSQL 13.x
Author technical documents, specifications and proposals for senior staff review.

Qualifications

The successful candidate will meet the following qualifications:

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.
Minimum 3-5 years experience working in the midstream or pipeline industry.
Minimum 3-5 years experience writing simple to highly complex SQL queries, functions and stored procedures in PostgreSQL 13.x or equivalent platform.
Minmum 3-5 years experience creating spatial data processing routines using the PostGIS 3.x Spatial Extender for PostgreSQL 13.x.
Minimum 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.

Preferred

Demonstrates 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 with Adobe LiveCycle Designer.
Demonstrates capability to manage small projects with business requirements definition and developing/managing proposed scopes of work.