Data Warehouse Engineer

Parvana; Johannesburg; On-site; ZAR 500,000 - 900,000; Full time

Job summary

A leading company in financial services is looking for a skilled database developer to enhance their data warehouse capabilities. The ideal candidate will have a relevant degree and a strong background in ETL processes and analytical modeling. You will design and implement data solutions that help drive business success, while working closely with clients to meet their technical needs. This role offers an opportunity for significant personal and professional growth within a collaborative environment.

Qualifications

• Experience with relational databases and database design.
• Knowledge of business intelligence tools and ETL processes.
• Understanding of software development life cycle.

Responsibilities

• Design, develop, and modify database structures and ETL processes.
• Consult with clients to determine their technical needs.
• Maintain documentation and ensure standards are followed.

Skills

Analytical modelling

Data analytics

Troubleshooting

Communication

Education

Tertiary degree in Computer Science, IT, Data Science, Information Systems

Tools

SQL

PostgreSQL

T-SQL

Python

Yellowfin

Job description

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

1. Design, develop, and modify database structures, relationships, data flows, and data interfaces within the data warehouse.
2. Analyse, create, and modify data structures to adapt to business needs and add enhanced functionality.
3. Develop and modify ETL processes to load data from various sources into the data warehouse.
4. Use programming languages, software development methods, and best practices to develop new data warehouse structures and reports and modify existing ones.
5. Unit test and debug code.
6. Participate in requirements gathering, analysis, technical design, testing, documentation, and project planning.
7. Consult with clients to gather information about needs, objectives, and requirements.
8. Identify and propose technical solutions to client requests and system problems.
9. Follow department standards and create written documentation and diagrams as required.
10. Maintain a thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
11. Work independently with general supervision, potentially providing guidance to entry-level professionals or support staff.
12. Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
13. 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, PostgreSQL.
• 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 ID: J

For more opportunities, visit our website.