Data Analyst: ETL, Profiling & Dashboards for Utilities

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

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.