Membership Data Analyst

Role Overview

• Perform statistical analysis to identify variances, trends, and correlations in the areas of member demographics, purchasing behaviors, product utilization, membership penetration and audience retention rates.
• Develop target audience models for membership acquisition and salvage campaigns based on data findings.
• Assist in the membership budget planning, forecasting and reporting process.
• Prepare narrative reports, charts, and illustrations that focus on key metrics such as member retention, attrition, promotion response, usage behaviors and trends.
• Analyze membership data on a daily, weekly, monthly, quarterly and annual basis to identify trends in new and renewal performance across all sales channels.
• Assess trends in membership renewal to reevaluate renewal program as needed.
• Compile and analyze direct mail results to measure effectiveness.
• Report findings, including recommendations, to senior leadership.
• Study data to identify areas of improvement for leadership decision-making; draw conclusions and make recommendations based on analysis from multiple data sources.
• Provide analytical support on a project basis to other business areas such as marketing to create and support membership acquisition and retention campaigns.
• Ensure metrics are accurate by analyzing data and processes for anomalies and or data/quality issues.
• Identify and resolve by coordinating with the appropriate business area (i.e. membership operations, customer experience CRM, etc.) regarding the source data.
• Develop, schedule and oversee delivery of daily, weekly, monthly, quarterly and annual results and deliverables to satisfy executive leadership membership report needs.
• Create and maintain process documentation, policies and procedures.
• Protect and strengthen the AAA brand.
• Perform other duties as assigned.

Requirements

• Bachelor’s degree in Information Management, Mathematics, Economies, Statistics, or related field preferred.
• Minimum 3+ years of experience as a data analyst.
• Strong analytical, problem solving and decision-making skills.
• Budget planning, forecasting and report building experience.
• Excellent communication and presentation skills.
• Proficiency with SQL, Microsoft Office applications or other business intelligence applications is required.
• Experience with a visualization tool such as Tableau or Power BI is helpful but not required.
• Knowledge of statistical analysis techniques required.
• Ability to apply, transform, communicate and present statistical knowledge that can be clearly understood by various business lines.
• Ability to analyze reports and provide insights and trends to assist in the development of business plans to drive membership growth and retention.
• Must be able to work independently.
• May be required to travel to out-of-state conferences or meetings on an as needed basis.

Tech Stack

• SQL
• Tableau

Benefits

• Comprehensive health benefits package.
• Up to three weeks of paid time off accrued during your first year.
• Annual Bonus Plan.
• 401(K) plan with company match up to 7%.
• Professional development opportunities and tuition reimbursement.
• Paid time off to volunteer & company-sponsored volunteer events throughout the year.
• Other benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, Health & Life Insurance, Short Term/Long Term Disability.
• Full time Associates are offered a comprehensive benefits package that includes: Medical, Dental, and Vision plan options.
• Up to 2 weeks Paid parental leave.
• 401k plan with company match up to 7%.
• 2+ weeks of PTO within your first year.
• Paid company holidays.
• Company provided volunteer opportunities + 1 volunteer day per year.
• Free AAA Membership.
• Continual learning reimbursement up to $5,250 per year.