SJM Job

Position: Senior Analyst (Business Intelligence & Database Analytics)
Department: Strategic Analysis
Working Location: Taipa / Cotai
Post Date: 16/05/2024
Requirements: • Bachelor degree or above, major in Gaming, Computer Science, Statistics, Data Science, IT is preferred
• Minimum 2 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
Responsibilities: • 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

Site Map

Location

Department

Contact