AAA Club Alliance is seeking a Data Analyst for our Membership Intelligence line of business. The analyst is responsible for retrieving, joining, cleaning and displaying marketing data for the purpose of generating marketing lead lists and for the presentation of marketing data analysis.
The Data Analyst will also be responsible for automating marketing production processes by building automated workflows that connect data retrieval, data cleansing, file delivery and confirmation communication as one process.
Primary Duties:
Develop opportunities to optimize marketing campaigns by partnering with key business stakeholders to design effective targeting and segmentation strategies that maximize ROI in the following channels: Direct Mail, Email, Telemarketing, Text, and Web.
Design and build processes to execute and automate campaign strategies.
Create data mining architectures/models/protocols, statistical reporting, and data analysis methodologies to identify trends in large data sets.
Capture and mine data to identify customers most likely to respond to various direct marketing messages.
Perform statistical analysis/modelling to generate lists of customers for targeted direct marketing campaigns.
Automate existing marketing campaigns by converting existing SAS queries into the Adobe Campaign Management tool.
Identify data gaps and new data sources to improve marketing effectiveness and to maximize the intended marketing audience.
Work with SQL/Big Query to integrate and test new data sources.
Use data management tools to standardize customer contact information to improve delivery rates, campaign performance and analysis opportunities.
Use data transfer tools to encrypt, compress, and secure data files that are shared and received with 3rd party providers.
Update and enhance business procedures manual.
Enhance existing campaign management business processes to support efficient campaign management and marketing.
Minimum Qualifications:
Bachelor's Degree in Computational and Data Science, Economics, or Math; or BS degree in other field in combination with additional experience; equivalent education, experience and certifications will be considered.
SQL MCTS or BASE SAS Certifications preferred.
Comprehensive knowledge of 2010 Microsoft Office Suite.
2+ years of experience working with relational data.
2+ years of direct marketing experience.
3+ years of experience programming in SQL/Big Query.
2+ years of experience using SAS Guide 4.1, 4.3 and 5.1.
2+ years of experience using Power BI and/or Python.
Experience with Adobe Campaign Management tools a plus.
To the qualified candidate, we offer:
Medical, Dental, Vision and Prescription coverage
Other benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, and Short Term/Long Term Disability
8 Paid Holidays
Paid time off to volunteer
Professional development opportunities and tuition reimbursement
Tuition reimbursement
401(K) plan with company match up to 7%
AAA Club Alliance (ACA) is an equal opportunity employer.
Our investment in Diversity, Equity, and Inclusion:
At ACA, we are committed to cultivating a welcoming and inclusive workplace of team members with diverse backgrounds and experiences to enable us to meet our goals and support our values while serving our Members and customers. We strive to attract and retain candidates with a passion for their work and we encourage all qualified individuals, regardless of race, color, gender, identity, veteran status, sexual orientation, physical ability or national origin, to apply.