Analyst, Senior Database

Primary Location

USA-Texas-Houston

What you will be doing

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 Senior Database Analyst to join the Asset Integrity Department. As part of the Data Services 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.

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 tabular data processing.
• Write data extraction, translation, and loading (ETL) routines with Postgres Functions.
• Write complex spatial operations using the PostGIS 3.x Spatial Extender for PostgreSQL 13.x
  
  

What Your Background Should Look Like (minimum 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 of experience working in the midstream or pipeline industry.
• Minimum 3-5 years of experience writing simple to highly complex SQL queries, functions and stored procedures in PostgreSQL 13.x or equivalent platform.
• Minimum 3-5 years of experience creating spatial data processing routines using the PostGIS 3.x Spatial Extender for PostgreSQL 13.x.
• Minimum 1-3 years of experience of ArcGIS, 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 capability to manage small projects with business requirements definition and developing/managing proposed scopes of work.
• Minimum 1-3 years of experience writing Python object-oriented scripts and data processing routines.
• Technical understanding of semi-structured data forms such as XML, JSON, GeoJSON, GML
  
  

Shift

Day Job

Travel

Yes, 10 % of the Time

Unposting Date

Ongoing

Organization

Engineering

Job

Engineering

Job Level

Individual Contributor