- Browse Job
- Assistant Manager (Business Intelligence & Database Analytics)
- 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