Skip to main content

Data Engineer

Posted: 12 Oct 2020 Closes: 11 Dec 2020
Berkshire-Maidenhead, UK Competitive
Permanent & Full-time COS_4919

About Costain and your project.

Costain helps to improve people's lives with integrated, leading edge, smart infrastructure solutions across the UK's energy, water, transportation and defence markets. We help our clients improve their business performance by increasing capacity, improving customer service, safeguarding security, enhancing resilience, decarbonising and delivering increased efficiency. Our vision is to be the UK's leading smart infrastructure solutions company. We will achieve this by focusing on blue chip clients whose major spending plans are underpinned by strategic national needs, regulatory commitments, legislation or essential performance requirements. We offer our clients leading edge solutions that are digitally optimised through the following five services which cover the whole lifecycle of their assets: future-shaping strategic consultancy; consultancy and advisory; digital technology solutions; asset optimisation and complex programme delivery. Our culture and values underpin everything we do.

We are looking for a Data Engineer on a Business Intelligence project that is building a Reporting/Dashboarding solution and Data Virtualisation layer through the use of SAP's latest cloud platforms for BI/Reporting and Data Integration.

This is an exciting opportunity to be working with a leading edge team who are digitally transforming operations within Central Government.

To be successful in this role, these are the key capabilities that we are looking for:
  • Be agile in learning.
  • Be intuitive to think outside the box when solving problems.
  • Can quickly understand the fundamentals of an industry and how it works.
  • Data Intuition - Contextualize and translate a data to provide insights.
What will I be doing?

As an experienced Data Engineer, you will help to model and design the Data Virtualisation layer required to support specific Dashboards as well as design a number of staging databases to be used to transform and store the data retrieved from source systems.

The role may be extended to support the integration with those source systems using ETL and/or API based design patterns.
About you

Must have experience:

- Business Analysis and Data Analysis

- BI/Reporting/Dashboarding Development

- Conceptual and Logical Data Model Design

- Physical Data Model / Relational Database Design

- Relational Database Management System (e.g. SQLServer, AzureSQL, Oracle) Design and Configuration

- Data Integration Design and Development - ETL, Views, SQL queries, Data Warehousing

- Systems Integration Design and Development - Middleware, Web Services/APIs (e.g. SOAP, REST, OData)

Ideally have experience with:

- SAP HANA database

- Data Virtualisation

- SAP Cloud Platform (SCP)

- SAP Cloud Platform Integration (CPI)

- Azure Data Factory

Additional experience that would be beneficial:

- Software Development

- System/Integration Test Preparation and Execution

- SAP Analytics Cloud (SAC)

- Older, equivalent SAP products/technologies, e.g. SAP BO, SAP BW

- Data Science (analytics, modelling, machine learning, AI)
Final Statement

We listened to our employees so our Core Benefits are funded by us and include a Group Pension Scheme, Employee Assistance Programme, Life Assurance, Income Protection and funded membership to a Professional Institute. In addition to this we also offer a Private Healthcare Scheme, Private Dental Scheme, Cycle to Work, Volunteering Days and Save as You Earn Scheme.

At Costain we aim to be an accessible, diverse and inclusive organisation to continue to meet our customers' needs. We will be industry leading in our approach and people from all backgrounds will be proud to work for Costain. Our goal is to have a workforce that is representative of society.

We actively encourage applications from candidates who have a relationship with the armed forces community whether as a currently serving member or reservist, ex-military or wounded personnel or as a member of a service family.

SCS Railways

Share Job