Senior Data Engineer- Azure (ADF, Data lake)

Key Skills

Alteryx, Apache Kafka, AWS, Azure, Big Data Technology, Data Analytics, Data Architecture, Data Lake, Data pipelines, Data science techniques, Data structuring, Design, Effective communication skills, ETL/ELT technologies, Infrastructure as code, KPI, Leadership Skill, NoSQL, Optimization, PySpark, Python Programming, Scala Programming, SPARK Programming, SPARQL, SQL

Job Description

Shell’s 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’s 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 ‘big data’ 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 8+ years of experience in a Data Engineer role, who has attained a Graduate degree and at least have a Seniority level in their previous workplace.

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 – 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