MARKETING DATABASE INTERN (UNPAID) (marina / cow hollow)

In 2006, the Online Marketing Summit (OMS) was created in order to connect marketers to the online marketing information they need to be successful. OMS was and still is the only live event that brings brand marketers together to focus solely on education. Because of the success of OMS and the high demand for marketing education, co-founders Aaron Kahlow and Mike Angiletta teamed up in 2008 to form Online Marketing Connect (OMC) in order to expand on the original mission.

OMC provides education and marketing information across a variety of channels in order to give marketing professionals, consultants and students the opportunity to learn both inside and outside of an event setting. The Online Marketing Institute (OMI) became the next step. OMI offers a more intensive focus on education where people can learn about online marketing at their own pace through workshops, webinars and online learning channels. It provides certification within various fields of online marketing through a curriculum of case studies, best practices, peer validation, and trends analysis.
Since the creation of OMC, the Summit has expanded to include new workshops, networking events and one-on-one labs; and the Institute has more than 5,000 students and graduates. Marketers all over the world are connecting to high quality and relevant online marketing tools, peers and knowledge through OMC.

OMC is currently seeking a Marketing Database Intern (unpaid). EOE.

PURPOSE OF THE JOB: (State briefly the principal purpose of the job and its major objective.)

Maintain in-house prospect and retention database. Manage the integration and cleansing of data between multiple disparate databases (including Salesforce, ExactTarget, Sales, Sponsors and Partners).

ORGANIZATIONAL RELATIONSHIP: (Define where the job is positioned organizationally using job titles and number of positions; identify by title and briefly describe the major function(s) of direct reports.)

The Marketing Database Intern works closely with all departments (including Sales, Event Planning, Marketing, Operations, Creative, Editorial and Content, Educational Services, etc.) to help them maintain and develop reliable prospect and retention database(s). The Marketing Database Intern also works closely with the virtual Web/IT team. This role also includes de-duping list(s) before new prospect or retention marketing mailings are sent out and ensuring that data is integrated and synchronized across all channels.

ACCOUNTABILITIES: (Describe the functions for which this job is held accountable by describing those activities and why they are performed. Indicate which activities are considered "essential" and the percentage of time spent for all functions - total should equal 100%.)

Marketing Database Intern

1. 35% Clean and maintain in-house database(s), including acquisition of information.
a. Upfront extensive need for cleaning databases and implementing data policies and procedures
b. Build demographic profiles for fulfillment and prospect lists
c. Ensuring synchronization between all databases via unique customer id
d. Create List Policies and Procedures for customer service data entry and list importing methodology. Enforcing these polices to ensure they are met.
e. Analyzing how data relates with current business processes (e.g., Web/IT, Sales, Marketing, etc.)
f. Integrate databases with one another (e.g., Salesforce, ExactTarget, Sales, Partners/Sponsors, etc.)
g. Clean, build and maintain our databases “from the ground up.” Identify ways to improve current procedures and processes and maintain data hygiene.
h. Investigate and fix data anomalies.
i. Data entry is required.

2. 15% Work with Sales and Marketing, prospect, and fulfillment lists, integrating new and/or changing information. Ensuring consistency among all in-house lists.

3. 25% Pull in-house list submissions and collect outside lists (as acquired from Sales and Marketing). Lists are to be prepared for marketing efforts:

a. Merge/purge lists
b. De-dupe lists
c. Determine list or data quantities and communicate to Sales and Marketing in a timely fashion
d. Work with Sales and Marketing to finalize quantities
e. Apply source codes to each individual list to track effectiveness
f. Prepare list(s) for email, mail house and fulfillment vendors; files in proper format, etc.
g. Extracting, manipulating and aggregating customer data in an effort to execute the strategic marketing segmentation strategy as well as Sales and Marketing campaigns.
h. Investigating data anomalies to determine if they will impact the segmentation strategy selected
i. Ensuring that the quality assurance (QA) process is properly executed and followed.

4. 10% Maintain a “bad address” file and “do not mail/call/fax/email” file. De-dupe this file from all mailings. Ensure “bad addresses” are cleaned up within our email marketing vendor and CRM tools.

5. 5% Regularly update fulfillment and prospects files from mail returns as well as NCOA (National Change of Address) revisions to update the database with customers who have moved.

6. 10% Maintain list histories for all promotions:

a. Itemized list selections for each promotion, includes list name, priority, quantity and source codes (e.g., tracking/discount/promotional).
b. Establishing an organized data structure for storing extracted data.


KNOWLEDGE, SKILL AND EXPERIENCE: (Indicate the minimum requirements (or equivalencies) to perform the functions of the job.)

Have expertise in database software including, but not limited to Access. 1+ year of basic knowledge of SQL and 1+ year of relational database experience. Experience with Salesforce.com and ExactTarget a plus. Experience in Marketing, IT, or related disciplines preferred. Advanced working knowledge of Excel a must. Merge/purge and mailer/emailers’ software a plus. Experience in a Sales or Marketing environment also a plus.

Reply to: jobs@onlinemarketingconnect.com

Posted By: Meredith Lynch