Data Integration Engineer
- Corporate
- Worcester
Are you ready to take the next step in your career?
Apply for this roleThis vacancy has now expired. Please see similar roles below...
Atkins is part of the SNC Lavalin Group of companies, the delivery of its IT is via a function called Group IS. Our Group Information Services (Group IS) business is made up of digital, user service, technology and project management experts, working across multiple regions. Our teams are supporting globally including those based in offices and working on remote sites with our clients where we partner the business on some of the worlds iconic design and build and infrastructure projects.
Group IS has developed an operating model to evolve the way IT services are provided to the company, moving from a ‘Business as Usual’ focus to an organisation driven by a joint technology roadmap with the business and enabling business value. Here, the key focus areas include: getting the basics right, being a true partner to the business, information assurance & security, career management for our staff, and supporting the organization on its digital journey.
Purpose of the Role
Integration Engineer to support the delivery of multi-organisational integration projects and enterprise data-warehouse (including MDM, ODS and historic, modelled data).
The ideal candidate will be an experienced software developer with a background in building data pipelines, who enjoys optimising systems as well as building them from the ground up. The position holder will support our software developers, architects and analysts on initiatives and will ensure the optimal delivery architecture is applied throughout ongoing and future projects
Responsibilities
- Create and maintain optimal integration solutions including data pipeline architecture
- Assemble large, complex data sets that meet functional / non-functional business requirements.
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using on-premise SQL and Azure ‘big data’ technologies.
- Build, using Power BI outputs that utilize the data pipeline to provide actionable insights into operational efficiency and other key business performance metrics
- Work with stakeholders including the business leaders, product & data teams to assist with technical issues and support their infrastructure need.
- Keep our data separated and secure across national boundaries and compliant with client requirements where necessary
Requirements
- Experience delivering integration solutions using modern software technologies and techniques:
- Backend Technologies: ASP.NET Core using C#, Entity Framework Core
- UI Technologies: AngularJS, Angular (TypeScript), Razor Pages, Blazor
- A successful history of using DevOps best practises including backlog management, Source Control (Git), Continuous Integration (CI) and Continuous Delivery (CD) with Azure DevOps
- Experience building and optimizing ‘big data’ data pipelines, architectures and data sets
- 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 unstructured datasets
- Build processes supporting data transformation, data structures, metadata, dependency and workload management.
- A successful history of manipulating, processing and extracting value from large disconnected datasets.
- Experiences with on-premise SQL services: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services
- Experience with Azure cloud services: Web Apps, Hybrid Connections, Storage, Application Insights, Containerization, Azure Active Directory, Azure Automation, Key Vault, SQL Database, SQL Data Warehouse, Data Lake, Data Factory, Data Bricks, PowerBI
Training
Atkins develops individuals through a portfolio of training and development activities designed to help you make the best of your abilities and talents. These are reviewed with individuals through an annual appraisal process. We actively support staff in achieving corporate membership of relevant institutions.
Rewards and benefits:
Atkins offers a fantastic range of benefits, which you can tailor to suit your own health, wellbeing, financial and lifestyle choices.
All the information you need to know is available on our dedicated benefits portal; your reward, which is available to access 24/7 from any device: https://www.yourrewardatkins.com
Security Clearance:
This role may require security clearance and offers of employment will be dependent on obtaining the relevant level of clearance. If this is necessary it will be discussed with you at interview.
If applying to this role please do not make reference to (in conversation) or include in your application or CV, details of any current or previously held security clearance.
ATKINS, part of the SNC Lavalin Group, is committed to having a diverse and inclusive workforce. As an Equal Opportunities Employer, we value applications from all backgrounds, cultures and ability.
Are you ready to take the next step in your career?
Apply for this rolePreview
Middle EastContent type
BlogsPublish date
04/26/2024
Summary
By implementing reforms in the public sector and wider society, the KSA’s Vision 2030 has greatly improved government efficiency, bringing about new growth and investment opportunities. What is Visio
Preview
Middle EastContent type
BlogsPublish date
04/26/2024
Summary
By implementing reforms in the public sector and wider society, the KSA’s Vision 2030 has greatly improved government efficiency, bringing about new growth and investment opportunities. What is Visio
Related job roles
Salary
Location
Epsom
Job Type
Full Time
Career Area
Natural sciences
Market
Cities & development
Category
Permanent
Location
Epsom
Description
To meet our growing project workload and help us design and apply new approaches to our work, we are seeking an enthusiastic Assistant Ecologist to join our Epsom office and become a part of the Londo
Reference
R-114243
Expiry Date
01/01/0001
Author
Ritwi ChatterjeeAuthor
Ritwi ChatterjeeSalary
Location
Nashville
Job Type
Full Time
Career Area
Business management
Category
Permanent
Location
Nashville
Description
Why join us?It’s an exciting time at AtkinsRéalis! We are rapidly growing in the US. Our company purpose is to build a better world for our planet and its people. We recognize the importance of making
Reference
R-109390
Expiry Date
01/01/0001
Salary
Location
Atlanta
Job Type
Full Time
Career Area
Project management
Category
Permanent
Location
Atlanta
Grand Rapids
New York
Raleigh
Princeton
Description
Why join us?It’s an exciting time at AtkinsRéalis! We are rapidly growing in the US. Our company purpose is to build a better world for our planet and its people. We recognize the importance of making
Reference
R-109387
Expiry Date
01/01/0001
Salary
Location
Toledo
Job Type
Full Time
Career Area
Architecture
Category
Permanent
Location
Toledo
Description
Why join us? It’s an exciting time at AtkinsRéalis! We are rapidly growing in the US. Our company purpose is to build a better world for our planet and its people. We recognize the importance of maki
Reference
R-109386
Expiry Date
01/01/0001
Salary
Location
Chennai
Job Type
Full Time
Career Area
Linxon - NewCo
Category
Permanent
Location
Chennai
Description
Join Us! We combine AtkinsRéalis project management expertise and Hitachi Energy’s deep technological knowledge to create a company dedicated to substations – we are Linxon!The position will focus on
Reference
R-109374
Expiry Date
01/01/0001
Salary
Location
Chennai
Job Type
Full Time
Career Area
Linxon - NewCo
Category
Permanent
Location
Chennai
Description
Job DescriptionJob Title: Project Engineer (Primary)Location: Chennai, Bangalore, Vadodara & Faridabad, IndiaJoin Us! We combine AtkinsRéalis project management expertise and Hitachi Energy’s deep tec
Reference
R-109372
Expiry Date
01/01/0001
Salary
Location
Dartford
Job Type
Flexible Working
Full Time
Career Area
Civil engineering
Category
Permanent
Location
Potters Bar
Dartford
Leatherhead
Description
AtkinsRéalis, Balfour Beatty and Egis Road Operations UK are part of a consortium, creating Connect Plus Services, a unique partnership with a collective strength in highways asset care from finance,
Reference
R-109363
Expiry Date
01/01/0001
Author
Abhishek SahaAuthor
Abhishek SahaSalary
Location
Glasgow
Job Type
Full Time
Career Area
Engineering (Other)
Category
Permanent
Location
Epsom
Glasgow
Description
Job Synopsis:We are seeking an Engineering Manager to join our Net Zero Energy Business. This position would be based in the central belt of Scotland (or one of our other offices – Bristol, Birmingham
Reference
R-109362
Expiry Date
01/01/0001
Author
Sunitha HAuthor
Sunitha HSalary
Location
Bristol
Job Type
Full Time
Career Area
Engineering (Other)
Category
Permanent
Location
Epsom
Bristol
Description
Join us in building a carbon-free future!Engineers at AtkinsRéalis are at the heart of delivering transformative projects in the UK nuclear industry, reducing carbon emissions whilst achieving future
Reference
R-109356
Expiry Date
01/01/0001
Author
Rohith GAuthor
Rohith GSalary
Location
Melbourne
Job Type
Full Time
Career Area
Civil engineering
Category
Permanent
Location
Melbourne
Description
Why join us? We are hiring! Are you stuck at a company with no real opportunity or variety as a Civil CAD Designer? AtkinsRéalis is seeking a highly motivated and experienced Civil CAD Designer to jo
Reference
R-109348
Expiry Date
01/01/0001
AtkinsRéalis
Talent community
Would you like to know more? Not ready to apply? Join our talent community to stay connected and engaged with us at AtkinsRéalis.
Find out more