System Analyst

1. Term: 6 months
2. Job location:Lagos, Nigeria
3. Experience requirement:5 - 7 years
4. Project scope:System Analyst with deep understanding of payment processing, data extraction techniques, and QMR/GCO reporting requirements as defined by Mastercard

Role:

The Systems Analyst will be responsible for reviewing, maintaining, and enhancing system scripts and processes to extract, validate, and prepare Mastercard GCO (Global collection Only) and QMR (Quarterly Member Reporting) data. The analyst will ensure that the data required for submissions is accurate, compliant, and submitted in a timely manner.

• Review and analyze system scripts responsible for extracting data from various internal systems.
• Ensure that scripts and queries are correctly pulling the required Mastercard GCO data (e.g., transaction data, fees, chargebacks) and QMR data (e.g., volume metrics, settlement summaries).
• Work closely with IT and operations teams to optimize and automate the data extraction process.
• Prepare and structure data to meet Mastercards submission formats and reporting standards.
• Validate data integrity and accuracy by conducting reconciliations and quality checks before submission.
• Develop new or enhance existing system scripts, SQL queries, and automation processes for efficient data extraction.
• Troubleshoot and resolve any issues related to scripts, ensuring data is pulled accurately and timely.
• Document all data extraction procedures and ensure scripts are version-controlled.
• Ensure data submissions comply with Mastercards GCO and QMR reporting guidelines.
• Monitor and address any discrepancies or errors in data submissions as identified by Mastercard.
• Collaborate with reporting teams to ensure timely and accurate submissions.
• Analyze trends and patterns in extracted GCO and QMR data to identify areas of improvement or concern.
• Generate internal reports to provide insights into transaction volumes, fees, and other relevant data.
• Assist in compiling feedback for senior management regarding performance and compliance with Mastercards guidelines.
• Work closely with payment operations, compliance, IT, and finance teams to ensure alignment on data reporting requirements.
• Coordinate with vendors and service providers, if necessary, to integrate or adjust data feeds and ensure smooth data flow.
• Stay updated on Mastercards evolving GCO and QMR reporting standards, ensuring internal systems adapt accordingly.
• Identify opportunities for process improvements, automation, and enhanced reporting accuracy (e.g Direct upload and submission of GCO data from ISW to Mastercard).

Qualifications/ expectations required:

• Previous experience working with payment processors, specifically with Mastercard GCO and QMR reporting, is highly desirable.
• Experience in working 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 (especially with Mastercard networks).
• 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 in reviewing system outputs and ensuring data accuracy.
• Ability to translate complex system and transaction data into clear, actionable reports.
• Strong verbal and written communication skills to interact with technical and non-technical stakeholders.
• Ability to present data findings to management and recommend corrective actions when needed.
• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.