Senior Data Analyst

Private Advertiser; Metro Manila; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

Private Advertiser in Metro Manila is seeking a data professional to execute end-to-end data extraction, transformation, validation, and reconciliation, and to design dashboards for stakeholders.

The ideal candidate will write complex SQL, build efficient data pipelines with ETL tools, ensure data quality, and collaborate with IT and business units to define data requirements.

Qualifications

• Experience in end-to-end data extraction, transformation, validation and reconciliation.
• Proficient in writing and optimizing complex SQL queries.
• Experience with ETL tools such as Informatica, SSIS, Talend or Alteryx.
• Strong data validation and quality assurance skills; able to identify data quality gaps.
• Proficient in BI tools like Power BI or Tableau and communicating insights to non-technical stakeholders.
• Bachelor’s degree in Computer Science, Information Technology, Statistics, or Finance.

Responsibilities

• Data Execution: Perform end-to-end data extraction, transformation, validation, and reconciliation.
• Pipeline Management: Build and maintain efficient data pipelines using ETL tools.
• Query Optimization: Write complex SQL queries to retrieve large datasets from data warehouses.
• Quality Assurance: Validate data accuracy and reconcile discrepancies between system sources.
• Reporting: Design dashboards to visualize key performance metrics for stakeholders.
• Collaboration: Partner with IT and business units to define data requirements.

Skills

Analytical mindset

Communication

Education

Bachelor’s degree in Computer Science, Information Technology, Statistics, or Finance

Tools

Informatica

SSIS

Talend

Alteryx

Power BI

Tableau

SQL

Job description

Key Responsibilities

• Data Execution: Perform end-to-end data extraction, transformation, validation, and reconciliation.




• Pipeline Management: Build and maintain efficient data pipelines using ETL tools.




• Query Optimization: Write complex SQL queries to retrieve large datasets from data warehouses.




• Quality Assurance: Validate data accuracy and reconcile discrepancies between system sources.




• Reporting: Design dashboards to visualize key performance metrics for stakeholders.




• Collaboration: Partner with IT and business units to define data requirements.

Technical Qualifications

• Database Languages: Hands-on experience writing and optimizing complex SQL queries.




• ETL Tools: Proven experience using ETL platforms (e.g., Informatica, SSIS, Talend, or Alteryx).




• Data Validation: Strong skills in data reconciliation and identifying data quality gaps.




• BI Tools: Proficiency in visualization software like Power BI or Tableau.




• Banking Systems: Familiarity with financial data structures or core banking systems is a plus.

Professional Skills

• Analytical Mindset: Strong problem-solving skills with high attention to detail.




• Communication: Ability to explain complex technical data to non-technical managers.




• Education: Bachelor’s degree in Computer Science, Information Technology, Statistics, or Finance.