Job Title: Data Engineer

Job Summary: We are seeking a skilled and detail-oriented Data Engineer to design, build, and maintain scalable data pipelines and systems. The ideal candidate will ensure the availability, accuracy, and integrity of data across multiple business functions, enabling data-driven decision-making within the organization.

Key Responsibilities:

A. Data Pipelines & Integrations

• Develop and maintain daily data pipelines for PAYable systems (mPOS, WPOS, SoftPOS, IPG, Instant Settlement, Business Central, etc.).
• Extract data from multiple sources including SQL databases, APIs, and flat files (Excel/CSV) into structured datasets.
• Ensure data accuracy, consistency, and timely availability for business operations.
• Automate recurring data preparation and processing tasks using Python, SQL, PySpark, or similar tools.

B. Database & Data Management

• Manage and maintain internal data warehouse structures, including tables, schemas, and views.
• Write, optimize, and maintain efficient SQL queries for reporting and operational needs.
• Ensure data quality and consistency across merchant, transaction, device, and settlement datasets.
• Maintain proper documentation of data sources, structures, and transformation processes.

C. Reporting & Dashboard Support

• Develop and maintain Power BI dashboards for various departments including Operations, Finance, Retail, and Sales.
• Create DAX measures and optimize data models to enhance dashboard performance.
• Ensure scheduled dashboard refreshes (daily, weekly, monthly) run accurately without failures.

D. Cross-Department Support

• Collaborate with Operations, Finance, Retail, Sales, and Product teams to understand and fulfill data requirements.
• Provide datasets, reports, and analytical insights as needed.
• Support data-related investigations such as bank queries, merchant issues, and settlement validations.

E. Monitoring & Troubleshooting

• Monitor data pipeline performance and system reliability.
• Troubleshoot and resolve data issues, including missing records and failed processes.
• Maintain logs and documentation for incidents, fixes, and preventive actions.

Qualifications & Skills:

• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, or a related field.
• Proven experience in data engineering or a similar role.
• Strong proficiency in SQL and experience with relational databases.
• Experience with Python, PySpark, or other data processing tools.
• Familiarity with data warehousing concepts and ETL processes.
• Experience with Power BI (including DAX and data modeling).
• Strong analytical and problem-solving skills.
• Ability to work collaboratively across teams and manage multiple priorities.

Preferred Qualifications:

• Experience working with financial/payment systems or fintech environments.
• Knowledge of cloud platforms (Azure, AWS, or GCP) is an added advantage.