Marketing Data Analyst

AAA Club Alliance is hiring a Marketing Data Analyst to join our Marketing Technology team!

This role 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 Analyst will use the Google Cloud Platform (GCP) BigQuery and Microsoft Power BI tools to access data about our customers. The information may be transactional (purchases, bookings, etc.), demographic (age, income, etc.) or activity based (web usage, emails opened, etc.). This position will support monthly, weekly and sometimes daily schedule of providing lead lists to our internal clients based on the acquired data.

What we can offer you:A competitive salary commensurate with experienceAnnual Bonus + Annual Merit Increase EligibilityComprehensive health benefits package3+ weeks of paid time off accrued during your first year401(K) plan with company match up to 7%Professional development opportunities and tuition reimbursementPaid time off to volunteer & company-sponsored volunteer events throughout the yearOther benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, Life Insurance and Short Term/Long Term Disability

What You'll Do: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, Social, 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 SQL queries into GCP BigQuery and SQL Server stored procedures.Identify data gaps and new data sources to improve marketing effectiveness and to maximize the intended marketing audience.Work with SQL/Adobe Campaign Developer/Administrator/IT Team 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 team process and procedures.Enhance existing campaign management business processes to support efficient campaign management and marketing across multiple business lines.Other duties as assigned. Minimum Qualifications:Bachelor’s Degree in Computational and Data Science, Data Analytics, Economics, or Math; or BS degree in other field in combination with additional experience; equivalent education, experience and certifications will be considered.Comprehensive knowledge of 2016 Microsoft Office Suite.2+ years of experience working with relational data.2+ years of direct marketing experience.2+ years of experience using Adobe Campaign; SAS eGuide 4.1, 4.3 and 5.1 experience a plus.3+ years of experience programming in SQL. Google Cloud Platform (GCP) BigQuery experience combined with Microsoft SQL Server or commensurate experience preferred.2+ years of experience using Microsoft Power BI.Ability to work independently in fast paced environment with competing priorities, excellent oral and written communication skills and the ability to interpret end-user needs. To the qualified candidate, we can offer: Medical, Dental, Vision and Prescription coverageOther benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, and Short Term/Long Term Disability8 Paid HolidaysHybrid SchedulePaid time off to volunteerProfessional development opportunities and tuition reimbursementTuition reimbursement401(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.