BP Americas, Inc. Data Engineer in Denver, Colorado
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 datawarehouse architect in order to understand and aid in the implementation ofdatabase 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 andAnalytics 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; ensures stable solutions, stable infrastructure and participates in the designand build of services, integrations, and ETL solutions
This person must be comfortable operating as an individual contributor and using influence and expertise to aid the transformation of an organization.
Some of L48’s technologysupport & operations are outsourced to a managed services partner and this role will require the ability to manage/lead in this type of environment.
United States - Colorado - Denver
Is this a part time position?:
Yes - Domestic (In country) only
Yes - up to 10%
Creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all of L48’s databases.
Leads innovation through exploration, benchmarking, making recommendations, and implementing data technologies
Leads the 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 routines in order to populate 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 validation in order to support the accuracy of data transformations and data verification used in any service. E.g reporting, 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 stored in the L48’s databases and designs, develops and tests SQL 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 relationships in order to contribute to & define conceptual physical and logical data models
Collaboratively works with the entire Data and Analytics team, providing support to the entire department for its data centric needs
Be knowledgeable of industry trends and best practices, advising senior management on new and improved data engineering strategies that will drive departmental performance leading to improvement in overall improvement in data governance across the business, promoting informed decision-making, and ultimately improving overall business performance
Drive excellent, consistent customer service.
Ensure the proper management, maintenance and provisioning of all environments, databases and related technologies and solutions.
Enhances department and organization reputation by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.
Ability to inspire change across the business and create an understanding around cloud usage
Generates enthusiasm among team members.
Proactively seeks opportunities to serve in leadership roles.
Challenges others to develop as leaders while serving as a role model.
Manages the process of innovative change.
Collaborates with and influences others not in direct line
Facilitates effective team interaction.
Acknowledges and appreciates each team member's contributions.
Works effectively with distributed team members
BS in Computer Science, Mathematics, or equivalent degree
Desirable criteria and qualifications:
Experience with the Azure and/or AWS cloud platforms
Supervision, management or leadership position experience desirable.
Desire to continually learn outside of a classroom environment, and successfully apply learnings
Demonstrated willingness to both teach others and learn new techniques
BP's US Lower 48 (L48) Onshore business 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 Houston (Texas), L48 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 most respected and admired oil and gas company in the Lower 48 US states.
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 2015, the L48 Onshore is being established as a separate business within BP’s Upstream to manage its onshore oil and gas assets across the US onshore. This effort is being undertaken to improve competitiveness and help L48 remain at the forefront of innovation and development of technologies for unconventional resources.
Application close date:
Business Analysis & Consulting
Information Technology & Services
United States - Colorado
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 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 BPUSApplicationAssis@bp.com or by telephone at 281.366.1999.
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 .
Essential experience and job requirements:
5+ years of relevant work experience in IT/Data & Analytics with 7+ years of software development and/or data engineering experience
Experience in any big data technologies - Hadoop, EMR, Amazon Redshift, Azure CosmosDB, Azure Data Lake, AWS DynamoDB, or advanced analytics tools
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 Hub, etc.,.
Demonstrated experience working in large-scale data environments which included real-time and batch processing requirements
Strong understanding of ETL processing with large data stores
Strong data modeling skills (relational, dimensional and flattened)
Strong analytical and SQL skills, with attention to detail
Validated experience with 1 or more non-SQL languages such as Python or Java or like
Experience working in a hybrid environment with multiple datacenters, multiple public cloud and SaaS providers.
Knowledge of and experience implementing complex applications e.g. service oriented architectures or distributed graphics processing engines
Strong communication (written/verbal) and collaboration skills
Consulting, negotiation and relationship skills
Problem solving skills
Enthusiastic, high-energy individual, self-motivated, people-oriented and self-directed
Must be an intelligent, articulate and persuasive leader who can serve as an effective member of the team, who can communicate concepts to technical & nontechnical colleagues
Must be able to maintain focus on achieving results, whilst being patient and pragmatic
Other Requirements (eg Travel, Location):
There are no additional requirements. Please respond with N/A below.
If you are applying for a position in the United States, you must be at least 18 years of age, legally authorized to work in the United States; and not require sponsorship for employment visa status (e.g., TN, H1B status), now or in the future.