SQL Developer

Parvana; Johannesburg; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A financial services provider in Johannesburg is seeking a skilled Data Warehouse Developer to design and enhance data structures and ETL processes. Candidates should have a relevant degree, SQL proficiency, and expertise in data warehousing. Responsibilities include developing comprehensive data solutions for various sectors, particularly in Insurance and Employee Benefits. This role encourages independent work with opportunities to mentor junior staff.

Qualifications

• Relevant tertiary degree preferred in IT or Data Science.
• Strong interest in analytical modeling and data analytics tools.
• In-depth knowledge of data warehousing and ETL.
• Experience in relational databases and SQL.

Responsibilities

• Design and modify database structures and data flows.
• Develop ETL processes to load data into the warehouse.
• Consult clients to gather needs and requirements.
• Contribute to the development of data warehouses.

Skills

Data warehouse architecture

Analytical modeling

SQL

ETL processes

Data analytics tools

Education

Tertiary degree in Computer Science or related fields

Tools

PostgreSQL

Yellowfin

SQL Server DBMS

Python

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 600 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. Possess a thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
11. Work independently with general supervision, which may include providing guidance and support 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 would be ideal (Computer Science, IT, Data Science, Information Systems, etc.)
• Strong interest in analytical / dimensional modelling, and data analytics tools. Insurance knowledge is a plus.
• In-depth knowledge of business intelligence tools including data warehousing, and ETL (Extraction, Transformation, and Load). Yellowfin knowledge is beneficial.
• Knowledge and understanding of the software development life cycle.
• Knowledge and experience in 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 and tasks.
• Ability to present and explain complex technical topics, problems, and alternative solutions to others.
• Experience estimating solution development and delivering solutions within those estimations.
• Knowledge of Insurance Systems.
• Experience with or knowledge of most of the following software, languages and tools, or similar products would be preferred: SQL Server DBMS, T-SQL (ANSI), PostgreSQL, Python.