Marketing Database Analyst (6746)

TWENTY-NINE PALMS BAND OF MISSION INDIANS•Coachella, CA

2d•Onsite

About The Position

The Marketing Database Analyst is responsible for assisting Database Marketing in database maintenance, direct mail/email operations, promotional setup, and pro and post analysis of promotions, campaigns, and events. This team member will also assist in the creation of analytics to display how different campaigns and events impact our customer database. In addition, we strive to deliver our Five Star Experience to Guests and fellow Team Members. This includes being committed to our Service Promise: We are the Twenty-Nine Palms Band of Mission Indians Team, where your experience is our top priority. Every person and detail matters.

Requirements

High School Diploma (or GED)
Five (5) Years of Database Analysis Experience (Or Equivalent combination of Education/Experience)
Extensive experience with Structured Query Language (SQL, MySQL, MS SQL)
Extensive experience with Microsoft SQL Server
Extensive experience with all Microsoft Office Professional suite applications
Extensive usage of Excel
Ability to interpret documents such as rules and regulations, instructions and procedure manuals.
Ability to write routine reports and correspondence.
Basic knowledge of Oracle preferred.
Ability to plan workload and manage multiple projects with competing priorities.
Must pass periodic random drug screens.
Must be able to pass background suitability investigation.
Must obtain a Tribal Gaming License.
Must obtain all other applicable certifications and licenses.
Must provide proof of eligibility to work in the United States within 72 hours of employment.

Nice To Haves

A bachelor’s degree from four-year college or university in math, computer science, business or a related field preferred.

Responsibilities

Coordinates, reports and audits on direct mail and promotional set up to ensure accuracy.
Is responsible for developing detailed analytics for offer-based, event-based, and promotion-based casino marketing initiatives.
Utilize, develop, and maintain the Player Tracking Database.
Utilize knowledge of Structured Query Language (SQL, MySQL, MS SQL), relational databases, and multi-dimensional databases in analyzing various data sources (Konami-Synkros and Discoverer, Quick Custom Intelligence-QCI Campaign Manager, Everi-Promotional Kiosk and PowerKiosk Management System, in-house databases, and other third-party data sources, etc.)
Develop data queries and procedures for extracting and communicating required information.
Responsible for ensuring data integrity for all data sources and all Vendors working with data.
Work closely with all areas of Marketing team members 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.
Leads 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.
Be the subject matter expert for database marketing systems and be on call for any issues regarding the loading of offers and promotional setup, including monitor active promotions and offers.
Provide outstanding customer service to guests and all other employees by exceeding our mission statement.
Coordinates with all levels of management to gather, analyze, summarize and prepare recommendations regarding financial plans, acquisition activity, new business planning, trended future requirements and operating forecasts.
Assist in pro and post campaign analysis to help provide recommendations on things that are working well or adjustments that need to be made.
Analyze both the profitability of customer database marketing programs and special events.
Conducts ad hoc, cost/benefit analysis and/or breakeven analysis for various projects assigned.
Maintain positive working relationships.
Ensure compliance with all Minimum Internal Control Standards (MICS) as well as all Tribal Internal Control Standards (TICS).
Present a positive image of the Tribal organization to its guests and vendors and to assist them as required.
Must follow all safety policies and procedures and attend all scheduled safety meetings and training as a condition of employment.
Deliver our Five Star Experience to Guests and all Team Members by embodying our Mission Statement and Service Promise while adhering to department service standards. This entails consistency performing our service expectations of: Welcoming, Proactive, Seamless, Personalized and Valued.
Perform any other duties that may be assigned from time to time.
Utilize SQL and reporting tools to develop complex queries that identify high-value segments, “churning guests and acquisition opportunities.
Ensure the integrity and security of guest information and work closely with IT to troubleshoot data related issues and optimize data flows.
Assist in rigorous proofing of all direct offer lists and uploads.