Systems/Data Analyst - Highly Skilled

Orlando, FL

Post Date: 07/25/2017 Job ID: 24287 Industry: Other Area(s)

JOB SUMMARY: 

Build views for new campaign platform and validate that said views are correct.  Implement quality checks and quality control measures for data to be used in new campaign platform. Supports analytics team through implementation of SQL and other structured data queries.  Partners with the Information Technology team to ensure best-of-class data management, analytics and reporting.  Leads development of procedures, views, and back-end database logic supporting Analytics group needs in ad hoc as well as ongoing analytics projects. 

 

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Develop data extract and analysis routines using SQL & Excel to support CRM and Analytics teams

Build and validate views to support new Campaign platform. Implement Q.C. measures to ensure views and data are correct.

Develop, enhance and update Unica flowcharts and underlying data access logic to support CRM team campaign implementations

 

QUALIFICATIONS:
  • Experience with SQL and Relational Databases (expert);
    • Must have thorough understanding of database structure;
    • Experience creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports; analysis reports, etc.
    • Working knowledge of databases including writing SQL queries required.
  • Experience with Hadoop (intermediate to advanced)
  • Experience with Paxata (preferred)
  • Excellent analytical skills with past experience in email and/or database marketing analysis;
  • Experience with Unica or other campaign management system preferred
  • Experience with Microsoft Excel (advanced):
    • Must be able to develop and understand advanced Microsoft Excel spreadsheets.
  • Ability to work independently in a deadline oriented environment;
  • Experience in troubleshooting and resolving problems;
  • Ability to evaluate quantitative data sets and determine “ big picture” implications required;
  • Working knowledge of marketing, media and marketing customer data required;
Apply Online

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: