Data Analyst

Private Advertiser; Taguig; Hybrid; PHP 893,000 - 1,674,000; Full time

Job summary

Private Advertiser in the Philippines seeks a senior data auditor/engineer to audit large datasets, validate figures against vendor data, and detect anomalies using SQL and statistics.

You will leverage Python or R for validation and automation, and work with Snowflake, BigQuery, or Redshift to ensure data quality across ETL/ELT pipelines, APIs, and analytics platforms.

Strong analytical skills and experience with Pandas or PySpark for large-scale data work are highly valued.

Qualifications

• Bachelor’s degree or equivalent in any field.
• 5–8 years of experience in data auditing or data analytics.
• Advanced SQL skills with complex queries and joins.
• Experience with Snowflake, BigQuery, or Redshift.
• Proficiency in Python or R for data validation and automation.
• Familiarity with Pandas or PySpark and large datasets.

Responsibilities

• Conduct large-scale data audits and validate datasets against vendor figures.
• Detect discrepancies, fraud, and anomalies using SQL and statistics.
• Audit ETL/ELT pipelines, APIs, tracking tags, and server-side events.
• Manage data integration from Meta Ads, Google Analytics 4, and CRMs.
• Develop automated data-quality checks and validation dashboards.
• Investigate data issues and report risks to management.

Skills

Advanced SQL

Analytical thinking

Python or R

Education

Bachelor’s degree or equivalent

Tools

Snowflake

Google BigQuery

Amazon Redshift

Pandas

PySpark

Job description

Key Responsibilities

• Conduct large-scale data audits and validate high-volume datasets against vendor-reported figures.

• Detect data discrepancies, fraud, anomalies, and conversion-rate manipulation using SQL and statistical analysis.

• Audit ETL/ELT pipelines, APIs, tracking tags, server-side events, and web data to ensure data accuracy.

• Manage data integration from platforms such as Meta Ads, TikTok Ads, Google Analytics 4, and CRM systems.

• Develop automated data-quality checks, alerts, and validation dashboards.

• Investigate and report data issues, variances, and risks to management.

Qualifications

• Bachelor’s degree in any field or equivalent relevant experience.

• 5–8 years of experience in data auditing, data quality engineering, or senior data analytics.

• Advanced SQL skills, including complex queries, window functions, optimization, and multi-table joins.

• Experience with data warehouses such as Snowflake, Google BigQuery, or Amazon Redshift.

• Strong proficiency in Python or R for data validation, automation, and anomaly detection.

• Experience working with large datasets and tools such as Pandas or PySpark.

• Strong understanding of web tracking, APIs, pixels, server-side events, and browser developer tools.

• Excellent analytical, investigative, and problem-solving skills with strong attention to detail.