Membership Data Analyst

Jobtailor; Wilmington (OH); On-site; USD 70,000 - 95,000; Full time

Job summary

Jobtailor in Wilmington, OH seeks a Data Analyst to transform member demographics, purchasing behavior, and utilization data into actionable insights. You will build audience models for acquisition and retention, assist in budgeting and forecasting, and craft narratives and visuals for leadership.

The role requires strong SQL and BI tooling skills, plus the ability to communicate complex analyses clearly. Travel to conferences may be required as needed.

Qualifications

• Minimum 3+ years of experience as a data analyst.
• Proficiency with SQL and Microsoft Office or BI tools.
• Experience with a visualization tool such as Tableau or Power BI is helpful.
• Knowledge of statistical analysis techniques.
• Ability to communicate insights to non-technical teams.

Responsibilities

• Perform statistical analysis to identify variances, trends, and correlations in 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 focusing on 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 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.

Skills

SQL

Excel / MS Office

Statistical analysis

Data storytelling

Problem solving

Independent work

Education

Bachelor's degree in Information Management / Mathematics / Economies / Statistics

Tools

Tableau

Power BI

SQL Server / BI tools

Job description

Responsibilities

• 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.