Database Assistant Jobs in Fresno, CA (NOW HIRING)

Job Summary:
Table Mountain Casino Resort is seeking a Manager of Database Marketing to oversee the design and execution of their database marketing programs. The role involves ensuring database systems are optimized for performance, analyzing marketing data, and managing various database marketing projects to enhance customer engagement and profitability.
Responsibilities:
• Ensure database systems are optimally designed for stability, availability and performance to include: setup, maintenance, security, problem detection/resolution, and tuning of databases in a networked environment.
• Create and coordinate database backup and recovery plans, as well as minimizing data loss when a failure occurs.
• Perform database performance monitoring and implements efficiency improvements.
• Builds complex views, aggregation/indexing strategies, queries, and scripts to automate database functions and improve database performance.
• Oversee the execution of the direct mail program; analyzes direct mail and gaming data to assist in developing new products and marketing campaigns.
• Provide reports for analyzing response, cost and profit by segments.
• Develop and prepare financial and marketing queries and reports to be used to determine profitability and value of marketing programs.
• Ensure responsiveness to user needs and requests for services, and ensure system reliability and operating effectiveness.
• Manage all database marketing projects to ensure accuracy and integrity of all offers, customer lists and customer records.
• Evaluates and inputs all marketing customer list requests.
• Analyze the effectiveness of database marketing efforts and make recommendations.
• Assist in the development and execution of effective prospect and retention marketing programs for the casino.
• Keep leadership and other departments informed of status of database marketing activities by attending meetings and submitting reports.
• Maintain professional and technical knowledge by conducting research, attending seminars, educational workshops, classes and conferences; reviewing professional publications; establishing networks; participating in professional societies; conferring with representatives of contracting agencies and related organizations.
• Manage the development, design, execution, and analysis of our guests’ database marketing programs on all platforms.
• Responsible for analyzing the effectiveness of all marketing activities, creating and analyzing reports for tracking of business results and ensuring data integrity.
• Statically develop revenue generating programs for the Marketing division.
• Responsible for list management activities to include direct mail list requests, report requests and query requests.
• Analyze player revenue trends, using surveys and player frequency information.
• Inform management of new or existing postal rules or regulations and their impact on operations.
• Correspond with vendors, agencies and other departments as required to complete tasks and projects.
• Constantly and proactively seek out ways to improve all marketing database efforts.
• Assist in marketing coordination throughout the property as needed.
• Coach and develop Team Members in the Database department.
• Position involves supervision and evaluation of subordinates for all database related positions.
Qualifications:
Required:
• Requires Bachelors in Data Science, Statistics, Mathematics, Analytics, or related field
• 2 years experience in the job offered, or related
• 2 years of hands-on experience in database marketing and data analysis in a casino or gaming environment with deep understanding of slot and table games operations, loyalty programs, and player tracking systems
• 2 years must also include experience with Python for data preprocessing, modeling and analysis and automating reporting workflows, including scheduled data pulls
• MySQL 4.1 database administration
• Information systems technologies, applications principles and capabilities to include: data networking and processing, IS security processes and methodologies, computer operations, and enterprise software applications
• Integrating Python with Excel, PDF reporting and email automation (e.g., smtplib, Outlook API) to streamline distribution of property-wide analytics
• Planning, organizing and coordinating information technologies and prioritizing work activities in accordance with established goals and objectives
• Analyzing problems, projecting consequences, identifying solutions, and implementing recommendations
• Dashboard/report development using Power BI, Tableau, or similar tools to support marketing, operations, and executive decision-making
• Preparing, reviewing, and analyzing operational, technical and financial reports
• SQL for querying large-scale casino databases (e.g., Oracle, SQL Server) and building data pipelines
• Database management
• Build and maintain automated scripts and ETL pipelines that support daily, weekly, and monthly casino performance reports with minimal manual intervention
• Introducing and implementing new methods and procedures to keep pace with rapid growth in the information services industry
• Managing projects according to established goals and objectives
• Identifying systems, operation, technical or applications problems and to initiate and recommend appropriate corrective actions
• Must be able to successfully pass a pre-employment drug/alcohol screen and background investigation
• Must be able to obtain and maintain gaming license
• Very minimal travel may be required (less than 5%) for conferences/training
Company:
Table Mountain Casino Resort provides gaming, dining, live entertainment, and event hosting with various guest services. Founded in 1987, the company is headquartered in California, USA, with a team of 501-1000 employees. The company is currently Late Stage.