Overview
Data Warehouse Engineer Jobs in Johannesburg, South Africa at Parvana
Job Description
About our client
Our client offers financial service solutions helping their clients achieve their dreams.
With an emphasis on culture fit, they boast a dedicated team of over employees, many with over a decade of tenure.
They have built their culture on a feeling of togetherness, trust, and respect and are always looking to support employees’ continuous learning.
Using Agile, they provide diverse services with a focus on research, innovation, and improvement.
What you will be doing
Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.
Analyse, create, and modify data structures to adapt to business needs and add enhanced functionality.
Develop and modify ETL processes to load data from various sources into the data warehouse.
Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and 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 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.
Maintain a thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
Work independently with general supervision, potentially providing guidance to entry-level professionals or support staff.
Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
Be responsible for software development, production support, and providing expertise in Data Warehouse and Reporting Applications.
What our client is looking for
A relevant tertiary degree (Computer Science, IT, Data Science, Information Systems, etc.) is preferred.
Strong interest in analytical/dimensional modelling and data analytics tools.
Knowledge of insurance systems is a plus.
In-depth knowledge of business intelligence tools, including data warehousing and ETL processes.
Yellowfin knowledge is beneficial.
Understanding of the software development life cycle.
Experience with relational databases, SQL, Postgre
SQL.
Experience in database design and modelling 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 clearly.
Experience estimating solution development and delivering solutions within those estimations.
Knowledge of insurance systems.
Experience with or knowledge of SQL Server DBMS, T-SQL, Python, and related tools.
Job : J
For more opportunities, visit our website.
#J-18808-Ljbffr
Title: Data Warehouse Engineer
Company: Parvana
Location: Johannesburg, South Africa
Category: IT/Tech (Data Engineer, Data Analyst, Data Warehousing, Database Administrator)
