Data Analyst

Parvana; Johannesburg; On-site; ZAR 300 000 - 600 000; Full time

Job summary

An established industry player is seeking a talented Data Warehouse Developer to join their dynamic team. In this role, you will design and enhance database structures, develop ETL processes, and collaborate with clients to deliver tailored data solutions. Your expertise in data warehousing and business intelligence will be crucial in supporting clients in sectors like Insurance and Lending. This innovative firm values continuous learning and teamwork, offering a supportive environment where your contributions will make a significant impact. If you are passionate about data and eager to grow in your career, this opportunity is perfect for you.

Qualifications

• A relevant tertiary degree in Computer Science, IT, or related fields is ideal.
• Strong interest in analytical modelling and data analytics tools.

Responsibilities

• Design and modify database structures and data flows within the data warehouse.
• Develop ETL processes to load data from various sources.

Skills

Analytical Skills

Dimensional Modelling

Data Analytics

Troubleshooting Skills

Software Development Life Cycle Knowledge

Education

Tertiary Degree in Computer Science

Tertiary Degree in IT

Tertiary Degree in Data Science

Tertiary Degree in Information Systems

Tools

SQL

PostgreSQL

SQL Server DBMS

T-SQL

Python

Yellowfin

Job description

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 :

• 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.
• Thorough understanding of data warehouse architecture, data structures, and fundamental design principles.
• Ability to work independently with general supervision, which may include providing guidance and support to entry-level professionals or support staff.
• Contribute to the development of data warehouses for clients in the Insurance, Lending, and Employee Benefits sectors.
• 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.

Job ID : J106876

For a more comprehensive list of opportunities that we have on offer, do visit our website.