Data Engineer

  • Shell Energy
  • Milton Keynes, UK
  • 28/07/2022
Full time Data Engineering Business Intelligence Software Engineering jobs DevOps

Job Description

Job details

Salary
£26 a day
Job type
Full-time

Benefits

Pulled from the full job description
Cycle to work scheme
Employee discount
Employee mentoring program
Paid volunteer time
Private medical insurance

Full Job Description

LOCATION:
Milton Keynes
DEPARTMENT
Data Engineer
CONTRACT TYPE
Permanent
HOURS PER WEEK
37.5 hours per week
JOB REFERENCE
3154
OUR JOURNEY
At Shell Energy, we believe there’s a better way to power your business.
Aligned with Shell’s ambition to be a significant global power business and to become net zero by 2050, we are here to guide businesses to a better energy future. One that has the customer and a commitment to cleaner energy at the heart and makes it easy and affordable to embrace new technology.
We offer businesses across Britain 100% renewable electricity as standard. 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 offer natural gas to our customers with the option of supplying green gas on request.
WHO YOU’LL WORK WITH
We’re ambitious with a pace to match, and as part of one of the world’s largest companies, the opportunity and ability to push forward is greater than ever before.
We foster a culture of continuous improvement. Accountability matters, which means enabling transformation through autonomy to influence and see progress through.
Every day we work to provide an environment where all employees feel valued and included, and are able to nurture their talent as individuals and as part of a collaborative team.
A diverse and inclusive workplace, embedded in our principles of honesty, integrity and respect, brings together remarkable people and enables them to be themselves. At Shell Energy, you’ll be able to apply and develop your skills and knowledge as part of a collaborative team that’s helping to innovate.
YOUR PART IN OUR JOURNEY
Working within the Shell Energy Technology team, focused on Shell Energy UK (B2B) projects, this role will support our existing Senior Data Engineer, developing the solution delivery of Business and Technology led changes that affect systems and data.
We celebrate success as a team in pursuit of a common goal.
YOUR PART IN THE TEAM
Your role will be varied but at its core will revolve around building and maintaining robust data pipelines to ingest, transform and deliver the right data at the right time. You should be comfortable engaging with internal and external data owners to understand source data, negotiating
This is a really exciting opportunity for someone to join the Data Engineering team and help fundamentally support the day to day running of our data estate. We’re currently migrating to an AWS cloud hosted environment which exposes many opportunities for integration pipeline optimization in a leading new technology. This role will include but is not limited to:
Translating business problems and data related requirements into solution options, providing the conduit between the IT development teams and the business
Ensure that data is delivered daily to the business, supporting incident resolution when required
Designing, developing and implementing new and optimal data system/solutions, to meet business requirements (Creation of ingestion pipelines, data integration support etc)
Maintaining and improving the performance of existing data systems/solution, ensuring they are safe and reliable for the business
Adhering to IT Delivery governance, controls, methodologies and compliance standards and expectations
Proactively identifying, recommending and optimising delivery process, practices and tooling, supporting and driving continuous improvement across IT Delivery
WHAT YOU’LL NEED TO MAKE THE BEST OF THE ROLE
You will need to understand how data can be collected, analyzed and utilized; maintaining flexibility in the face of big data developments while understanding challenges and time sensitivity of the data in the domain. You will approach data challenges with a clear understanding of what is important; using the right approach and methods to maximise efficient use of time and resources.
The challenges of ensuring robust and resilient service will have given you experience in implementing proactive monitoring and resolving issues in a production environment, often working across multiple infrastructure service teams to achieve a solution.
You will have a strong background in SQL Server-based development. This will include a high level of competence in creating stored procedures and integration service packages to build robust data pipelines. You will also have experience in building reporting services BI reports for the business to consume data from. You will have strong Data Warehousing knowledge and understanding of the challenges of blending data to create single versions of truth and have the ability to optimise SQL code to improve query performance.
You will understand the importance of adhering to coding standards and documentation, be able to develop good working relationships with both technical and non-technical colleagues, and be able to articulate effectively and professionally at all times. You will have an understanding of devops processes and how they apply to data engineering.
THE NICE TO HAVES
Energy industry experience, particularly B2B
OUR CORE VALUES
WHAT’S IN IT FOR YOU:
Lifestyle
Exclusive Retail Discounts (from nearly 900 retailers)
25 days holiday (plus Bank Holidays) and Holiday Trading Scheme
Quarterly Team Socials
Employee Energy and Broadband Tariffs
Company wide bonus scheme
Well-being
Access to our Wellbeing centre to aid you with our four M’s (Moving, Mind, Money and Munch)
Charity events to support our charity partner, including a paid day off each year to volunteer
BUPA Private Healthcare and Cash Plan
Cycle to Work Scheme
Development Opportunities
Mentoring Scheme
Apprenticeship Schemes
Development Portal to access development material
Family Friendly
Company maternity/adoption pay: 
26 weeks full pay, followed by 13 weeks statutory pay for
eligible employees.
Two weeks full paternity pay
Life Assurance
Pension Scheme