Data Analyst: ETL, Profiling & BI Dashboards

A7 Recruitment Company; Eastern Manila District; Vor Ort; PHP 670.000 - 1.116.000; Vollzeit

Zusammenfassung

A7 Recruitment Company seeks a data analytics professional in the Philippines to profile, cleanse, and map data across customer, meter, billing, and service order datasets to support CIS migrations.

Responsibilities include preparing data extracts, validating transformation logic, performing root cause analysis, and maintaining data dictionaries. Strong SQL, ETL, and dashboard skills with Power BI/Tableau/Qlik are required, plus knowledge of ERC reporting.

Qualifikationen

• BS Degree in relevant fields; 3–5 years in data analytics, preferably utilities or energy market.
• Strong SQL, data transformation, ETL, and data modeling skills.
• Experience with CIS, ERP, CRM, or billing systems.
• Dashboard development in Power BI, Tableau, Qlik, or similar.
• Experience in data profiling and reconciliation for migrations.
• Understanding of Philippine regulatory context (ERC reporting, RA 10173).
• Strong documentation and analytical skills.

Aufgaben

• Conduct data profiling for customer, meter, billing, payments, and service order datasets.
• Perform data cleansing and standardization per rules.
• Support ETL activities and data mapping for CIS migration.
• Prepare and validate data extracts, transformation logic, and reconciliation results.
• Perform root cause analysis on data issues.
• Maintain data dictionaries and documentation.

Kenntnisse

SQL

Data transformation

ETL support

Data modeling

Dashboard development

Data profiling

Documentation

Ausbildung

BS Degree in Management Science/Industrial Engineering/Math/Statistics/Analytics/Business Administration

Tools

Power BI

Tableau

Qlik

Jobbeschreibung

A7 Recruitment Company seeks a data analytics professional in the Philippines to profile, cleanse, and map data across customer, meter, billing, and service order datasets to support CIS migrations.

Responsibilities include preparing data extracts, validating transformation logic, performing root cause analysis, and maintaining data dictionaries. Strong SQL, ETL, and dashboard skills with Power BI/Tableau/Qlik are required, plus knowledge of ERC reporting.