Campaign Analytics Lead: SQL, Power BI & A/B Testing

Solaire Resort; Philippines; On-site; PHP 780,000 - 1,200,000; Full time

Job summary

Solaire Resort is seeking an Assistant Manager, Campaign Management in the Philippines to lead data-driven marketing analytics. You will craft audience segments using SQL/Python, design post-campaign metrics, and build interactive Power BI dashboards to monitor cross-channel performance.

The role requires 3–5 years in campaign analytics or marketing BI, with strong SQL and Power BI skills and experience collaborating with IT, analytics, and operations teams.

Qualifications

• Bachelor's degree in a quantitative field.
• 3–5 years hands-on campaign analytics or marketing BI experience.
• Strong SQL and Power BI skills for dashboards and reporting.

Responsibilities

• Write and maintain SQL/Python queries to segment audiences and validate target groups.
• Design post-campaign measurement frameworks and assess uplift, ROI, and NGR.
• Build, automate, and maintain Power BI dashboards for cross-channel performance (SMS, Viber, push).
• Design A/B and multivariate tests; analyze results for lift and optimal parameters.
• Collaborate with IT and Data Engineering to streamline data flows and trigger delivery.
• Develop advanced segmentation models and behavioral clusters for targeting and retention.
• Partner with Loyalty, Casino Marketing, F&B, Hotel, and Events teams to translate requirements into analytics logic.
• Build cost-efficiency models to track messaging expenses and budget allocation.
• Audit campaign target files and logs to ensure data integrity and governance.
• Standardize SQL scripts and reporting processes to reduce lead times.
• Troubleshoot data pipelines, API issues, and tracking discrepancies.

Skills

SQL

Python

Power BI

Data modeling

DAX

Analytical thinking

Education

Bachelor's Degree in Information Systems/Data Analytics/CS/Statistics

Tools

Excel

Data architectures

Job description

Solaire Resort is seeking an Assistant Manager, Campaign Management in the Philippines to lead data-driven marketing analytics. You will craft audience segments using SQL/Python, design post-campaign metrics, and build interactive Power BI dashboards to monitor cross-channel performance.

The role requires 3–5 years in campaign analytics or marketing BI, with strong SQL and Power BI skills and experience collaborating with IT, analytics, and operations teams.