ETL Developer

• 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.