data engineer - Houston, United States - Shell Energy

Description

At Shell Energy Solutions, we believe there's a better way to power your business and home.

Aligned with Shell's ambition to be a significant global power business and to become net zero by 2050, our cleaner, affordable and simple solutions help companies manage their energy spend and plan their sustainability roadmap - a fresh approach for environmentally conscious businesses that are looking to boost their sustainability credentials.

We also have set out to deliver the very best experience to our customers across all our channels.

Shell Energy Solutions mission is delivering cleaner energy solutions for a brighter tomorrow by guiding customers toward a better energy future, enabling customer choice and by providing market-leading energy solutions.

Going above and beyond for our customers is what we're all about and we have set out to deliver the very best experience to our customers across all our channels.

But bigger challenges lie ahead, and we need to keep moving forward. Are you ready to help us get there?


WHERE YOU FIT IN
We are looking for a savvy Data Engineer to join our growing team of data platform experts.

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.

Reporting into the Data Platform Manager, the role requires self-motivated, dedicated and responsible individual with the ability to perform well under pressure.

Job Duties & Responsibilities

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 'big data' technologies and tools.

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 availability 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.
Other duties as assigned

Essential Skills & Experience

Successful job applicants will be able to perform these functions. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions.

5+ years of experience in a Data Engineer role.

Experience using the following software/tools:

Experience with data tools:
Dremio (primary), Databricks, Spark, etc.
Experience with relational SQL and NoSQL databases, including MSSQL, Postgres, MongoDB, TimescaleDB, etc.
Experience with data pipeline and workflow management tools: Airflow (primary), Kubeflow, Azkaban, Luigi, etc.
Experience and competency in AWS services: EC2, S3, EFS, EMR, RDS, etc.

Familiarity with data warehouse technologies:
RedShift, SQL DW, Snowflake
Experience with stream-processing systems: Kafka (primary), Spark-Streaming, Change Data Capture, etc.
Experience with object-oriented/object function scripting languages: Python (primary), Golang, Java, C++, Scala, etc.

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 data pipelines and curated data queries.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

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 data lakes.
Be a proactive team player - we're a small team with big ambitions in doing things at speed.

As we work across a number of channels, projects, and conflicting priorities, being able to navigate and juggle multiple things on the go is required as well as being proactive enough to anticipate the next steps and actions.

Good communication skills, written and oral, for example ensuring sales agents are kept informed of any delays in turning around pricing requests, or outlining the rationale behind a decision not to approve credit for a customer.

Analytical mindset, demonstrate ability to problem solve and create practical solutions to overcome problems and mitigate risks.
Comfortable working in a target-driven and fast-changing environment, and able to respond to changing business needs
Excellent attention to detail
Proficient use of Microsoft Office programs including Word, Outlook and strong Excel skills
Excellent analytical, organization and time management skills, with the ability to maintain a strict level of attention to detail
Ability to work well within a team environment and demonstrate a vested interest in team goals and objectives
Excellent interpersonal, verbal and written communication skills, with the ability to establish and maintain positive and effective working relationships
Self-motivated with the desire to consistently improve performance and gain further knowledge
Ability to meet deadlines, learn quickly and demonstrate effective problem solving and follow-up skill.

LOCATION & WORK SCHEDULE

Required to be in-person in Houston, TX through a hybrid workplace environment.

Benefits Of Working With Shell Energy

Competitive Compensation
Health Care - Medical/Dental/Vision/Prescription Drug Coverage
401(k) with Company Matching Contributions
Flexible Spending Accounts (FSA)
Health Savings Accounts (HSA)
Disability Programs (STD & LTD)
Employee Basic Term Life Insurance
Generous Vacation & Company Holidays
Flexible hybrid working schedule
Training and coaching
Tuition Reimbursement
Paid Parental Leave
And much more


SHELL ENERGY VALUES
Shell is a company with shared values.

Honesty, integrity, and respect aren't simply a strapline:
they are part of everything we do.

What's more, Shell is an equal opportunities company, and we place the highest possible value on the diversity of our people and our inclusive approach.

Join us and you'll belong to a world where you are proud of your achievements and propel your career with global opportunities.

We care deeply about fostering a truly diverse workplace.

Job descriptions are not intended as, nor should be construed to be, exhaustive lists of all responsibilities, skills, efforts, or working conditions associated with a job.

They are intended to be accurate reflections of those principal job duties and responsibilities essential for making fair pay decisions about the job.

#J-18808-Ljbffr