Marketing Database Analyst

Summary

The Marketing Database Analyst is responsible in assisting Database Marketing in database maintenance, direct mail/email operations, promotional set up, pro and post analysis of promotions, campaigns and events.  This team member will also assist in 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.

Essential Duties And Responsibilities

The requirements listed below are representative of the knowledge skill, and/or ability required to perform this job successfully. Upon request, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• 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.
• Strong attention to detail with continuous improvement 
• 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.

Working Culture Environment

• 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.

Working Culture Environment

• Strong proactive skills.
• Ability to plan workload and manage multiple projects with competing priorities.
• Ability to work with a high level of independence and or with related departmental Team members. 
• Strong attention to detail with continuous improvement
• Advanced analytical skills and ability to support business decision making using quantitative analysis
• Excellent communication skills both verbal and written. 
• Effective communicator in framing and presenting a concept or hypotheses
• Proven analytical and organizational skills to meet deadlines in an environment of often-changing priorities.
• Highly driven and self-motivated, with an entrepreneurial spirit. Ability to flourish in a multi-cultural environment. 

Supervisory Responsibilities

This job does not require supervisory duties.

Qualifications

Education And Experience (Must Be Documented)

• High School Diploma (or GED)
• Five (5) Years of Database Analysis Experience (Or Equivalent combination of Education/Experience)
• A bachelor’s degree from four-year college or university in math, computer science, business or a related field preferred.
• Extensive experience with Structured Query Language (SQL), Microsoft SQL Server, and all Microsoft Office Professional suite applications are required.  Along with extensive usage of specifically 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

Certification, Licenses And Any Additional Requirements

• 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.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Upon request, reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this Job, the employee is regularly required to talk and hear. The employee is frequently required to stand; walk and sit. The employee is occasionally required to use upper extremities, including but not limited to, hands and fingers to handle, or feel; reach with hands and arms. They may be occasionally required to climb or balance, stoop, bend, push, pull, twist, kneel, crouch, or crawl. The employee must occasionally lift up to 25 pounds and/or push, pull up to 50 pounds. The employee is occasionally required use repetitive movements to complete tasks. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus. Employee may be occasionally required to work in low light conditions, and may be exposed to loud noise for extended periods. 

Work Environment 

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

• Multiple locations.
• Some enterprises are open 24 hours per day, 7 days per week; therefore, you must be flexible to work any and all hours.
• Must be available for emergency calls 24/7.
• Must be available to work weekend and holidays.
• Some enterprises are gaming facilities.
• Some enterprises are not a smoke-free environment.
• Surveillance cameras and audio equipment monitor the premises recording activity throughout most of the facilities on 24 hours per day, 7 days per week basis.

Indian Preference Act

The Twenty-Nine Palms Band of Mission Indians has a resolution on file with Human Resources to ensure that Indian Preference will be adhered to in the following order in accordance with IPA:

                                         1.  Tribal Members

                                         2.  Other Native Americans

                                         3.  All other ethnic groups