Data Engineer

Petrofac is a leading international service provider to the energy industry, with a diverse client portfolio including many of the world’s leading energy companies.

We design, build, manage, and maintain infrastructure for our clients. We recruit, reward, and develop our people based on merit, regardless of race, nationality, religion, gender, age, sexual orientation, marital status, or disability. We value our people and treat everyone who works for or with Petrofac fairly and without discrimination.

The world is re-thinking its energy supply and energy security needs and planning for a phased transition to alternative energy sources. We are here to help our clients meet these evolving energy needs.

This is an exciting time to join us on this journey.

Are you ready to bring the right energy to Petrofac and help us deliver a better future for everyone? 

JOB TITLE: Data Engineer

KEY RESPONSIBILITIES:

Architecting and defining data flows for big data/data lake use cases.

·Excellent knowledge on implementing full life cycle of data management principles such as Data Governance, Architecture, Modelling, Storage, Security, Master data, and Quality.

·Act as a coach and provide consultancy services and advice to data engineers by offering technical guidance, and ensuring architecture principles, design standards and operational requirements are met.

·Participate in the Technical Design Authority forums.

·Collaborates with analytics and business stakeholders to improve data models that feed BI tools, increasing data accessibility, and fostering data-driven decision making across the organization.

·Work with team of data engineers to deliver the tasks and achieving weekly and monthly goals, also to guide the team to follow the best practices and improve the deliverables.

·Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.

·Responsible for estimating the cluster size, core size, monitoring, and troubleshooting of the data bricks cluster and analysis server to produce optimal capacity for computing data ingestion.

·Deliver master data cleansing and improvement efforts; including automated and cost-effective solutions for processing, cleansing, and verifying the integrity of data used for analysis.

·Expertise in securing the big data environment including encryption, tunnelling, access control, secure isolation.

·To guide and build highly efficient OLAP cubes using data modelling techniques to cater all the required business cases and mitigate the limitation of Power BI in analysis service.

·Deploy and maintain highly efficient CI/CD devops pipelines across multiple environments such as dev, stg and production.

·Strictly follow scrum based agile approach of development to work based on allocated stories.

·Comprehensive knowledge on data extraction, Transformation and loading data from various sources like Oracle, Hadoop HDFS, Flat files, JSON, Avro, Parquet and ORC.

·Experience defining, implementing, and maintaining a global data platform

·Experience building robust and impactful data visualisation solutions and gaining adoption

·Extensive work experience onboarding various data sources using real-time, batch load or scheduled loads. The sources can be in cloud, on premise, SQL DB, NO SQL DB or API-based.

·Expertise in extracting the data through JSON, ODATA, REST API, WEBSERVICES, XML.

·Expertise in data ingestion platforms such as Apache Sqoop, Apache Flume, Amazon kinesis, Fluent, Logstash etc.

·Hands on experience in using Databricks, Pig, SCALA, HIVE, Azure Data Factory, Python, R

·