About this role
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.
Tired of cold applications?
Sign up with Clera and we'll reach out the moment a role actually fits you — no more spraying applications into the void.
Know someone who'd be great for this?