Marketing Analyst

Job type:
on-site
Start:
n.a
Duration:
n.a
From:
Synectics
Place:
New Jersey
Date:
05/29/2012
Country:
flag_no USA
project ID:
369490

Warning
This project is archived and not active any more.
You will find vacant projects in our project database.
Digital Marketing Analytics Analyst

Responsibilities:
  • Develop and run ad-hoc and recurrent reports leveraging a number of internal and external data sources and using the tools that may include: Oracle SQL, Netezza SQL, Business Objects, MS Access with ODBC links to Datawarehouse, Excel (pivot tables, macros and basic VB Scripts)
  • Create & and Automate recurring reports
  • Analyze data and trends to assess the effectiveness of digital marketing efforts
  • Design and execute measurement plans for Marketing campaigns

    The candidate will understand business objectives and be able to continuously analyze data to identify issues and make actionable recommendations. He/she must have the ability to multi-task in a fast-paced, dynamic environment, handling changing priorities.

    Job Description:
    1. Will be able to understand SQL (complex queries, multiple joins, sub-queries, distinct and simple counts in one query)
    2. An understanding of BO (or Cognos, or Microstrategy) user interfaces and the ability to create simple queries (from analytics viewpoint) in BO. No special understanding of Universes etc. is required
    3. An understanding of online analytics, weblogs, parsing, URLs, Unique Visitors, Page Views, Downloads, Form Submissions
    4. Fluent in managing XL files, with VB and/or macros
    5. Understanding of Access databases
    6. Very basic understanding of any type of Datawarehouse (Oracle, SQL Server, Terradata, Netezza)
    7. Experience with Web analytics KPIs, Funnels, Journey/Click-stream Reports

    SKILLS

    Tools including Business Objects, or Cognos, or Mi, SQL (Oracle or Netezza or Teradata), Microsoft Excel, Macros, Pivot Tables, Microsoft Access, WebTrends, PowerPoint, Online Marketing Experience, Communication Skills

    Synectics is an Equal Opportunity Employer.

  •