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 experience Annual Bonus Annual Merit Increase Eligibility Comprehensive health benefits package 3 weeks of paid time off accrued during your first year 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, 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 coverage Other benefits include a free AAA Premier Membership, Health & Wellness Program, Health Concierge Service, and Short Term/Long Term Disability 8 Paid Holidays Hybrid Schedule 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. Job Category: Marketing Work from home or Remote positions primary residence must reside within the footprint that AAA Club Alliance Inc. operates. Our club is located in Washington DC and 13 states including Connecticut, Delaware, Indiana, Kansas, Kentucky, Maryland, New Jersey, Ohio, Oklahoma, Pennsylvania, South Dakota, Virginia, and West Virginia. AAA Club Alliance is the result of AAA Mid-Atlantic, AAA Allied Group, AAA Oklahoma/South Dakota, and AAA Ohio Automobile Club joining, now representing nearly six million members in 13 states and Washington, DC. We’ve created an environment where you can look forward to coming to work and interacting with compassionate people who enjoy what they do and love supporting their team. We’re dedicated to keeping our Associates fulfilled and helping them feel secure. With such a diversity of products and services, our Associates have the opportunity to fulfill customer needs while advancing their own career. So that leaves one question, are you ready to make a difference? Are you being referred to one of our roles? If so, ask your connection at AAA Club Alliance about our Employee Referral process! We recognize that you don’t stop being a parent, caretaker, pet owner, or student because you’re at work. We give our Associates the option to customize their experience in order to suit their individual needs and interests. We offer a wide array of benefits that give our Associates piece of mind– even after retirement. You can view our virtual benefit fair here. AAA Club Alliance complies with federal, state and local disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please direct your inquiries to jobs@aca.aaa.com.