Data Analyst

A7 Recruitment Corporation; Pasig; On-site; PHP 350,000 - 650,000; Full time

Job summary

A7 Recruitment Corporation is seeking a Data Analyst to perform data profiling, cleansing, and standardization across customer, meter, billing, payments, and service order datasets. You will support ETL activities, data mapping for CIS migrations, and maintain data dictionaries.

Applicants should have a BS degree in a relevant field and at least 2 years in data analytics, preferably in utilities or energy markets, with strong SQL and dashboarding skills in Power BI/Tableau/Qlik.

Qualifications

• Requires BS degree in a relevant field and 2+ years in data analytics in utilities or energy market.
• Strong SQL, ETL, data transformation, and data modeling skills.
• Experience with CIS, ERP, CRM, or billing systems is preferred.
• Dashboard development using Power BI/Tableau/Qlik or similar tool is required.

Responsibilities

• Conduct data profiling for customer, meter, billing, payments, and service order datasets.
• Perform data cleansing and standardization per 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 and maintain data dictionaries.

Skills

SQL

Data profiling

ETL

Data mapping

Data modeling

Power BI

Tableau

Qlik

Documentation

Communication

Regulatory knowledge

Education

BS Degree in relevant fields (Industrial Eng/Math/Statistics/Business Analytics)

Tools

CIS

ERP

CRM

Billing systems

Job description

About the role

This role involves conducting data profiling, cleansing, and standardization of customer, meter, billing, payments, and service order datasets. You will support ETL activities and data mapping for CIS migration, prepare and validate data extracts, and perform root cause analysis on data issues while maintaining comprehensive data dictionaries and documentation.

Key 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

About you

• BS Degree in Management Science (Industrial Engineering), Mathematics (or Statistics), Business Intelligence & Analytics, Management of Information Systems, or Management (Business Administration)

• Minimum 2 years of 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

• Detail-oriented but system-aware

• Strong communication skills