Position
Assistant Manager (Business Intelligence & Database Analytics)
Department
Strategic Analysis
Working Location
Taipa / Cotai
Post Date
13/12/2024
Requirements
• Bachelor degree or above, major in Gaming, Computer Science, Statistics, Data Science, IT is preferred
• Minimum 4 years’ analytical experience in gaming/marketing & sales area
• Any valid professional certification for Excel, PowerPoint, MS SQL server, data mining, SAS, Tableau, PowerBI, SSRS, Python is preferred
• Knowledge of gaming marketing, CRM, structure of loyalty program and table & slot operation is preferred
• Knowledge of Excel, PowerPoint, MS SQL server, data mining, SAS, Tableau, PowerBI, SSRS, Python and CAD
• Proficient in both written and spoken Chinese and English
Responsibilities
• Designing and implementing robust data warehouse architectures that support business requirements
• Ensuring data warehouse security and compliance with governance standards
• Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository
• Optimizing data warehouse performance through indexing, partitioning, and query tuning
• Collaborating with business analysts to understand analytical needs and deliver appropriate data structures
• Monitoring data warehouse systems to ensure reliability and performance standards are met as well as ensuring all deliverables to business stakeholders on a timely manner
• Testing and troubleshooting data systems to ensure accuracy and quality
• Prepare visualizations and data-driven reports that accurately represent business processes and support analytics
• Documenting the data warehouse and maintaining metadata repositories
• Perform other duties as assigned by management