S&M Marketing Data Analyst

Job Title: Marketing Data Analyst
Department: Sales and Marketing
Supervisor: Marketing Director
FLSA Class. / Job Class. / Job Grade: Exempt / A / Salary
Job Code: 652220
Date Approved/Revised: HR 02/28/2025 GAMING APPROVED: 03/14/2025
Job Summary: This position is responsible for maintaining data warehouse and be able to produce analytical reports utilizing a variety of reporting tools/programs for the Meskwaki Bingo Casino Hotel marketing department and other departments as requested. Responsible for creating and maintaining databases to track key metrics, conducting market research, and collaborating with cross-functional teams to optimize campaigns. Responsible for producing reports and visualizations to communicate data insights to stakeholders and staying up to date with emerging trends and technologies in marketing analytics.
Essential Job Duties:
1. Provide outstanding customer service to guests and all other employees by exceeding our mission statement.
2. Understand analytical reporting, working knowledge of Customer Relationship management software, QCI, query language on the SQL and database management required.
3. Analyze pertinent information and present findings with a recommendation for improvement, including ROI increases.
4. Ability to create ad-hoc reporting for the operating departments utilizing various reporting software packages.
5. Ability to analyze data and to produce clean files.
6. Ability to assist in report writing/modification.
7. Maintain confidentiality of information.
8. Ability to troubleshoot areas, place service calls and keep management informed of critical situations.
9. Create Pre and Post Formas when required. … recommend edit: Design and development of all database analytics and compile pro and post forma analysis for all marketing campaigns, events, and promotions.
10. Maintain office integrity.
11. Complete production and special assignments as required.
12. Ensure compliance with all Minimum Internal Control Standards (MICS) as well as all Tribal Internal Control Standards (TICS).
13. Maintain on-going communications with MIS for maintaining databases and extracting appropriate reporting data.
14. Communicates and networks effectively with staff, other departments, and outside representatives to maintain a productive and effective department operation.
15. Safeguard and account for the assets of the owners.
16. Comply with policies and procedures required by the department, the company, the Meskwaki Gaming Commission, and the National Indian Gaming Commission.
17. Monitor the casino environment and follow established safety procedures to provide for the safety of guests and co-workers.
18. Work respectfully and effectively as part of the company team to ensure guest satisfaction, asset protection, and co-worker respect.
19. Report to work on time and as required in casual professional attire, display an elevated level of personal cleanliness and follow personal appearance standards.
20. Comply with all departmental safety regulations, using safety equipment as required.
Supplemental Job Duties
1. Assist in the creation of an annual direct mail marketing plan and budget in accordance with Meskwaki guidelines.
2. Stay within budget and communicate variances during monthly reviews with the Director of Marketing.
3. To foster teamwork, all Marketing team members are required to provide positive support of all co-workers, management, guests, and the company daily.
4. Attends all required meetings and training sessions.
5. Performs other job-related duties as assigned.
Supervisory Responsibilities: This position does not require supervisory duties. This position has the authority through proper channels, to procure any supplies and or equipment needed for the operation of the department.
Physical Requirements/Working Conditions: Ability to maneuver in all areas of casino, ascent/descent from stairs, frequent standing, walking, sitting, reaching, stooping, kneeling, or crouching, and/or prolonged periods of time focusing on tasks. Ability to lift at least 25 lbs. May regularly need to lift/ move, push or pull up material or boxes necessary to the job functions, with or without assistance. Be able to work in a smoking environment with loud and continual noise levels for extended periods of time.
Specific vision ability includes close vision, distance vision, color vision, peripheral vision, and depth perception. Visual acuity to discern and examine text, graphics, color, and symmetry. Speech to communicate clearly, express ideas and convey information in an understandable manner. Ability to hear for listening comprehension and to understand ideas presented through spoken words and sentences. Manual dexterity to operate office or required equipment and examine or update documents, records, data, instructions, logs, and files.
Social perceptiveness to assess and understand other’s reactions and behavior. Critical thinking to use logic and reasoning, reach conclusions/solutions. Comprehension in assessing, analyzing, and processing alpha, numeric, and visual data and completing required tasks or documents accurately. Ability to tolerate stress and conduct tasks under critical deadlines. Ability to concentrate on tasks over a period of time without being distracted.
Minimum Job Qualifications:
Knowledge/Education/Work Experiences: Bachelor’s degree in marketing, Data Science, Business, or related field. (Six (6) years of progressive casino marketing experience may be substituted for education requirement.) Two (2) years of progressive casino marketing or related field experience. Must have one (1) year of demonstrable casino/marketing analysis work, producing high level reports and recommendations. Advanced demonstrable knowledge of Microsoft Word, Excel, and Access, SQL or other data analysis/reporting tools required. Oasis Super Playmate and/or other casino player tracking experience preferred. Must be 21 years of age or older. Valid Iowa Driver license and be insurable under MBCH’s policy. Must be able to obtain a gaming license in accordance with the regulations established by the Sac & Fox Gaming Commission.
Skills/Abilities: Good oral and written English communication skills. Ability to interact and respond calmly in various situations with co-workers, guests, and vendors. Provide departmental support and guidance to ensure the marketing team’s success. Serve as an inspirational leader for team members while fostering teamwork, positive morale, motivation, and open communications. Must be highly organized and effectively manage time and be able to perform multiple tasks simultaneously. Re-prioritize tactics and strategies to achieve goals and objectives in dynamic market conditions. Must be able to work any day of the week and any shift with little to no supervision. Strong oral and written communication skills including public speaking. Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Must be able to read, write, and speak English. Ability to read, write, and speak Spanish a plus. Must be able to meet all internal training, professional development, and education requirements. Must have well-developed financial analysis and management skills.
Preference: Members of the Meskwaki Nation and other Native American Tribes who are qualified applicants are encouraged to apply and will be given preference in accordance with established procedures.
Restrictions: This position is PROHIBITED from playing all casino games while on duty, except as authorized for employee tournaments. Otherwise, this position may play any casino game while off duty. Employees and members of the household are prohibited from entering company contests and giveaways established for our guests.
Acknowledgment: Employee Signature \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Date: \_\_\_\_/\_\_\_\_/\_\_\_\_