Marketing Data Analyst
Company Name:
AAA Mid-Atlantic
PURPOSE:
The Marketing Data Analyst is a technical
position
, 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 SAS tool suite 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 follow a strict 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 process by building automated workflows that connect data retrieval, data cleansing, file delivery and confirmation communication as one process. The position 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).
Essential Functions: 75%
Level 1:
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.
Automate existing marketing campaigns by converting existing SQL queries into SAS Guide procedures.
Identify data gaps and new data sources to improve marketing effectiveness and to maximize the intended marketing audience.
Work with SQL/SAS Developer/Administrator 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.
Level 2:
All of the Level 1 requirements plus:
Design and build SAS Guide procedures that produce ongoing reporting to measure campaign effectiveness and operations performance.
Ensure marketing campaigns are designed to achieve measurable results that are statistically relevant.
Design and implement new business processes to enhance campaign management.
Identify and build trigger based dynamic marketing efforts for digital channels.
Build compelling campaign performance analysis and presentations designed to influence key stakeholders and improve marketing yield.
Provide ongoing thought leadership to improve customer relationship marketing and organizational capabilities to support and expand marketing opportunities.
OTHER DUTIES /
Responsibilities: 25%
Level 1:
Update and enhance business procedures manual.
Enhance existing campaign management business processes to support efficient campaign management and marketing.
Perform other duties as assigned.
Level 2:
All of the Level 1 requirements plus:
Manage and improve campaign management functions including client engagement, campaign design, data transfers, promotional history management and documentation.
Evaluate and recommend new technologies that drive campaign management and resource efficiency.
Support and mentor junior staff members to improve SQL/SAS efficiency, general knowledge of AAA Mid-Atlantic, marketing and influential presentation design.
job
Requirements
Requirements for Level 1:
Bachelor's Degree in Computational and Data Science, Economics, Math or BS degree in other field in combination with 3 years of experience, or the equivalent education, experience and certifications will be considered
3
years of experience working with relational data.
3
years of direct marketing experience.
3
years of experience using SAS Guide 4.1, 4.3 and 5.1.
2
years of experience in a direct SQL invocation environment.
BASE SAS or SQL MCTS Certifications preferred
Comprehensive knowledge of 2010 Microsoft Office Suite.
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.
Requirements for Level 2:
Bachelor's Degree in Computational and Data Science, Economics, Math or BS degree in other field in combination with 5 years of experience, or the equivalent education, experience and certifications will be considered
5
years of experience working with relational data
5
years of direct marketing experience.
5
years of experience using SAS Guide 4.1, 4.3 and 5.1.
3
years of experience in a direct SQL invocation environment.
BASE SAS or SQL MCTS Certifications and comprehensive knowledge of 2010 Microsoft Office Suite.
Ability to work and influence across levels of management, translating complex ideas and concepts into actionable recommendations for improvement.
Ability to lead high level campaign focused strategy sessions.
Excellent presentation skills and experience in management level presentations.
Ability to mentor other team members in the areas of Marketing Campaign strategy and list efficiency.
Estimated Salary: $20 to $28 per hour based on qualifications.
AAA Mid-Atlantic
PURPOSE:
The Marketing Data Analyst is a technical
position
, 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 SAS tool suite 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 follow a strict 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 process by building automated workflows that connect data retrieval, data cleansing, file delivery and confirmation communication as one process. The position 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).
Essential Functions: 75%
Level 1:
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.
Automate existing marketing campaigns by converting existing SQL queries into SAS Guide procedures.
Identify data gaps and new data sources to improve marketing effectiveness and to maximize the intended marketing audience.
Work with SQL/SAS Developer/Administrator 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.
Level 2:
All of the Level 1 requirements plus:
Design and build SAS Guide procedures that produce ongoing reporting to measure campaign effectiveness and operations performance.
Ensure marketing campaigns are designed to achieve measurable results that are statistically relevant.
Design and implement new business processes to enhance campaign management.
Identify and build trigger based dynamic marketing efforts for digital channels.
Build compelling campaign performance analysis and presentations designed to influence key stakeholders and improve marketing yield.
Provide ongoing thought leadership to improve customer relationship marketing and organizational capabilities to support and expand marketing opportunities.
OTHER DUTIES /
Responsibilities: 25%
Level 1:
Update and enhance business procedures manual.
Enhance existing campaign management business processes to support efficient campaign management and marketing.
Perform other duties as assigned.
Level 2:
All of the Level 1 requirements plus:
Manage and improve campaign management functions including client engagement, campaign design, data transfers, promotional history management and documentation.
Evaluate and recommend new technologies that drive campaign management and resource efficiency.
Support and mentor junior staff members to improve SQL/SAS efficiency, general knowledge of AAA Mid-Atlantic, marketing and influential presentation design.
job
Requirements
Requirements for Level 1:
Bachelor's Degree in Computational and Data Science, Economics, Math or BS degree in other field in combination with 3 years of experience, or the equivalent education, experience and certifications will be considered
3
years of experience working with relational data.
3
years of direct marketing experience.
3
years of experience using SAS Guide 4.1, 4.3 and 5.1.
2
years of experience in a direct SQL invocation environment.
BASE SAS or SQL MCTS Certifications preferred
Comprehensive knowledge of 2010 Microsoft Office Suite.
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.
Requirements for Level 2:
Bachelor's Degree in Computational and Data Science, Economics, Math or BS degree in other field in combination with 5 years of experience, or the equivalent education, experience and certifications will be considered
5
years of experience working with relational data
5
years of direct marketing experience.
5
years of experience using SAS Guide 4.1, 4.3 and 5.1.
3
years of experience in a direct SQL invocation environment.
BASE SAS or SQL MCTS Certifications and comprehensive knowledge of 2010 Microsoft Office Suite.
Ability to work and influence across levels of management, translating complex ideas and concepts into actionable recommendations for improvement.
Ability to lead high level campaign focused strategy sessions.
Excellent presentation skills and experience in management level presentations.
Ability to mentor other team members in the areas of Marketing Campaign strategy and list efficiency.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
