Job Overview

Company:
Group O
Title:
Campaign List Analyst
Skills:
Preferred 2+ years Campaign List generation experience; Intermediate SQL; data mining & data analysis; Moderate to advanced SQL coding/programming skills
Date Posted:
3-23-2017
Location:
san antonio, TX
Area Code:
210
Employ. Type:
FULLTIME
Pay Rate:
Negotiable
Job Length:
Position ID:
474454
Dice ID:
10125042
Travel Required:
none
Telecommute:
no

Contact Information

Contact:
Travis Stroud
Save this job
Printer-Friendly

Job Description

  • Campaign List Analyst
  • san antonio, TX

Group O is searching for a Campaign List Analyst to join its growing team! This position is primarily responsible for management of strategic requirements in the context of data/ technical capabilities. This person will create design for customer selection in regards to direct marketing and campaign lists.

 

Responsibilities include but are not limited to:

·         Adeptly facilitate meetings to capture requirements

·         Provide recommendations to assist with the design and development of the targeted marketing request and campaigns.

·         Create use cases and test scenarios as needed to communicate the approach and validate the solution.

·         Develop functional specifications and system design specifications in conjunction with marketing, legal and other consultative roles.

·         Assist in timeline/schedule enforcement, testing strategies, and issue tracking.

·         Moderate to advanced SQL coding skills, to understand Unica backend processing & for troubleshooting and analysis

Requirements:

·         Ability to write/run SQL queries in a large database environment for on demand investigations

·         Understands complex coding processes, i.e. Joins, Aggregating Data, Building Temp Tables, Formatting Data, and Import & Export Processes) to pull the correct data for analysis.

·         ETL (Extract, Transfer & Load) processing preferred

·         Understanding of aggregating data using complex SQL code. i.e., using functions such as SUM, COUNT, CASE statements, etc.

·         Experience in a List Management or generation: can work well with business clients to gather requirements and successfully translate requirements into code

·         Ability to work independently with a focus on detail and can work on several projects at the same time.

·         We want candidates to be able to work independently and can think outside the box and loves to solve problems.

·         Bachelor’s Degree/Equivalent, or 3-5 years related experience.

Desired Skills:

·         Manage campaign workflows using Aprimo Enterprise or related software

·         Prefer 2+ years' experience in IBM Campaign/Unica - Creating campaign target designs using Affinium Campaign, or related software

·         Experience using Crystal Reports - Business Objects- PeopleSoft, or related software...

·         At least one year experience in campaign management or list generation for marketing is a plus

·         Ability and drive to do data research on questions without receiving specific directions

·         Preferred experience in CRM or direct marketing, and have a strong aptitude for program management.

·         Demonstrated strong analytic and fact-based decision-making skills, especially as related to CRM campaign design.

·         Possess outstanding computer skills and be proficient using Microsoft Office products including Outlook, Word, PowerPoint and Excel.

·         Excellent communication and relationship building skills.

·         Must be self-motivated and capable of working with minimal supervision in a highly-matrixes organization.



 GREAT OPPORTUNITY, PAY,  AND BENEFITS!

Save this job