Data Warehouse Engineer With Bachelor'S Degree

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

Data Warehouse Engineer with Bachelor's Degree - Life Insurance Systems
Gauteng| Permanent position |To work remotely

Must have a Matric
Must have a Bachelor's Degree in Computer Science, OR Information Technology, Data Science, Information Systems, or a closely relevant discipline

Must have 3-5+ years of Data Warehouse Design working experience with experience or knowledge of most of the following software, languages and tools: SQL Server DBMS, TSQL (ANSI), PostgreSQL, Python (or similar products)

Knowledge of Life Insurance / or Funeral or Risk Insurance Systems -

Must have an in-depth knowledge of business intelligence tools like data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge would be advantageous.

Advanced knowledge and experience in relational databases, SQL, PostgreSQL and SDLC.

Experience in database design and modelling for data warehouse and business intelligence applications, including relational database structures and normal forms.

Must have experience performing software development, production support and provide overall expertise in the area of Data Warehouse and Reporting Applications.

Must have a strong interest in analytical and dimensional modelling and data analytics tools is essential for this role (insurance knowledge in this area advantageous).
Analytical and troubleshooting skills with complex technical subjects and tasks.
Ability to present and explain complex technical topics, problems, alternative solutions to others.

Experience estimating solution development and delivering solutions against those estimates.
Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the data warehouse as needed
Understand thoroughly the architecture, data structures and fundamental design principles of the data warehouse.
Analyse, create and modify the data structures within the data warehouse to adapt them to the external Companies business needs and add enhanced functionality

Develop and modify the data load ETL processes as needed to Extract, Transform and Load data from various data sources into the data warehouse.
Use programming languages, software development methods, "best practice" programming techniques and department standards guides to develop new data warehouse structures and reports and to modify existing ones

Unit test and debug code prior to delivery to client.
Participate in requirements gathering and analysis, technical design, testing, documentation and project planning:

Consult with clients to gather information about needs, objectives, functions, performance expectations and input and output requirements.

Identify and propose technical alternatives to solving client requests and system problems and recommend the best alternative.

Follow department standards and create written documentation and diagrams as required and/or requested.

Documentation may include technical specifications, technical alternatives, structure charts, data flow diagrams, etc. for both new functionality and for modifications to existing functionality.
Team Player and ability to grow and guide others essential.

May also provide guidance and assistance to entry level professionals and/or support employees.

Salary: up to 50 000 CTC per Month maximum - not negotiable

Please Note: A Pension Fund of between 4% - 11% of your Monthly Salary will be deducted from your Monthly Salary, which is mandatory for all employees, the full amount would be also deducted from your Monthly Salary - this is not negotiable.
NB: (the Company does not contribute to the Pension Fund at all)