Job Location: Denver, CO
Job Profile Summary
Role Synopsis
As part of the Data Platforms team, the Data Engineer position contributes to the overall BPX Data Platform Strategy.
- Define data workflow, pipelines, security, and ELT/ETL guidelines, policies, and procedures
- Provide oversight to ensure that project teams are following the approved data workflow, pipelines, security, and ETL/ELT processing guidelines
- Evaluate, compare, and recommend new Data Platform vendor products and/or tools
- Partner with project teams to provide technical direction and new integration patterns, where needed, for complex and/or large data sets
- Present modifications to Data Platforms to the Architecture Review Board for approval
Job Advert
Key Accountabilities
- Responsible for the development, guidance, and oversight for data ingestions and integrations for BPX cloud data platforms.
- Work with project teams to provide direction on approved patterns to meet the project data requirements for our Data Platforms.
- Strong SQL development knowledge required to provide support to project developers/users for database design, data flow and analysis activities.
- Development and deployment of innovative big data platforms for advanced analytics and data processing.
- Define and build the data rules and pipelines that will enable faster, better, data-informed decision-making within the business.
- Ensure stable solutions, stable infrastructure, and participate in the design and build out of data solutions.
- The database and data support roles are outsourced to a managed services partner that resides within the Data Platform team, and this role will require the ability to work and partner with those resources.
- Create data storage solutions optimized for performance and maintain data architecture standards across BPX Data Platforms.
- Partner with the Data Quality Lead to incorporate testing and validation scripts to support the accuracy of data transformations.
- Implement Master Data Management solutions, processes, and governance to support the Data Management team.
- Partner with the DataOps support team to troubleshoot data issues and provide guidance for solving these issues.
- Drive excellent, consistent customer service.
Essential Education
- BS in Computer Science, MIS, Mathematics, or equivalent degree preferred but not required.
Essential Experience and Job Requirements
- 3-5+ years of Data Engineering experience
- 3-5+ years of relevant work experience in IT/Data and/or Analytics space
- Experience in any cloud data warehouse, Snowflake preferred
- Experience with replication tools, Fivetran preferred
- Experience with transformation tools, dbt preferred
- Experience with programming tools, python preferred
- Experience with REST APIs for data ingestion
- Strong understanding of ETL/ELT processing with large data stores
- Experience designing and delivering large scale, 24-7, mission-critical data pipelines and features using modern big data architectures
- Stream processing services such as Kafka, AWS Kinesis, Apache Storm, Spark Streaming, Azure Event Grid etc
- Demonstrated experience working in large-scale data environments which includes real-time and batch processing
- Strong data modeling skills (relational, dimensional, and flattened)
- Strong analytical and SQL skills, with attention to detail
- Ability to aid in tuning and performance recommendations for poor performing SQL queries and/or python scripts
- Knowledge of Database Administration tasks – Indexing, SQL Tuning/Performance, Backup/Recovery, DR
- Ability to work with multiple external teams and accomplish shared goals by building consensus
- Strong communication (written/verbal) and collaboration skills
- Consulting, negotiation, and relationship skills
- Problem solving skills
We offer a reward and wellbeing package to enable your work to fit with your life. These can include, but not limited to, access to health, vision and dental insurance, flexible working schedule, paid time off policy, discretionary annual bonus program, long-term incentive program, and a generous 401K matching program. How much do we pay (Base)? $126,014-$194,530*Note that the pay range listed for this position is a good faith and reasonable estimate of the range of possible base compensation at the time of posting.
Entity
Production & Operations
Job Family Group
Operations Group
Relocation available
No
Travel required
Negligible travel
Time Type
Full time
Country
United States of America
About BP
PRODUCTION & OPERATIONS
This is the place to truly drive change. Our people develop hydrocarbon resources, deliver projects, operate refineries as well as oil and gas production assets.
Join us and make a difference by:
- making our production and operations safer and more standardised
- driving quicker reduction of our carbon emissions
- growing cash returns and delivering improved reliability and optimisation
- maximising efficiency through sharing resources
- accelerating the digital transformation of our operating assets
- developing our people faster, leveraging the scale of P&O
- building greater integration and collaboration in service of our purpose
Legal disclaimer
If you are selected for a position in the United States, your employment will be contingent upon submission to and successful completion of a post-offer/pre-placement drug test(and alcohol screening/medical examination if required by the role) as well as pre-placement verification of the information and qualifications provided during the selection process. The drug screen requires a hair test for which BP must be able to obtain a sufficient hair sample for analysis (~4 cm/1 ½” scalp, or > 2 cm/¾” body – arms & armpits/legs/chest)
As part of our dedication to the diversity of our workforce, BP is committed to Equal Employment Opportunity. Applicants will receive consideration for employment without regard for race, color, gender, religion, national origin, disability, veteran status, military status, age, marital status, sexual orientation, gender identity, genetic information, neurodiversity/neurocognitive functioning or any other protected group status. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application procedures. If you need assistance or an accommodation due to a disability, you may contact us or have one of your representatives contact us at PeopleCareHouston@bp.com; or by telephone at 833 478 7480 8am-5pm CST/CDT Monday-Friday.
Read the Equal Employment Opportunity is the Law poster and the poster supplement – for more information about Equal Employment Opportunities. (Spanish version)
BP is an equal employment opportunity and affirmative action employer. View our policy statement
Submit CV To All Data Science Job Consultants Across United States For Free