Data Analyst

Andela; Johannesburg; On-site; ZAR 400,000 - 600,000; Full time

Job summary

A leading technology organization in Johannesburg is seeking a candidate for a role focused on data extraction and analysis within the financial sector. The ideal candidate should have strong SQL skills, experience with large datasets, and a Bachelor's degree in a relevant field. The position involves working with teams to ensure accurate data reporting and compliance with company standards. This is a 12-month onsite contract.

Qualifications

• Previous experience in the financial or payment industry.
• Experience with large datasets and SQL-based data extraction.
• Strong analytical and problem-solving skills.

Responsibilities

• Review and analyze system scripts for data extraction.
• Collaborate with IT and operations teams to optimize automation.
• Validate data integrity through reconciliations.

Skills

SQL

Python

Shell scripting

Data analysis

Communication skills

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field

Tools

Oracle

Microsoft SQL Server

Job description

Overview

Andela exists to connect brilliance and opportunity. Since 2014, we have been dedicated to breaking down global barriers and accelerating the future of work for both technologists and organizations around the world. For technologists, Andela offers competitive long-term career opportunities with leading organizations, access to a global community of professionals, and educational opportunities with leading technology providers. At Andela, we’re deeply passionate about creating long-lasting and transformative growth opportunities for all—and doing it in an E.P.I.C. way! We’re excited to continue building our remote-first team with incredible people like you. After applying for this role, you will join our Andela Community of brilliant technologists by passing a technical screening and live interview. As a community member, you’ll have access to a multitude of exclusive technologist roles. Join Andela today to access this opportunity and more in our global marketplace! Our roles are typically filled at lightning speed, so if you’re considering applying, get your application in quickly!

Tasks: Core Responsibilities and Accountabilities

• Review and analyze system scripts for data extraction from internal systems.
• Ensure scripts and queries correctly pull required customer data.
• Work with IT and operations teams to optimize and automate data extraction.
• Prepare and structure data to meet required formats and reporting standards.
• Validate data integrity through reconciliations and quality checks.
• Develop new or enhance existing system scripts, SQL queries, and automation processes.
• Troubleshoot and resolve issues related to scripts.
• Document data extraction procedures and ensure scripts are version controlled.
• Ensure data submissions comply with company reporting guidelines.
• Monitor and address discrepancies or errors in data submissions.
• Collaborate with reporting teams for timely and accurate data submissions.
• Analyze trends and patterns in extracted data.
• Generate internal reports for customer segment insights.
• Assist in compiling feedback for senior management on performance and compliance.
• Work with payment operations, compliance, IT, and finance teams to ensure alignment on data reporting.
• Coordinate with vendors to integrate or adjust data feeds.
• Stay updated on evolving company reporting standards.
• Identify opportunities for process improvements and enhanced reporting accuracy.

Knowledge and Experience

• Previous experience in the financial or payment industry.
• Experience with large datasets and SQL-based data extraction.
• Proficiency in SQL, scripting languages (e.g., Python, Shell), and data querying techniques.
• Familiarity with payment systems, card processing, and clearing/settlement processes
• Experience with financial reporting systems and databases such as Oracle, Microsoft SQL Server, or similar platforms.
• Strong analytical and problem-solving skills with a keen eye for detail.
• Ability to translate complex system and transaction data into clear, actionable reports.
• Strong verbal and written communication skills for interacting with technical and non-technical stakeholders.
• Ability to present data findings to management and recommend corrective actions.
• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.

Contract length: 12 months

Working Location: Onsite (Johannesburg)

Andela reserves the right to evaluate all qualified applicants and to hire qualified applicants at any time. Andela is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.