Remote Data Warehouse Engineer — Insurance BI & ETL Expert

Diverse Consulting Solutions; Johannesburg; Remote; ZAR 508,000 - 608,000; Full time

Job summary

Diverse Consulting Solutions is seeking a Data Warehouse Engineer with 3-5+ years of design experience to work on life insurance systems. The role involves data warehousing, ETL development and BI reporting using SQL Server, T-SQL, PostgreSQL and Python, with responsibilities spanning requirements gathering, design, testing and production support.

The position offers remote work in South Africa, with a fixed monthly salary up to 50,000 ZAR and mandatory pension deductions.

Qualifications

• Bachelor's degree in CS, IT, Data Science, IS, or a closely related discipline.
• 3-5+ years of Data Warehouse design experience.
• Experience with SQL Server, T-SQL, PostgreSQL, Python.
• Knowledge of Life Insurance systems.
• Strong knowledge of BI, data warehousing and ETL; Yellowfin advantageous.
• Advanced knowledge in relational databases, SQL, PostgreSQL and SDLC.
• Experience in database design for data warehouse and BI applications.
• Experience in software development, production support and data warehouse/reporting applications.
• Interest in analytical and dimensional modelling and data analytics; insurance knowledge advantageous.
• Analytical and troubleshooting skills; able to present complex topics.
• Experience estimating solution development and delivery.
• Design/modify data warehouse structures and data flows.
• Develop/modify ETL processes.
• Unit test and debug code; participate in requirements gathering.

Responsibilities

• Design, develop and modify data warehouse structures, data flows and interfaces.
• Load and transform data from multiple sources via ETL processes.
• Collaborate with clients to understand needs and propose technical solutions.
• Perform unit testing, debugging and documentation for data warehouse projects.
• Assist in requirements gathering, design, testing and project planning.

Skills

SQL

T-SQL

PostgreSQL

Python

BI tools

ETL

Data warehousing

SDLC

Analytical modelling

Education

Bachelor's Degree in CS/IT/IS

Tools

SQL Server

Job description

Diverse Consulting Solutions is seeking a Data Warehouse Engineer with 3-5+ years of design experience to work on life insurance systems. The role involves data warehousing, ETL development and BI reporting using SQL Server, T-SQL, PostgreSQL and Python, with responsibilities spanning requirements gathering, design, testing and production support.

The position offers remote work in South Africa, with a fixed monthly salary up to 50,000 ZAR and mandatory pension deductions.