• Campaign Analyst

    Job Locations US-TX-San Antonio | US-CA-El Segundo
    Job ID
    2018-1893
    Category
    Information Technology
    Division
    Business Analytics
  • Overview

    Group O is searching for a Campaign 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

    • 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/IMDM backend processing & for troubleshooting

    Qualifications

    • Ability to write/run SQL queries in a large database environment on demand for investigations
    • Must be a strong SQL Coder with Data Mining Skills (Understands complex coding processes, i.e. Joins, Aggregating Data, Building Temp Tables, Formatting Data, and Import & Export Processes).
    • ETL (Extract, Transfer & Load) processing preferred
    • Expert knowledge of aggregating data using complex SQL code.i.e., using functions such as SUM, COUNT, CASE statements, etc.
    • 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. 
    • Manage campaign workflows using Aprimo Enterprise 8.0
    • Crystal Reports - Business Objects- PeopleSoft, ETC... 
    • Ability and drive to do data research on questions without receiving specific directions
    • Background 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-matrixed organization.

    Experience:

    • 2+ years' experience in IBM Campaign/Unica - Creating campaign target designsusing Affinium Campaign, version 8.2 or related software
    • Experience in a List Management or generation: can work well with business clients to gather requirements and successfully translate requirements into code
    • At least one year experience in campaign management or list generation for marketing

    Education:

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

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.