Data Engineer

Job Description

Job Description:

The applicant will be part of a dynamic team that will be responsible for a variety of Big Data solutions including Data Sourcing and Integration, Data Modelling and Datamarts on Attunity, Azure and Azure platforms.

Key Responsibilities:             

• Design and Implement Dataflows and Datamarts on an Azure platform.
• Troubleshooting issues with existing Dataflows and Datamarts on the Azure platform.
• Designing, Creating and Maintaining Data Integration Tasks on an Attunity Replicate Server.
• Automation of Tasks on Azure platform and Attunity Replicate Server.
• Maintaining Powershell Automation scripts on Attunity Replicate Server.
• Troubleshooting and Supporting Business Users working with existing solutions.
• Champion change on behalf of the BI & Data Solutions team and for the IT Solutions team in general.
• Specify components of solutions to support the delivery of user requirements right first time.
• Ensure the Applications are designed to be effectively managed.
• Liaise with third-party or in-house service providers to monitor progress and highlight any issues for action.
• Plan and manage systems test to ensure that solutions work correctly and meet the specification.
• Identify and drive improvements to the current processes and new development work.
• Investigate and resolve user problems channeled via Helpdesk or equivalent to minimize disruption to Business activity. 
• Responsible for creating and maintaining documentation - Document changes to systems and produce documentation for new solutions.
• Maintain functional peer relationships and participate in continuous process improvement activities and support quality initiatives.

Technical/ Functional Knowledge, Skills and Abilities 

Required:

• Advanced Azure Platform Knowledge
• Strong Data Integration, ETL and Data Modelling – highly skilled
• Strong SQL experience
• Oracle database knowledge
• A proven track record of developing Big Data solutions
• Experience of working in Insurance or the Financial industry
• Strong experience in solution design including the analysis of business requirements and implementation of change.
• Proven ability to work in an Agile development environment.
• PowerBI Development and Architecture
• Spotfire knowledge

Desired:

• Attunity Replicate
• Powershell Scripting
• Apache Spark & Scala 
• Azure Analysis Services 
• Azure DevOps 
• Oracle PL/SQL
• Knowledge of BI Analytic and Dashboarding tools such as Qlikview
• Knowledge of Creditor Insurance
• Knowledge of Oracle Tools

Experience Required:

• BSc in Computer Science, Data Analytics or Equivalent
• Design, implement and support full end to end BI and Data solutions working closely with stakeholders within IT and in the business functions.