Job Description: • Creating the architecture that supports business intelligence activities, ensuring data integrity, and optimizing data flow for efficient querying and reporting • Work with a variety of tools and technologies, including SQL databases, ETL (Extract, Transform, Load) processes and transform raw data into a structured format suitable for strategic decision-making • Designing and implementing robust data warehouse architectures that support business requirements • Developing ETL (Extract, Transform, Load) processes to integrate data from multiple sources into a centralized repository • Creating data models that accurately represent business processes and support analytics • Ensuring the security of the data warehouse and compliance with data governance standards • Optimizing data warehouse performance through indexing, partitioning, and query tuning • Collaborating with business analysts to understand analytical needs and deliver appropriate data structures • Writing complex SQL queries for data manipulation and retrieval • Testing and troubleshooting data systems to ensure accuracy and quality of data • Documenting the data warehouse and maintaining metadata repositories • Monitoring data warehouse systems to ensure reliability and performance standards are met • Providing support and training to end-users on data warehouse usage and best practices Job Requirement: • Bachelor degree or above, major in Gaming, Computer Science, Statistics, Data Science, IT is preferred • Minimum 1 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 • Good knowledge of gaming business areas covering business processes and reporting with analytics • Ability to analyze data and make recommendations Interested parties, please apply via: • Email the detailed resume to careers@sjmresorts.com • Hotline: 8297 0965 / 8297 0969