Senior Specialist, Business Intelligence

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

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

Dashboards & Reporting

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

Governance & Compliance

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.