Junior Data Engineer - Parktown at Hollard Insurance

Job Advert Summary

• The Junior Data Engineer will report to the Hollard Life Solutions Business Unit area and provide Data Engineering support across all the Business Units within Hollard.

Key Responsibilities:

• To ensure effective movement, collection, integration, storage, and provisioning of data to meet business objectives through a sound understanding of business unit requirements.
• The Business Intelligence Developer will be responsible for transforming data into meaningful information using the Microsoft SQL stack and cloud technologies.
• This will be a collaborative role that will be responsible for delivering everything in the Data Engineering space from the 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 senior developers/architects.
• Complete documentation of Data Engineering requirements and development according to Hollard standards.
• Provide support to the business on existing projects
• Assist business users in acquiring access to reports/databases
• Responsible for designing and implementing effective cross-functional business intelligence systems and processes.
• Translate business and technical requirements into efficient sustainable Data Engineering solutions.
• This will be a dynamic role where you will be an integral member of a small team building end-to-end Data Engineering solutions.
• This person should be very analytical with an even mix of business acumen and technical capability.
• The BI Developer 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.

Required Knowledge and Experience

• +2 years’ experience working on Microsoft BI platform.
• SQL Server highly recommended.
• Experience with relational databases i.e. Oracle; Sybase and SQL Server.
• Exposure to/experience designing and implementing dimensional modelling and Data warehouses.
• Exposure to cloud technologies preferably Azure.
• SQL Server Jobs, Stored Procs, Views, Functions, Indexes, etc.
• Experience in insurance services is an advantage, but not a necessity.

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.

Technical Analysis and Design

• Analyze business requirements and translate them into technical and system requirements to best satisfy these requirements
• Sourcing and analyzing data, developing data products, and delivering insights that drive strategic decisions
• Ensure the integrity and availability of data
• Write and maintain technical documentation
• Develop end to end Data Engineering solutions
• Adhere to project release procedures

Educational Requirements

• Tertiary qualifications with majors in at least one of the following: Computer Science, Information Systems or related fields.