Kinder Morgan - Houston, TX
posted 2 months ago
The Integrity Systems group within Kinder Morgan's Pipeline Integrity Department is responsible for the design, implementation, and support of various systems and applications related to the pipeline Integrity Management Program (IMP) for all pipeline business units across Kinder Morgan's operating footprint. As an Integrity Systems Data Engineer, you will be responsible for the continuous improvement and expansion of in-house data integration pipelines and validation processes that feed systems for pipeline safety risk analysis, long-range integrity assessment planning, and a wide variety of integrated reporting. The Integrity Systems Data Engineer will report to the Manager of Integrity Systems. In this role, you will build and maintain reliable data pipelines for data extraction, transformation, and loading (ETL/ELT). You will integrate data from various sources, including databases, APIs, and external data providers, and combine data from different formats and structures into a unified data model. Additionally, you will design data models and schemas to support business requirements and manage data warehousing of a wide variety of pipeline integrity and risk modeling datasets. You will also create and maintain data catalog and data lineage documentation to support data discovery and audit, conduct data profiling, data cleansing, deduplication, and validation activities, and implement data quality monitoring and alerting systems. Monitoring and optimizing data systems and pipelines for performance issues and bottlenecks will be a key part of your responsibilities, along with troubleshooting and resolving data-related problems promptly. Collaboration with cross-functional teams on data-related Pipeline Integrity projects and participation in high-impact business process improvement initiatives across the Pipeline Integrity department will also be essential. You will identify and present Pipeline Integrity process improvement opportunities and follow through with implementation once stakeholder agreement is obtained, providing support for other aspects of integrity-related programs, processes, and procedures as required.