Data Analyst – (Banking /Financial Services)

Sapientis Talent Management Pty. Ltd.; Johannesburg; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading talent management firm in Johannesburg is seeking experienced Data professionals to design and implement ETL processes from core banking systems. The role involves collaborating with stakeholders, documenting data flows, and providing quality MIS support. Candidates should have a degree in Information Technology and at least 4 years of relevant experience, particularly with SQL and large databases. This long-term contract offers a dynamic environment with significant growth potential.

Qualifications

• 4+ years of experience in database programming and design.
• Experience in SQL performance tuning for large databases.
• Hands-on experience in developing relational data models.

Responsibilities

• Deliver relevant information for business growth.
• Collaborate with stakeholders to gather requirements.
• Document and maintain ETL mapping files and validations.
• Provide MIS support and automate regular reports.
• Support users through their UAT processes.

Skills

SQL programming

Data modeling

Data mining

Report creation

UAT support

Education

Degree in Information Technology / Systems, Quantitative Analysis or similar

Job description

We are on the lookout for experienced Data professionals with demonstrable skills of mapping and designing ETL’s from Core Banking and or Policy Admin Systems to GL. Technical integration experience will be strong advantage as well as testing experience (developing test cases, doing testing). Must also have MIS and report building experience.

You will undertake roles and responsibilities in the following areas:

• Delivering relevant and insightful information to the Business, whilst helping the organisation grow around Business Intelligence.
• Collaborating with business stakeholders to determine business needs and relevant delivery of requirements.
• Documenting and maintaining ETL mapping files, validations and transform rules.
• Mapping data flows and requirements into Features, User stories, Sprint tasks
• Documenting requirements including data modelling, interface layouts, data flows, screen and report layouts, etc.
• Ensuring that solutions present timely, consistent, accurate, complete and valid data.
• Guiding and advising the Business on the most appropriate solution(s) to meet their needs and develop complete and accurate models.
• Providing quality information analysis to support key business decisions and reporting needs.
• Providing MIS support to satisfy existing reporting requirements and design new reporting structures where required. This includes the automation of regular reports.
• Analysing and makes recommendations on data to inform and develop business strategy.
• Data mining, data modelling, report creation and automation, end user education and training.
• Supporting users through their UAT processes, including testing and documentation of the solution developed.

Educational and proficiency level:

• Degree in Information Technology / Systems, Quantitative Analysis or similar
• 4+ years of experience in data base programming, data modeling and design and development of large database
• Strong SQL programming skills
• Experience in database/SQL performance tuning of large – multi-terabytes database
• Hands-on experience creating and maintaining conceptual, logical and physical data models,
• Hands-on experience developing fully normalized relational data models
• Experience in application/database documentation development, Database documentation: design/implementation recommendations, updated design specifications/database diagrams, data dictionaries, generate PDM DDLs, updated coding standards, performance tuning parameters or related

Location: Johannesburg, Gauteng

Duration: Long term contract

Should you be interested in this role or know of super candidate that might be, please send us a detailed CV (in MS Word format) via email to [e-mail] (DTA_Q_G)

[fusion_button link="https://sapientis.africa/job-application/" text_transform="" title="" target="_self" link_attributes="" alignment_medium="" alignment_small="" alignment="" modal="" hide_on_mobile="small-visibility,medium-visibility,large-visibility" sticky_display="normal,sticky" class="" id="" color="default" button_gradient_top_color="" button_gradient_bottom_color="" button_gradient_top_color_hover="" button_gradient_bottom_color_hover="" accent_color="" accent_hover_color="" type="" bevel_color="" border_width="" border_radius="" border_color="" border_hover_color="" size="" stretch="default" margin_top="" margin_right="" margin_bottom="" margin_left="" icon="" icon_position="left" icon_divider="no" animation_type="" animation_direction="left" animation_speed="0.3" animation_offset=""]Apply here[/fusion_button]