ETL Developer

Apply Here

This vacancy has closed.
For a career in nuclear energy and waste management, visit:
Nuclear Careers

Cargo Fleet | Middlesbrough
Starting Salary £:
Job Description

We currently have an opportunity for an ETL Developer to join the Altrad team nationwide.

In this role, you will be responsible for supporting the development of ETL Solutions, developing and maintaining data interfacing to a central data warehouse for load into a PowerBi reporting environment and the interfacing of master data between information systems. Altrad has a mature reporting environment that is aligned with the Microsoft application stack and works using the Agile Scrum Development methodology. 

Roles and Responsibilities
  • Integration activity (ETL) using Azure Data Factory. Connecting multiple data sources to our Datawarehouse and integration into the Altrad reporting data model
  • Developing master data interfaces between information systems using an array of interfacing methods 
  • Transformation of multiple data sources/systems into curated dataset for use in reporting and master data management 
  • Help lead the development Altrad BI Solution Architecture, DATA Replication Wearhouse and secure data sets using the Microsoft application stack.
  • Create and evolve of secure data sets for all systems that you make available to Key users in the production of their reports.  
  • Undertake ETL integrations and support tasks using ADF
  • Coach and mentor junior BI professionals
  • Assessment of new systems and solutions to indentidy optimal integration method
  • Liaise with software vendors in the provision on bi directional interfacing for master data and the extraction of data for reporting purposes.
  • Resolve data integrity, quality and robustness challenges with legacy / system data to encourage quality and transformation reporting
  • Develop and update process maps, ETL Topology diagrams and maintain good documentation on the configuration of ETL processes. 

General Duties & Responsibilities 

  • Drive Excellence though effective and efficient use of systems. 
  • Understand and document business requirements over the short, medium and longer term. 
  • Consult through lesson learned sessions with End Users, Key users and Process Owners to ensure that functionality and configuration meets evolving business requirements
  • To develop and maintain consistent solutions across our approved application suite. 
  • Maintain confidentiality with sensitive data/information
  • Build and maintain workflows and process automation
  • Support other Business Systems Analysts and leads in digital transformation projects. 
Experience Required
  • Experience as a business intelligence analyst/ developer or related role 
  • Experience with SQL Management Server, SSRS, SSIS and other related systems
  • Experience with Microsoft Azure stack and related technology such as ADF, Logic Apps, Data Lake,  Data Bricks, Power Query etc
  • Experience in Low code MS related technologies, SharePoint, Nintex, Power Apps, Power Bi etc
  • ETL Related experience using SSIS, ADF or similar products to undertake complex integrations. 
  • Experience in the role of a DBA or DBA related activities 
  • Relevant further qualification in business analytics related field
  • Strong technical acumen and the ability to analyse complex situations and effectively solve problems and drive an excellence culture. 
  • Understanding of GDPR and good practice of complex data management
  • Strong communication skills and able to effectively work with varying stakeholders
  • Pragmatic approach, able to balance the ideal with the reality of what is needed today.
  • Demonstrable ability to thrive in a complex, rapidly changing and demanding Globally integrated (but not centralised) business environment
  • Experience / knowledge of the Agile Scrum development methodology
  • Experience of Dynamics Navision, iTrent, SharePoint Online Office 365 is desired but not essential.
  • Experience working in an Engineering / Construction / Maintenance industry would be beneficial but not essential. 
Closing Date
Employment Type:
Client Ref:
Cargo Fleet
TS23 4BX