Data Engineer

SUMMARY:
-

POSITION INFO:

PBT Group has an opportunity for a BI Developer to improve profitability by supporting the IT Strategy through the automation of data acquisition and provisioning, the development of Analytics and Business Information, to support the Business in their decision making.

Â

Duties:

• Develop and maintain a data warehouse environment, conduct root cause analysis and resolve production problems and data issues. Develop data extracts and data selections as required to establish the report datasets
• Develop and maintain data sets, ETL processes and reports related in order to support operations and decision making related to commercial and personal insurance, provide direct support to end-users.
• Collaborate with business users and application developers to provide required data. Estimate the time and resource requirements of ETL development work. Validate data and test routines developed & provision of ongoing maintenance and support of assigned ETL applications
• Analyse the systems environment to understand how the business systems enable these business processes and how the related data is captured and stored. Analyse the structures in which the data is stored to understand what data can be extracted and how it would be done in an efficient manner.
• Analyse the existing reporting environment to understand what reporting is available and how this can be utilized or amended to inform the specific Business decisions involved.
• Test all developments for data accuracy, performance and system impact & engage relevant Business users, train them on report usage and guide them in doing user testing.
• Schedule data extracts and report runs as required to deliver the required information to users at the necessary frequency. Ensure that scheduled procedures are handed over for monitoring and support by the appropriate resources. Update report specifications to reflect the as-built situation.
• Update technical documentation on data extracts and report functionality to facilitate future understanding to the extent required for ongoing support. Respond to user queries, error logging and further enhancement requests to ensure reports are used and serve their intended purpose

Â

Experience:

• 5+ years’ experience of delivering Business Intelligence projects using Microsoft & Informatica tools, Visualization Tools (QlikView, SSRS, Power BI). Insurance background and knowledge preferred.
• Ability to produce solutions using:
• Microsoft SQL Integration Services, MS SQL Analysis Services, MS SQL Reporting Services, MS PowerBI, QlikView, Informatica (Power-center & PWX CDC)
• Knowledge of & Scaled Agile Framework (SAFe) practices will be advantageous
• Knowledge of Cloud services (Azure & AWS) will be advantageous

Â

Â

Qualifications/ Certification:

• Matric,
• Bsc Computer Science / Informatics,
• Microsoft Business Intelligence certification – advantageous

NB! This job is now closed. You can apply for other jobs by uploading your CV.