Senior Data Engineer at Hollard Insurance

The Data Engineer will be responsible for transforming data into actionable insight using the Microsoft SQL 2016 stack of Business Intelligence products, primarily in support of the Hollard Life Solutions BU.

This will be a collaborative role that will be responsible for delivering the full stack in the BI solution from the business requirements gathering, solutions architecture, data models to the semantic models and the reports themselves.

Requirements

• Should be able to design and develop end to end BI Solutions.
• Be able to do gap and impact analysis on the requirement.
• Accept coaching and mentoring from fellow developers/architects.
• Complete documentation of BI requirements and development according to Hollard standards.
• Provide support to business on existing projects
• Assist business users in acquiring access to reports/databases
• Responsible for the design and implementation of effective cross-functional business intelligence systems and processes.
• Translate business and technical requirements into efficient sustainable BI solutions.
• This will be a dynamic role where you will be an integral member of a small team building an end-to-end business intelligence solution.
• This person should be very analytical with an even mix of business acumen and technical capability.
• The Data Engineer will be responsible for working with analysts, managers, and executives to understand business needs and working with source owners and BI teams to understand the data sources.
• Participate in analysis and design sessions  
• Communicate progress with business users and project teams.
• Elicit requirements for ad-hoc data requests, extract data from the various sources using SQL, and deliver request via various reporting tools.
• Update and maintain ETL scripts written in SQL, which extract data from source systems and load the data warehouse.
• Redesign and improvement of existing solutions

Required Knowledge and Experience    

• Familiar with Agile / Waterfall development methodology
• Exposure to Visual Studio TFS and C#/VB.Net coding
• SQL Server 2016+ highly recommended
• Windows Server 2012+ administration exposure
• BIML scripting
• Experience with relational databases i.e.  Oracle; Sybase and SQL Server
• Exposure to database administration function
• Exposure / Experience designing and implementing dimensional modelling and data warehouses.
• Good database design skills (required)
• SSRS, SSAS 2016 +(Multi-dimensional and Tabular)
• Extensive skills on SSIS
• Experience in using and writing complex MDX and DAX statements
• MS PowerBI stack highly recommended (Power Pivot, Power View and Power Query experience)
• QlikView a plus
• MDS “Master Data Service” development, maintenance and deployment
• SQL Server Jobs, Stored Procs, Views, Functions, Indexes, Table Value Functions, etc.
• SQL performance tuning and enhancements
• Experience in insurance services an advantage, but not a necessity
• Knowledge to produce fully automated solutions with minimal human intervention required

Educational Requirements    

• Tertiary qualifications with majors in at least one of the following: Computer Science, Information Systems
• 5 years’ experience working on Microsoft BI platform

Closing Date: 13th, May 2022