Senior BI Developer at Hollard Insurance

Job Advert Summary    
Hello…an exciting new opportunity has just become available in our Hollard Life Solutions, IT area. We are looking to recruit a Senior BI Developer.

• The Senior Data Engineering will report into the Hollard Life Solutions Business Unit area and will provide BI development across all the Business Unit within Hollard.
• The Senior BI Developer 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.
• 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    

•  Tertiary qualifications with majors in at least one of the following: Computer Science, Information Systems
•  +5 years’ experience working on Microsoft BI platform
•  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    

• Technical Analysis and Design
• Analyse business requirements and translate them into technical and system requirements to best satisfy these requirements
• Write and maintain technical documentation
• Develop end to end BI solutions
• Adhere BI SDLC and development methodologies
• Unit Testing
• Unit test their own development
• Willingness to take ownership and accountability
• Building and maintain relationships
• Have a collaborative mindset
• Have a strategic mindset when designing solutions that enable standardization and efficiency
• Contribute to the success of the team; co-operate with other employees to improve personal and team performance
• Competencies & Attributes
• Team player & ability to work closely with others
• Be able to function independently should that be required
• Problem solver / solution provider
• Passionate about BI and data integration
• Committed, self-driven & highly motivated individual
• Adaptable; be able to handle change effectively
• Good communication skills
• Able to work by themselves and in a team
• Experience working in an agile manner
• Innovate with new technology techniques
• Ability and willingness to work standby and / or weekends (if required)