BP Americas, Inc. Data Engineer in Denver, Colorado
Yes - Domestic (In country) only
Yes - up to 10%
BP's BPX Energy business (formerly known as the Lower 48) operates across a vast US geography, from Texas north through the Rocky Mountains. The business manages a diverse portfolio which includes an extensive unconventional resource base of about 7.5 billion barrels of oil equivalent across 5.5 million gross acres in some of the largest and most well-known basins in the US. Headquartered in Denver (Colorado), BPX Energy employs about 1,700 people across six states, operates more than 9,600 producing wells and has 70,000 royalty owners. Our vision is to be the premier, high return, onshore exploration and production company that consistently increases asset value. Our Wyoming operations are anchored on the giant Wamsutter tight gas field in the south central part of the state. In the San Juan area of Colorado and New Mexico we produce from tight gas sands and operate the largest coal-bed methane field in the US. Our Mid-Continent operations cover the prolific Anadarko, and is home to the famed East Texas basin, along with the Woodford shale gas play and Arkoma basin. We also have non-operating interests in over 10,000 wells across the US with substantial positions in both the Eagle Ford and Fayetteville shale basins. In 2018, BP completed a $10.5 billion acquisition of BHP's world-class unconventional oil and gas assets in the Permian-Delaware basin in Texas, along with two premium positions in the Eagle Ford and Haynesville basins in Texas and Louisiana. These assets currently produce 190,000 barrels of oil equivalent per day, of which about 45 percent are liquid hydrocarbons. The deal represents BP’s largest purchase since buying ARCO in 1999. It is a transformational acquisition for our BPX Energy business which gives the BPX Energy team access to some of the best acreage in some of the best basins in the onshore U.S.
Job Family Group:
Job Profile Summary:
Responsible for supporting the delivery of business analysis and consulting processes and procedures for the defined specialism using basic technical capabilities, developing working relationships to provide support with queries, issues and ad-hoc requests and assisting with quality assurance services.Specialisms: Business Analysis; Data Management and Data Science; Digital Innovation.
United States of America
United States - Colorado - Denver
The Data Engineer is responsible for the maintenance, improvement, cleaning, and manipulation of data in L48’s operational and analytics databases. The Data Engineer works with the L48’s IT platform owners, data analytics teams, data scientists, and data warehouse architect in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any existent issues.
The Data Engineer has to be an expert in SQL development further providing support to the Data and Analytics team in database design, data flow and analysis activities. The position of the Data Engineer also plays a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing.
The Data Engineer defines and builds the data rules and pipelines that will enable faster, better, data-informed decision-making within the business
The Data Engineer ensures stable solutions, stable infrastructure and participates in the design and build of services, integrations, and ETL solutions
Creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of L48’sdatabases.
Leads innovation through exploration, benchmarking, making recommendations, and implementing data technologies
Leadsthe development and implementation of scripts for database maintenance, monitoring, performance tuning, and so forth– in collaboration with IT DBAs and support groups.
Designing and developing scalable ETL packages from the business source systems and the development of ETL routinesin order topopulate databases from sources and also to create aggregates
Enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to MySQL; or on-premises to cloud;
Responsible for performing thorough testing and validationin order tosupport the accuracy of data transformations and data verification used inany service.E.greporting, visualizations,machine learning models
Ensure proper data governance and quality across the Data and Analytics department and the business as a whole
Implement Master Data Management solutions, processes and governance to support Data Management team
Performs ad-hoc analyses of data storedin the L48’sdatabases anddesigns, develops and testsSQL scripts, stored procedures, functions, and views
Troubleshoots data issues within the business and across the business and presents solutions to these issues
Analyze complex data elements and systems, data flow, dependencies, and relationshipsin order tocontributeto & defineconceptual physical and logical data models
Collaboratively works with the entire Data and Analytics team, providing support to the entire department for its data centric needsKey technologies
5-7 years of experience with SQL Server On-Prem and/or Azure cloud, required
5-7 years of SSIS experience utilizing SQL Agent jobs and Integration Services Catalog, required
3-4 years of experience running ETL/ELT SSIS projects independently from end to end, required
2+ years of Python programming experience, preferred
Experience with DevOps Repository and Git, preferred
Azure cloud experience, preferred
AWS cloud platform experience, a plus
Azure Data Lake storage experience, a plus
Azure Data Factory and/or Databricks experience, a plus
BP Americas, Inc.
- BP Americas, Inc. Jobs