ETL Engineer-IT- Naas

The Arachas ETL Data Engineer will be the person with primary responsibility for designing and driving the data integration of data, Data Warehouse design and delivery of BI Solutions.

Working as key member of the Arachas IT Team, The ETL Data Engineer will work with a variety of data sources to feed the new Arachas Data Warehouse and help drive the development and use of data driven insight.

ETL & Data Feed Management:

• Design and integration of new data feeds and migration of new data sets as they are identified or are acquired as the Arachas business grows.
• Determine optimal solutions for integrating data from a variety of sources into a common data warehouse normalised structure, within an ETL Framework
• Ongoing DWH modelling in a normalised star schema structure, along with de-normalised reporting data marts
• Implement, maintain and monitor batch & stream data pipelines with best practice quality controls
• Performance optimisation of data processing e.g. parallel processing, RAM and CPU usage as well as storage and growth monitoring and ongoing engagement with DBA’s
• Work closely and collaboratively in an Agile environment with the broader Data Team to analyse issues and find new insights that help drive business performance.
• Ongoing unit testing, system integration testing and data reconciliations. Coordination & support for UAT
• Automate the application of master data management transformations
• Day to day operational support of data infrastructure, and services
• Definition & Implementation of data security and compliance policies and regulations e.g. GDPR

Data Quality & Data Usage:

• Help define, implement and lead on robust data management data quality processes across the company
• Support the creation and maintenance of documentation deliverables including, but not limited to architecture diagrams, data flow diagrams, metadata, data dictionary, entity-relationship diagrams, data mapping documents, and other data design artifacts that define technical data specifications and transformation rules.

• Design and build best in class processes to clean and standardise data
• Support KPI definition process and hold custody of historic knowledge of data and meaning
• Identify and help standardise the use and governance of data.

Requirements:

• Bachelor's degree in computer science/information systems
• Min 5 years Development experience in ETL, SQL Programming, large scale systems data integration and Data Warehousing environments
  
• Deep knowledge of SQL, database model design (Fact & Dim tables) and all other data warehousing concepts
  
• Proven experience with SSIS and Azure Data Factory essential
• Experience in data management frameworks; Data Quality Profiling, Metadata Management, Master Data Management, cleansing/standardising, analysing
• Expert familiarity with market leading data integration technologies.
• Strong command of relevant programming/scripting languages: e.g. Java, Scala, Python, R
• Strong understanding of Business Intelligence strategies/design as it relates to Data analysis.
• Financial services and ideally General Insurance experience strongly desired.
• Good project management skills; experience managing projects / requests with multiple senior stakeholders
  
• Ability to understand and interpret business needs and how they translate to technical and functional requirements

Person Specification:

• Experienced and independent subject matter expert, capable of working on own initiative whilst delivering best practice solutions that deliver the strategic objectives of the programme.
• Possesses a can-do attitude and can get things done, rapidly building an understanding of the Arachas organisation and technical environment.
• Strong relationship builder and capable of credibly managing internal and external executive stakeholders.
• Ability to understand new business systems and data architectures that Arachas acquire. This will involve working with key business stake holders.