MarketingDatabase Analyst

JACKPOT JUNCTION CASINO HOTEL•Morton, MN

39d•$58,656 - $116,713•Onsite

About The Position

ESSENTIAL JOB FUNCTIONS Maintain SQL databases and create queries/reports (e.g. monthly mailing lists, promotion redemption lists, overall database segmentation by play level, etc.) to develop marketing and finance objectives. Maintain and develop marketing and finance reports. Provide technical and system support for applicable departments. Generate monthly reports pertaining to tiered mailing offer redemption, promotions and events; analyze for effectiveness. Provide input on database segmentation analysis. Interface with Finance and Marketing teams to assist with goals and objectives. Use SQL Query Analyzer and Enterprise Manager to collect data and compile reports. Develop queries/reports that will increase play potential and player retention. Query all mail lists for direct mailings. Manage the setup, production and distribution of standard and custom reports. Focus on player database management (e.g. player development, effective player and group tracking, etc.). Understand, implement and document high-level data warehousing. Assist with checking accuracy of point and comp accumulation. Work with other departments to maximize utilization of tracking system. Maintain open lines of communication with operating departments to ensure coordination between areas. Attend Finance and Marketing meetings. Perform other duties and responsibilities as assigned.

Requirements

5+ years database analysis and marketing experience in Casino Operations required.
Bachelors degree in Marketing, Business Administration or a related field preferred.
Computer programming and SQL experience preferred.
Knowledge and efficiency with Access, Excel and Crystal.
Knowledge and efficiency with SQL Enterprise Manager and Query Analyzer.
Knowledge of SQL database management.
Knowledge of the principles of Sales & Marketing promotions and market segmentation.
Strong verbal and written communication skills.
Strong organizational and time management skills.
Strong report writing and computer programming skills.
Conversant with theoretical win and how it pertains to each game.
Ability to maintain strict confidentiality of classified information.
Ability to multitask and work independently.
Ability to maintain high initiative and a positive attitude.
Sensitivity to various cultures, including Native American cultures.
Regular attendance and punctuality.
Able and willing to work any changes in scheduled hours as required.
Serve as a credit to Jackpot Junction Casino Hotel, and encourage others to do the same.
Mobility throughout the facility.

Responsibilities

Maintain SQL databases and create queries/reports (e.g. monthly mailing lists, promotion redemption lists, overall database segmentation by play level, etc.) to develop marketing and finance objectives.
Maintain and develop marketing and finance reports.
Provide technical and system support for applicable departments.
Generate monthly reports pertaining to tiered mailing offer redemption, promotions and events; analyze for effectiveness.
Provide input on database segmentation analysis.
Interface with Finance and Marketing teams to assist with goals and objectives.
Use SQL Query Analyzer and Enterprise Manager to collect data and compile reports.
Develop queries/reports that will increase play potential and player retention.
Query all mail lists for direct mailings.
Manage the setup, production and distribution of standard and custom reports.
Focus on player database management (e.g. player development, effective player and group tracking, etc.).
Understand, implement and document high-level data warehousing.
Assist with checking accuracy of point and comp accumulation.
Work with other departments to maximize utilization of tracking system.
Maintain open lines of communication with operating departments to ensure coordination between areas.
Attend Finance and Marketing meetings.
Perform other duties and responsibilities as assigned.