Data Analyst at PayTech Group

Purpose of Job

• The Data Analyst will be responsible for reviewing, maintaining, and enhancing system scripts and processes to extract, validate, and prepare and extract data and build segmentation model. 
• The analyst will ensure that the data required for the project is accurate, compliant, and submitted in a timely manner.

Core Responsibilities and Accountabilities

• Review and analyze system scripts responsible for extracting data from various internal systems.
• Ensure that scripts and queries are correctly pulling the required customer data.
• Work closely with IT and operations teams to optimize and automate the data extraction process.
• Prepare and structure data to meet Mastercards required 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 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 data submissions.
• Analyze trends and patterns in extracted data to identify areas of improvement or concern.
• Generate internal reports to provide customer segment insights for the 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 where necessary 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 reporting standards, ensuring internal systems adapt accordingly.
• Identify opportunities for process improvements, automation, and enhanced reporting accuracy.

Requirements

• Candidates should possess a Bachelor's Degree in Computer Science, Information Systems, Data Analytics, or a related field
• Must have have 5-7 Years experience.
• Previous experience working in financial or payment industry.
• 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.

Mandatory Requirements:

• Payment Processing
• Data Extraction
• Segment Modelling
• Lead creation