Data Analyst

A7 Recruitment Company; Eastern Manila District; On-site; PHP 670,000 - 1,116,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL

Data transformation

ETL support

Data modeling

Dashboard development

Data profiling

Documentation

Education

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

Tools

Power BI

Tableau

Qlik

Job description

Responsibilities

• Conduct data profiling for customer, meter, billing, payments, and service order datasets
• Perform data cleansing and standardization based on approved business and regulatory 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

Requirements

• BS Degree in Management Science (Industrial Engineering), Mathematics (or Statistics), Business Intelligence & Analytics, Management of Information Systems, or Management (Business Administration3 to 5 years’ experience in data analytics, preferably in utilities or energy market
• Strong SQL, data transformation, ETL support, and data modeling skills
• Experience working 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