Job Description

The BI team is responsible for design, developing, and maintaining data models, dashboards, reports and analytical tools to support business decision-making. The role involves data preparation, ETL process development, and automation of data workflows to ensure data accuracy, consistency, and accessibility across the organization.

Key Responsibilities

1. Data Engineering & Pipeline Development

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources to the target data warehouse, data Lakehouse
• Collaborate with the internal team to align on data sources, business definitions, and functional logic updates
• Ensure data used in dashboards/reports is accurate, complete, up-to-date, and consistency across platforms

• Develop dashboards and reports (AWS QuickSight, SQL Reporting Server) for management, product, finance, and BD teams.
• Develop an automated report for internal and external use
• Perform deep-dive analysis on transaction trends, payment success rates, and revenue leakage.
• Support ad-hoc analyses to answer critical business questions from management and the internal team

• Implement data classification, access controls, and row-level security (RLS) by country or product.
• Align data structures with business needs.

Requirements

• Strong SQL skills (complex queries, optimization in Redshift, Athena, Databricks Spark SQL).
• Strong in Python for data cleaning, automation, and exploratory data analysis(EDA)
• Experience with BI tools (AWS QuickSight, SQL Reporting Services)
• Experience in Big Data using Databricks, Spark for big data processing
• Experience in Data Warehouse, Data Lakehouse, ETL and BI tools
• Strong problem-solving, business analysis, and communication skills
• Strong communication skills in English
• Detail-oriented and high responsibility

Working Conditions

• May be required to work on-call or outside regular business hours for emergency support or maintenance.
• May involve working with global teams across different time zones.

At 2C2P, interested candidates are invited to submit a comprehensive resume with current and expected salary via this job advertisement. Please note that only shortlisted candidates will be contacted.

Please consult our Candidate Privacy Notice to learn more about how we collect, use, transfer, and disclose candidates’ information: https://2c2p.com/candidate-privacy-notice

By submitting your resume and information, you acknowledge and consent to the processing of your personal data in accordance with our Candidate Privacy Notice, including receiving communications from 2C2P via email or other electronic messaging.