Assistant Manager, Campaign Management

Assistant Manager, Campaign Management

Company : Solaire Resort Job Type : Full Time Philippines

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