Morongo Casino Resort & Spa
Marketing Database Analyst
Morongo Casino Resort & Spa, Cabazon, California, United States, 92230
Job SummaryIs responsible for assisting management of database maintenance, direct mail/email operations, and promotional setup, including mailing list preparation and deadlines. Incumbent coordinates, reports, and audits on direct mail and promotional setup to ensure accuracy. Is responsible for developing detailed analytics for offer-based, event-based, and promotion-based casino marketing initiatives and maintaining accurate records.Essential Duties And ResponsibilitiesImplement, develop and maintain Player Tracking Database.Utilize knowledge of Structured Query Language (SQL, MySQL, MS SQL), data warehouses, relational databases, and multi-dimensional databases in analyzing various data sources (Konami-Synkros and Discoverer, Quick Custom Intelligence-QCI Campaign Manager, Playersoft-Event Management, Enrollment, Group Management, Everi-Promotional Kiosk and PowerKiosk Management System, in-house databases, data warehouse, other third-party data sources, etc.) to develop the queries and procedures for extracting and communicating required information.Responsible for ensuring data integrity for all data sources used.Work closely with all areas of marketing and Information Technology staff to identify, troubleshoot, and resolve data-related issues of concern.Review, monitor, report, and audit results from campaigns, special events and promotions to ensure accuracy and determine performance, effectiveness, and revenue generating impact.Assist in the planning and implementation of promotional programs designed to attract and retain large groups of new and existing guests to the casino.Work within a team to ensure that campaigns and promotions setup needed to carry out the promotions are in place in a timely manner.Create, maintain, and archive promotions in the Promotion Kiosk and PowerKiosk Management System.Be the subject matter expert for database marketing system, including but not limited to the Player Tracking System, and Player Kiosks.Be on call for any issues regarding the loading of offers and promotional setup, including monitoring active promotions during go-live.Collaborate, assist, and communicate with all departments informing the direct mail and email campaigns in a timely manner.Lead analysis to gather data, organize it into reports and provide conclusions.Responsible for database integrity (security, data cleansing, NCOA, etc.).Provide pre and post campaign analysis.Responsible for the strict adherence to Compliance policies, internal control procedures and the Casino’s policies and procedures.Other job-related duties may be assigned.QualificationsIn-depth knowledge of direct mail including players tracking database. Knowledge and experience with Slot Player Tracking, Casino Management and Casino marketing systems highly preferred.
Knowledge and experience with SQL/MySQL/MS SQL-based Business Intelligence solutions with data analytics, visualization and slot-floor/external geographic mapping highly preferred.
Proficient in Structured Query Language (SQL, MySQL, MS SQL) and developing and maintaining SQL standard compliant databases (Microsoft SQL Server and other relational database products), multi-dimensional databases, and data mining models. Comprehensive knowledge of all Microsoft Office Professional software applications, including but not limited to Microsoft SQL Server, Access, and Excel. Proven experience in the use of computer systems including database systems, software, data retrieval methodologies and quantitative analysis. Ability to maintain strict confidentiality of classified information. Proven statistical, analytical and problem-solving abilities including the ability to identify trends, patterns and relationships in data; develop and measure testing scenarios; and synthesize/report results. Strong guest service orientation. Experience working both independently and in a collaborative team environment. Strong written and oral communication skills and interpersonal skills.EDUCATION AND EXPERIENCE:High School Diploma or GED required. A Bachelor's degree (BS/BA) from four-year college or university; and at least two years of casino related experience and/or training; or equivalent combination of education and experience. Extensive experience with Structured Query Language (SQL), Microsoft SQL Server, and all Microsoft Office Professional suite applications is required. Strongly prefer a background in relational and multi-dimensional database management and/or design, data warehouse management, query writing, and report writing. Prior experience utilizing strong financial analysis and/or statistical analysis skills, and exhibiting a functional understanding of financial principles preferred.
Knowledge and experience with SQL/MySQL/MS SQL-based Business Intelligence solutions with data analytics, visualization and slot-floor/external geographic mapping highly preferred.LICENSES, CERTIFICATES, REGISTRATIONS:Must undergo and successfully pass a background investigation to obtain and maintain a gaming license issued by the Morongo Gaming Agency.LANGUAGE SKILLS:Tact and diplomacy are essential. Ability to interpret documents such as rules and regulations, instructions and procedure manuals. Ability to write routine reports and correspondence.MATHEMATICAL SKILLS:Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions and decimals. Experience in statistical analysis, including the ability to identify trends, patterns and relationships in data; develop and measure testing scenarios; and synthesize/report results highly preferred.REASONING ABILITY:Must reason with people effectively yet cordially. Ability to apply common sense understanding to carry out instructions furnished in written, oral or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.PHYSICAL DEMANDS:While performing the duties of this job, the team member is regularly required to stand; use hands to finger, handle, or feel; talk or hear; and taste or smell. The team member frequently is required to walk and reach with hands and arms. The team member is occasionally required to sit. The team member must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, color vision, depth perception, and ability to adjust focus.WORK ENVIRONMENT:This is a fast-paced work environment and the position requires the ability to cope with it. The casino environment has moderate to loud noise levels and is a smoking environment.WORKING HOURS:Because we are open 24 hours a day, 365 days a year, most positions require flexibility in scheduling and may require Team Members to be available for evenings, weekends, holidays and special events. A typical workweek is 40 hours and normal work schedules may vary based on business needs and may include scheduled shifts Monday through Sunday. Position may require overtime.INDIAN PREFERENCE:We are an Equal Opportunity Employer while practicing Native American preference according to law.
#J-18808-Ljbffr
Knowledge and experience with SQL/MySQL/MS SQL-based Business Intelligence solutions with data analytics, visualization and slot-floor/external geographic mapping highly preferred.
Proficient in Structured Query Language (SQL, MySQL, MS SQL) and developing and maintaining SQL standard compliant databases (Microsoft SQL Server and other relational database products), multi-dimensional databases, and data mining models. Comprehensive knowledge of all Microsoft Office Professional software applications, including but not limited to Microsoft SQL Server, Access, and Excel. Proven experience in the use of computer systems including database systems, software, data retrieval methodologies and quantitative analysis. Ability to maintain strict confidentiality of classified information. Proven statistical, analytical and problem-solving abilities including the ability to identify trends, patterns and relationships in data; develop and measure testing scenarios; and synthesize/report results. Strong guest service orientation. Experience working both independently and in a collaborative team environment. Strong written and oral communication skills and interpersonal skills.EDUCATION AND EXPERIENCE:High School Diploma or GED required. A Bachelor's degree (BS/BA) from four-year college or university; and at least two years of casino related experience and/or training; or equivalent combination of education and experience. Extensive experience with Structured Query Language (SQL), Microsoft SQL Server, and all Microsoft Office Professional suite applications is required. Strongly prefer a background in relational and multi-dimensional database management and/or design, data warehouse management, query writing, and report writing. Prior experience utilizing strong financial analysis and/or statistical analysis skills, and exhibiting a functional understanding of financial principles preferred.
Knowledge and experience with SQL/MySQL/MS SQL-based Business Intelligence solutions with data analytics, visualization and slot-floor/external geographic mapping highly preferred.LICENSES, CERTIFICATES, REGISTRATIONS:Must undergo and successfully pass a background investigation to obtain and maintain a gaming license issued by the Morongo Gaming Agency.LANGUAGE SKILLS:Tact and diplomacy are essential. Ability to interpret documents such as rules and regulations, instructions and procedure manuals. Ability to write routine reports and correspondence.MATHEMATICAL SKILLS:Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions and decimals. Experience in statistical analysis, including the ability to identify trends, patterns and relationships in data; develop and measure testing scenarios; and synthesize/report results highly preferred.REASONING ABILITY:Must reason with people effectively yet cordially. Ability to apply common sense understanding to carry out instructions furnished in written, oral or diagram form. Ability to deal with problems involving several concrete variables in standardized situations.PHYSICAL DEMANDS:While performing the duties of this job, the team member is regularly required to stand; use hands to finger, handle, or feel; talk or hear; and taste or smell. The team member frequently is required to walk and reach with hands and arms. The team member is occasionally required to sit. The team member must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, color vision, depth perception, and ability to adjust focus.WORK ENVIRONMENT:This is a fast-paced work environment and the position requires the ability to cope with it. The casino environment has moderate to loud noise levels and is a smoking environment.WORKING HOURS:Because we are open 24 hours a day, 365 days a year, most positions require flexibility in scheduling and may require Team Members to be available for evenings, weekends, holidays and special events. A typical workweek is 40 hours and normal work schedules may vary based on business needs and may include scheduled shifts Monday through Sunday. Position may require overtime.INDIAN PREFERENCE:We are an Equal Opportunity Employer while practicing Native American preference according to law.
#J-18808-Ljbffr