Job Description

Join the number One Global Lubricants supplier in the world and be part of the team that helps in shaping up the digital and the IDT strategy which delights our customers in over 100 countries across every sector. If you are looking for a place where you can gain hands-on exposure and have direct impact, then this is the place for you! Where you fit Shell\xe2\x80\x99s Projects and Technology (P&T) business exists to make the delivery of our strategies and the growth of our company possible. Our team develops the advanced products and technologies Shell needs to meet customer demand. Our solutions help our partners grow the LNG, Gas and Power businesses, deepen the integration of Manufacturing, Chemicals and Trading, and maximise the competitiveness of our Upstream business. What\xe2\x80\x99s the role? As a Data Engineer in Shell, you will create and maintain optimal data pipeline architecture and also will assemble large, complex data sets that meet functional / non-functional business requirements. You will also identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs. More specifically, your role will include:

• Build the infrastructure required for optimal ETL/ELT of data from a wide variety of data sources using SQL and Azure, AWS \xe2\x80\x98big data\xe2\x80\x99 technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other KPI metrics.
• Keep our data separated and secure across national boundaries through multiple data centres 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.

What we need from you
We are looking for a candidate with 4-8 years of experience in a Data Engineer role, who has attained a Graduate degree. They should also have experience using the following software/tools:

• Experience with Azure: ADF, ADLS, Databricks, PySpark, Spark SQL, Stream Analytics, SQL DW, COSMOS DB, Analysis Services, Azure Functions, Serverless Architecture, ARM Templates.
• Experience with relational SQL/NoSQL databases, file handlings and API integrations
• Experience with object-oriented/object function scripting languages: Python, SQL, Scala, Spark-SQL etc.
• Nice to have experience with any of these toolset like Kafka, Stream sets, Alteryx, HANA, SLT and BODS

Skills \xe2\x80\x93 Nice to Have

• 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 using ADF
• 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 structured and unstructured datasets
• Build processes supporting data transformation, data structures, metadata, dependency and workload management.
• A successful history of transforming, processing and extracting value from large disconnected datasets
• Strong team player with organizational and communication skills
• Experience supporting and working with cross-functional teams in a dynamic environment