Enterprise Products · 2 days ago

Senior Database Analyst

Greater Houston

Full-time

Onsite

Senior Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

EnergyOil and Gas

Comp. & Benefits

Insider Connection @Enterprise Products

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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.

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data analysisSql queriesFunctionsStored proceduresPostgresqlPostgisSpatial data processingArcgisQgisGis softwareMidstream industryPipeline industryProblem solvingCritical thinkingInterpersonalCommunicationCustomer serviceFlexibilityFollow-throughData ArchitectureIndustry Data ModelsProject ManagementPythonObject-Oriented ProgrammingData ProcessingSemi-Structured DataXMLJSONGeoJSONGML

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.

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.