Club Compliance Data Analyst II

Role Overview

• Analyze booking trends and benefit usage across accounts to identify trends, unapproved collaborations, or rule violations
• Collaborate with business unit leaders and specialized departments such as Legal, Club, Operations, Title Services, and HR to determine thresholds and successfully investigate all Club, Legal, or Compliance potential violations
• Lead process evaluations and identify opportunities to improve efficiencies
• Follow up on outstanding action points within an agreed-upon timetable and ensure all issues are closed in a timely manner
• Monitor all issues identified during the analysis and investigation process
• Develop controls to mitigate future risk
• Collaborate with Legal, Club and HR to evaluate controls related to Point Utilization, Booking Trends, Contact Center Operations, Sales and Marketing, and 3rd Party Activity
• Formulate recommendations to improve internal control processes and other value-added opportunities
• Creating reports and developing tools and processes to automate reports
• Analyzing large amounts of data relating to sales, customers, or financial performance
• Using Structured Query Language (SQL) and other coding languages to extract data
• Aligning reports to business objectives and key performance indicators
• Collaborating with other business areas and leaders to identify reporting needs
• Accessing existing databases and creating processes for storage of new data
• Identify operational or financial variances and develop and implement forecast models for planning and control
• Perform other duties as needed

Requirements

• Bachelor’s degree in MIS, IS, IT or Business, or equivalent work experience
• One to three years of experience in Contact Center/Customer Operations
• Designing automation and data connections using Power Apps, SharePoint, SQL, SAS, Power BI, Python, Excel, Tableau, Visual Basic
• Proven ability to sustain performance and take on new work with little to no supervision
• Excellent business writing and oral communication skills
• Ability to write owner facing documents and scripts
• Ability to create training guides and standard operation procedures
• Ability to prioritize and track multiple projects and deadlines throughout the work week
• Enjoys attention to details.
• Working knowledge of Microsoft Office Suite (i.e., Office 365, Word, Excel, Access, Teams, SharePoint, PowerPoint)
• Working knowledge of Visual Basic, Power Automate, Power Apps, Power BI, Snowflake or similar SQL DB Tools
• Working knowledge of most if not all Club systems

Tech Stack

• Python
• SQL
• Tableau

Benefits

• Medical
• Dental
• Vision
• Flexible spending accounts
• Life and accident coverage
• Disability
• Depending on position, paid time off, parental leave and holidays
• Wish day paid time to volunteer at an approved organization of your choice
• 401k with employer match (subject to eligibility requirements, including tenure)
• Legal and identify theft plan
• Voluntary income protection benefits
• Wellness program (subject to provider availability)
• Employee Assistance Program