Closing Date 2024/05/07
Reference Number HOL240430-1
Job Title Data Engineer
Business Unit Hollard Group Risk
Department HGR IT
Job Family IT
Job Type Classification Fixed Period Contractor
Reporting To Head IT Operations
Number of Positions 1
Location - Town / City Johannesburg
Location - Province Gauteng
Location - Country South Africa
Job Advert Summary
An exciting new opportunity has become available within Hollard Group Risk. We are looking to recruit a Data Engineer in our IT Operations Space.
The Data Engineering will report into the Hollard Group Risk (HGR) Business Unit area and will provide BI Development and Data Analysis across all departments within HGR.
The Data Engineering will report into the Hollard Group Risk (HGR) Business Unit area and will provide BI Development and Data Analysis across all departments within HGR.
- The Data Engineer will be responsible for transforming data into actionable insight using the Microsoft SQL tech stack of Business Intelligence products, primarily in support of the Hollard Group Risk 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
- Experience with relational databases
- Exposure to database administration function
- Exposure / Experience designing and implementing dimensional modelling and data warehouses.
- Good database design skills (required)
- Extensive skills on ETL packages
- Experience in using and writing complex MDX and DAX statements.
- MS PowerBI stack highly recommended (Power Pivot, Power View and Power Query experience)
- 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
- 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
- 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
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.
- Familiar with Agile / Waterfall development methodology
- Exposure to Visual Studio and C#/VB.Net coding
- SQL Server 2016+ highly recommended