Lead Consultant-Data Engineering & Analytics Energy Domain Sunbury

Role - Lead Consultant
Technology - Data Engineering & Data Analytics, Energy (Oil&Gas) domain
Location - London/Sunbury, UK
Business Unit - SURENRGY
Compensation - Competitive (including bonus)

Your role
As a Lead Consultant, you will be involved in the entire software development lifecycle, from conception to completion. The data modeler designs, implements, and documents data architecture and data modelling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

Your responsibilities will include:

1. Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
2. Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models.
3. Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
4. Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
5. Hands-on modelling, design, configuration, installation, performance tuning, and sandbox POC.
6. Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
7. Design and document solutions to ensure maintainability and conduct reviews to ensure solutions follow best practices and solve the business problem.
8. Work collaboratively with delivery teams including users, data scientists, statisticians, and analysts to develop data solutions and pipelines that meet their analytical and reporting needs.
9. Assemble large, complex data sets that meet functional / non-functional business requirements.
10. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
11. Optimize the performance of corporate data platforms and services to ensure that they can handle large volumes of data and support real-time processing and analysis.
12. Own and manage the end-to-end data platform, including data ingestion and processing while helping determine appropriate storage policies and access management processes.
13. Contribute to the emergent architecture with the Solution Architect and fellow team members.
14. Develop the code and necessary tests to build quality functionalities as per the Acceptance Criteria.
15. Build the necessary DevOps capabilities like Continuous Integration (CI), Deployment (CD) and Testing (CT).
16. Participate in demonstrations of the product to the Product Owners during the Iteration review and System Demo.
17. Design and build metadata driven, event based distributed data processing platform using technologies such as Python, Airflow, Redshift, DynamoDB, AWS Glue, S3.
18. Develop a comprehensive understanding of the organization's data structures and metrics, advocating changes for product development.
19. Build and optimize data ingestion pipelines using AWS services such as Lambda, Kinesis, and Glue.
20. Develop, maintain, and optimize transformation pipelines within our Delta Lake on Databricks.

Required

1. Strong understanding of Energy (Oil & Gas) industry, and work experience with the domain applications.
2. Strong experience in a Data Engineering Role with an extensive understanding and practical experience on all aspects like development (AWS, CI/CD), Testing and DevOps.
3. Hands-on experience with relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
4. Experience with data warehouse, data lake, and enterprise big data platforms in multi-data center contexts required.
5. Good knowledge of metadata management, data modelling, and related tools (Erwin or ER Studio or others) required.
6. AWS Glue, AWS Redshift/Spectrum, S3, API Gateway, Athena, Step and Lambda functions.
7. Experience in ETL and ELT data integration pattern, designing and building data pipelines.
8. End to end responsibility of Project Architecture/Design and operations.
9. Development experience in one or more object-oriented programming languages (e.g. C++, C#, Java, Python, Golang, PowerShell, Ruby) Preferably Python.
10. Database: PostgreSQL, Microsoft SQL, Oracle.
11. Experience designing and implementing large-scale distributed systems.
12. Use of Azure DevOps for backlog, wiki, code repositories and CI/CD pipelines.

Personal

1. High analytical skills.
2. A high degree of initiative and flexibility.
3. High customer orientation.
4. High quality awareness.
5. Excellent verbal and written communication skills.

About Us
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

All aspects of employment at Infosys are based on merit, competence and performance. We are committed to embracing diversity and creating an inclusive environment for all employees. Infosys is proud to be an equal opportunity employer.