Marketing Campaign Developer / Analyst
Primary Skills: Administration and support of IBM EMM product suite version 9 (or higher) or IBM Unica Campaign version 8.5 (or higher Description: Detailed JD The high level responsibilities for the position include working directly with the business unit on the activities related to the successful execution of consumer marketing campaigns: Administration and support of IBM/EMM Data research and analysis (Writing complex SQL, PL/​SQL (stored procedures/​functions) with Oracle 11g or higher).​ Campaign design development, testing, execution, QA, and support Adhoc data loads Problem analysis and solving Handling campaign response data, customer contact history, and customer preferences Consulting / Training with Honda’s campaign partners Ideal Candidate: 5+ years working in marketing campaign area Able to work in a dynamic environment Able to work closely with the core team members (business and technical) to understand customer data used for marketing and to provide comprehensive data services.
Experience with processes to develop marketing campaigns to specifications Able to understand business requirements and translate into the solution Able to assess business, data & technical needs, and communicate back to the team gaps, risks and/or assumptions identified. Strong communications skills with business customers Strong in documentation of designs and processes. Be responsible for multiple projects and for meeting challenging deadlines.
Effective with planning and organizing assigned work Able to adhere to defined process Problem analysis, solving and implementing appropriate counter measures Strives for continued process improvement and efficiencies Technical Experience with IBM EMM v9.x or IBM-Unica Campaign v8.5 (or higher) Experience writing / understanding complex SQL, PL/​SQL (stored procedures/​functions) with Oracle 11g or higher.​ Experience writing and implementing unit test plans and quality assurance plans.​ Experience using UNIX command language to view and ftp files.​ Experience implementing error handling and data quality rules Experience working with large data bases (+2 terabytes, tables with +2 billion records).
Responsibilities: The candidate will be responsible for the following: Campaign Support: Administration and support of IBM EMM product suite version 9 (or higher) or IBM Unica Campaign version 8.5 (or higher) Campaign Management fundamentals including, customer suppressions, preferences, mail list processing and merge purge Production support (24x7) Production system monitoring Development of campaigns and quality control reviews with business partners (campaign planners and business units) Gather and document requirements from the business (and other teams) related to marketing campaigns (primarily email marketing).
Translate business requirements into technical specs. Create standards for requirements gathering templates, campaign nomenclature and folder structure. The design, development, QA, schedule and run campaigns in IBM EMM. Perform quality assurance testing against campaigns developed by other team members. Learn and understand the Marketing Database data model and data elements thoroughly Identify and report production issues and follow them through to resolution.
Work closely with ESP deployment resource(s) to align IBM EMM output to the correct ESP template. Work with other teams for non-email campaigns. Use tools like SQL developer to run ad hoc data analyses against Oracle databases Create both one-off and recurring campaigns; both simple and complex logic. Measurement Mand/Pref Data Analysis Oracle Database: Strong SQL skills: solid understanding of SQL (subqueries, minus/union, inline queries, etc.) Strong PL/SQL, SQL query, SQL DML (Data Manipulation Language) and relational database design skills.
Research of customer data used for marketing campaigns 5+years Mandatory Campaign Management • Knowledge and understanding of the IBM EMM (UNICA) campaign development tool · Architecting, designing, and presenting “integrated solutions” • Installation and configuration of IBM EMM applications on supported OS and J2EE platforms (Windows, Unix (including Linux), Weblogic, and Websphere) · Integration of IBM EMM applications with 3rd party components (e.g., SSO, LDAP, SSL, scheduling software) · Integrating IBM EMM applications with websites and other touch point systems using API calls via Java Serial Objects and/or Web service (SOAP/XML) implementations · Integrating IBM EMM applications with supported Oracle database platform.
· Meeting additional project automation requirements by providing design, development and testing of standard code using toolkits and scripting languages (e.g., IBM EMM macros and utilities, UNIX shell, Perl, and DOS batch commands) · Providing documentation, and continuous communication to project team on general status, roadblocks, and progress toward goals · Providing input into new product functionality and future direction of the product based on customer and prospect interactions 2+ years Preferred Unix and shell scripting · AIX 6.X: Experience working with Unix OS systems/servers, implemented and maintained IBM Unica Campaign on Unix.
Experience developing and supporting shell scripting. 3+ years Microsoft Office EXCEL Word Access Project Qualifications and Experience: · Bachelor's degree in Marketing or Computer Science or related discipline, or have equivalent experience. · Business and technical understanding of Marketing and CRM solution components including Internet marketing, email, and direct mail. · Strong Linux/Unix skills · Creative thinker, advanced problem solver 5+ years Mandatory · Understanding of Automotive, Marketing, and Customer Analysis.
· Understanding of “Can-Spam” regulations · Background with campaign marketing concepts · Email campaign optimization and segmentation · Unica Campaign Management Module knowledge/experience