You are viewing a preview of this job. Log in or register to view more details about this job.

Marketing Data Analyst

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

Position Summary:

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. 

This position 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.  In addition, this role will also be responsible for using marketing data to present information on marketing campaign results by joining campaign and lead information to information regarding purchases.  As a result of this analysis, the Analyst will make recommendations to our internal business line clients with respect to targeting specific groups (segmentation).

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.

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.