Data Warehouse Engineer Jobs in Johannesburg

A vacancy exists for a Data Warehouse Developer at our client’s office in Johannesburg. Our client is a leading provider of financial service solutions, dedicated to helping their clients achieve their goals. With a strong emphasis on culture fit, they pride themselves on a collaborative team environment, continuous learning opportunities, and a culture built on trust, respect, and togetherness. They utilize Agile methodologies to deliver innovative and research-driven financial services.

What You Will Be Doing

• Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.
• Analyze, create, and modify data structures to adapt to business needs and enhance functionality.
• Develop and modify ETL processes to load data from various sources into the data warehouse.
• Use programming languages and best practices to develop new data warehouse structures and reports, as well as modify existing ones.
• Unit test and debug code.
• Participate in requirements gathering, analysis, technical design, testing, documentation, and project planning.
• Consult with clients to gather information about their needs, objectives, and requirements.
• Identify and propose technical solutions to client requests and system problems.
• Follow department standards and create written documentation and diagrams as required.
• Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
• Provide expertise in Data Warehouse and Reporting Applications, including software development, production support, and troubleshooting.

What Our Client is Looking For

• A relevant tertiary degree (e.g., Computer Science, IT, Data Science, Information Systems) is preferred.
• Strong interest in analytical/dimensional modeling and data analytics tools. Insurance industry knowledge is a plus.
• In-depth knowledge of business intelligence tools, including data warehousing and ETL. Familiarity with Yellowfin is beneficial.
• Understanding of the software development life cycle.
• Experience with relational databases, SQL, and PostgreSQL.
• Database design and modeling skills for data warehouse and business intelligence applications, including relational database structures and normal forms.
• Analytical and troubleshooting skills for complex technical issues.
• Ability to present and explain complex technical topics, problems, and solutions to others.
• Experience estimating solution development and delivering solutions within those timelines.
• Knowledge of Insurance Systems.
• Experience with or knowledge of the following tools, languages, or software: SQL Server DBMS, T-SQL (ANSI), PostgreSQL, and Python.

Desired Skills

• ETL
• SQL
• Database Structures