Projects and Technology (P&T) supports Shell’s
operated and non-operated assets, safely improving performance and raising the
bar being a responsible operator. We use our technical, commercial, and digital
skills to competitively optimise production and we replicate technologies
across the portfolio. P&T also has a role to play making our assets top
quartile on emissions intensity.
What’s the role?
We are looking for a highly experienced Data
Engineer to join our Data & Analytics team in Shell Energy Trading
Americas. This position will be a hybrid role between Data and DevOps
Engineering and the successful candidate will be leading the modernization of
our Data & Digital landscape. The hire will be responsible for expanding
and optimizing our data and data pipeline architecture, as well as optimizing
data flow and collection for cross functional teams. The ideal candidate is an
experienced data pipeline builder and data wrangler who enjoys optimizing data
systems and building them from the ground up. The Data Engineer will support
our software developers, database architects, data analysts and data scientists
on data initiatives and will ensure optimal data delivery architecture is
consistent throughout ongoing projects. They must be self-directed and comfortable
supporting the data needs of multiple teams, systems and products. The right
candidate will be excited by the prospect of optimizing or even re-designing
our company’s data architecture to support our next generation of products and
data initiatives.
Accountabilities:
Create and maintain optimal data pipeline
architecture.
Assemble large, complex data sets that meet
functional / non-functional business requirements.
Identify, design, and implement internal process
improvements: automating manual processes, optimizing data delivery,
re-designing infrastructure for greater scalability, etc.
Build the infrastructure required for optimal
extraction, transformation, and loading of data from a wide variety of data
sources using SQL and Azure, AWS ‘big data’ technologies.
Build analytics tools that utilize the data pipeline
to provide actionable insights into customer acquisition, operational
efficiency and other key business performance metrics.
Work with stakeholders including the Executive,
Product, Data and Design teams to assist with data-related technical issues and
support their data infrastructure needs.
Keep our data separated and secure across national
boundaries through multiple data centers and Azure, AWS regions.
Create data tools for analytics and data scientist
team members that assist them in building and optimizing our product into an
innovative industry leader.
Work with data and analytics experts to strive for
greater functionality in our data systems
Advanced working SQL knowledge and experience
working with relational databases, query authoring (SQL) as well as working
familiarity with a variety of databases.
Experience building and optimizing ‘big data’ data
pipelines, architectures and data sets.
Experience performing root cause analysis on
internal and external data and processes to answer specific business questions
and identify opportunities for improvement.
Strong analytic skills related to working with
unstructured datasets.
Build processes supporting data transformation, data
structures, metadata, dependency and workload management.
A successful history of manipulating, processing and
extracting value from large, disconnected datasets.
Working knowledge of message queuing, stream
processing, and highly scalable ‘big data’ data stores.
Strong domain knowledge of Energy &/or Trading.
Experience supporting and working with
cross-functional teams in a dynamic environment
What we need from you?
Must have legal authorization to work in the US on a
full-time basis for anyone other than current employer
Minimum fifteen (15) years of experience in a Data
Engineer or DevOps & Build Engineer role
Bachelors degree is a must
Experience with Azure: ADLS, Databricks, Stream
Analytics, SQL DW, COSMOS DB, Analysis Services, Azure Functions, Serverless
Architecture, ARM Templates
Experience with relational SQL and NoSQL databases,
including Postgres and Cassandra.
Experience with object-oriented/object function
scripting languages: Python, SQL, Scala, Spark-SQL etc.
Nice to have experience with big data tools: Hadoop,
Spark, Kafka, etc.
Nice to have experience with data pipeline and
workflow management tools: Azkaban, Luigi, Airflow, etc.
For regular full-time or regular part-time employees
of the Company (participating companies as listed in the Summary Plan
Description), insurance coverage options include medical, dental, vision
coverage, life Insurance, Business Travel Accident Insurance, and Occupational Accidental
Death Benefit programs. Employees also participate in a company pension plan
and a 401(k) plan. Paid leave includes up to 6 weeks of paid vacation time, up
to 11 paid holidays, and parental leave offering 16 weeks of paid leave to
birthing mothers, and 8 weeks of paid leave for non-birthing parents.
Additionally, employees are eligible for disability leave for up to 52 weeks at
100% or 50% of base pay. Shell also offers other compensation such financial
reimbursement for adoption, wellness, education, and personal learning
expenses, and some roles are eligible for discretionary long-term incentives.
For interns, eligible benefits include medical, dental, and vision coverage,
life insurance, Business Travel Accident Insurance, and Occupational Accidental
Death Benefit programs; participation in a 401(k) plan; and paid leave for up
to 11 paid holidays. Additional information on Shell’s US benefit programs can
be found at
https://www.shell.us/careers/about-careers-at-shell/rewards-and-benefits.html
COMPANY DESCRIPTION
Shell is a global group of energy and petrochemicals
companies with over 90,000 employees in more than 70 countries and territories.
In the US, we have operated for over a century and are a major oil and gas
producer onshore and in the Gulf of Mexico, a recognized innovator in
exploration and production technology, and a leading manufacturer and marketer
of fuels, natural gas and petrochemicals. We deliver energy responsibly;
operate safely with respect to our neighbours and work to minimize our
environmental impact. We are in search of remarkable people who will thrive in
a diverse and inclusive work environment to deliver exciting projects locally
and globally. People who are passionate about exploring new frontiers.
Innovators and pioneers. People with the drive to help shape our future.
Because remarkable people achieve remarkable things.
An innovative place to work
There’s never been a more exciting time to work at Shell. Everyone here is helping solve one of the biggest challenges facing the world today: bringing the benefits of energy to everyone on the planet, whilst managing the risks of climate change.
Join us and you’ll add your talent and imagination to a business with the power to shape the future – whether by investing in renewables, exploring new ways to store energy or developing technology that helps the world to use energy more efficiently.
An inclusive place to work
To power progress together, we need to attract and develop the brightest minds and make sure every voice is heard. Here are just some of the ways we’re nurturing an inclusive environment – one where you can express your ideas, extend your skills and reach your potentials.
We’re creating a space where people with
disabilities can excel through transparent recruitment process, workplace
adjustments and ongoing support in their roles. Feel free to let us know about
your circumstances when you apply, and we’ll take it from there
We’re closing the gender gap – whether that’s
through action on equal pay or by enabling more women to reach senior roles in
engineering and technology
We’re striving to be a pioneer of an inclusive and
diverse workplace, promoting equality for employees regardless of sexual
orientation or gender identity
We consider ourselves a flexible employer and want
to support you finding the right balance. We encourage you to discuss this with
us in your application
A rewarding place to work
Combine our creative, collaborative environment and
global operations with an impressive range of benefits and joining Shell
becomes an inspired career choice.
We’re huge advocates for career development. We’ll
encourage you to try new roles and experience new settings. By pushing people
to reach their potential, we frequently help them find skills they never knew
they had, or make career moves they never thought possible.