Assistant Manager, Campaign Management

solaireresort; Parañaque; On-site; PHP 600,000 - 900,000; Full time

Job summary

solaireresort is seeking a data analytics specialist to drive campaign analytics and BI reporting. You will write advanced SQL/Python queries to extract audiences, design post-campaign measurement frameworks, and build automated Power BI dashboards for cross-channel insights.

You will develop segmentation models, lead A/B testing analyses, and collaborate with IT and other departments to optimize data flows and campaign ROI. A Bachelor’s degree and 3–5 years in analytics are required.

Qualifications

• Bachelor’s degree in Information Systems, Data Analytics, CS, Statistics, or a related quantitative field.
• 3–5 years in campaign analytics, data analysis, or marketing BI roles.
• Experience analyzing database marketing initiatives in/casino, gaming, hospitality, or loyalty environments.
• Proficient in SQL, Power BI (DAX/Data Modeling), Excel; familiarity with automated messaging data flows.

Responsibilities

• Write and maintain SQL/Python queries to extract and validate target audiences.
• Design post-campaign measurement frameworks; assess uplift, NGR, and ROI.
• Build and automate Power BI dashboards to monitor cross-channel performance.
• Design A/B and multivariate tests; analyze results for lift and deployment parameters.
• Collaborate with IT/Data Engineering to streamline data pipelines and ensure trigger delivery.
• Develop segmentation models and behavioral clusters to improve targeting and retention.
• Support cross-department analytics with Loyalty, Casino Marketing, F&B, Hotel, and Events teams.
• Create cost/budget optimization models to guide messaging spend and ROI.

Skills

SQL

Python

Power BI

Data Visualization

Excel

Audience Segmentation

Education

Bachelor's Degree

Information Systems

Data Analytics

Statistics / Mathematics

Tools

BI Reports / Dashboards

Data Warehousing concepts

Job description

DUTIES AND RESPONSIBILITIES

• Data & Journey Logic Architecture: Write and maintain custom queries (SQL/Python) to extract, segment, and validate target player audiences for gaming and non-gaming campaign triggers.
• Post-Campaign Performance Analysis: Design and execute robust post-campaign measurement frameworks, assessing incremental uplift, redemption behavior, net gaming revenue (NGR), and ROI.
• Power BI & Dashboard Management: Build, automate, and maintain interactive Power BI dashboards to track cross-channel messaging performance (SMS, Viber, push) and player engagement metrics.
• A/B & Multivariate Testing Analysis: Design statistically sound test-and-learn frameworks; analyze experiment results to evaluate lift, conversion rates, and optimal deployment parameters.
• Data Pipeline & Automation Support: Collaborate with IT and Data Engineering to streamline data flows between core databases/DWs and execution tools, ensuring seamless trigger delivery.
• Segmentation & Predictive Modeling: Develop advanced segmentation models and behavioral clusters to improve audience targeting, campaign relevancy, and player retention.
• Cross-Departmental Analytics Support: Partner with Loyalty, Casino Marketing, F&B, Hotel, and Events teams to translate operational requirements into precise analytics and targeting logic.
• Cost & Budget Optimization Modeling: Build cost-efficiency models to track messaging expenses, evaluate cost-per-message trends, and recommend budget allocation strategies to maximize ROI.
• Data Governance & Data Quality: Audit campaign target files and post-send logs to ensure data integrity, prevent payload errors, and enforce database governance standards.
• Workflow & Query Standardization: Standardize SQL scripts, code repositories, and intake reporting processes to streamline data requests and shorten campaign reporting lead times.
• Technical Troubleshooting: Work alongside IT and platform vendor technical teams to resolve data pipeline failures, API drop-offs, and tracking payload discrepancies.

KEY COMPETENCIES AND SKILLS

• Advanced Querying & Coding: Strong proficiency in SQL (and/or Python) for database extraction, data transformation, and automation.
• BI & Data Visualization: Hands-on experience building and publishing scalable Power BI reports, data models, and executive dashboards.
• Data-Driven Thinking: Ability to interpret complex gaming and promotional data, converting raw logs into actionable commercial insights.
• Attention to Detail: Rigorous standards in data validation, query optimization, and source-to-report reconciliation.
• Cross-Functional Collaboration: Comfortable translating technical analytics findings into clear takeaways for business and operational stakeholders.
• Technical Problem Solving: Strong diagnostic mindset for identifying data inconsistencies, pipeline delays, and platform integration bugs.

KEY PERFORMANCE INDICATORS / KEY SUCCESS FACTORS

• Reporting & Pipeline Automation: % of manual campaign reports and data feeds converted into automated SQL/Power BI pipelines.
• Data Accuracy & Integrity: Zero-to-minimal data payload errors, targeting discrepancies, or post-send reporting corrections.
• Uplift & Experimentation Impact: Successful delivery of statistical A/B test evaluations and actionable lift insights implemented by operational teams.
• Dashboard Utilization & Uptime: High stakeholder adoption and reliable delivery of scheduled Power BI reporting packs.
• Query Efficiency & Optimization: Streamlined code execution times and well-documented repository scripts for team scalability.
• Process Improvement: Documented enhancements to target extraction, reporting lead times, or campaign attribution models.

Requirements

• Educational Attainment: Bachelor’s Degree.
• Major Field of Study: Information Systems, Data Analytics, Computer Science, Statistics, Mathematics, or a related quantitative field.
• Experience: Minimum 3–5 years of hands-on experience in campaign analytics, data analysis, or marketing BI roles.
• Domain Experience: Proven experience analyzing database marketing initiatives, preferably within casino, gaming, hospitality, or high-volume loyalty environments.
• Technical Stack: Advanced proficiency in SQL, Power BI (DAX / Data Modeling), Excel, and hands-on familiarity with data architectures supporting automated messaging channels (SMS, Viber, Email, Push).
• Cross-Functional Exposure: Proven background collaborating directly with Analytics, IT, and Operations teams to ensure performance tracking, compliance, and reporting reliability.