About Shopko


Founded in 1962 and headquartered in Green Bay, Wisconsin, Shopko Stores Operating Co., LLC operates 363 stores in 24 states throughout the Central, Western and Pacific Northwest regions. Retail formats include 131 Shopko stores, providing quality name-brand merchandise, great values, pharmacy and optical services in small to mid-sized cities; 5 Shopko Express Rx stores, a convenient neighborhood drugstore concept; 5 Shopko Pharmacy locations; and 222 Shopko Hometown stores, a smaller concept store developed to meet the needs of smaller communities.




United States

Postal Code:


Approximate Salary:

Not Specified

Direct Marketing Campaign Analyst

Shopko - Green Bay, Wisconsin

Posted: 12/11/2018

External Job Posting

The Direct Marketing Campaign Analyst will design, document and execute targeted marketing (direct mail, email, and mobile) campaigns. In this role you will manage campaign development and deployment schedules in coordination with external partners, peers and supervisor. You will perform campaign QA using SQL queries against the Customer Data Platform (CDP). Drive campaign effectiveness with test and learn insights. Implement workflow process improvements by leveraging synergies between the CDP and SalesForce Marketing Cloud.

Campaign Planning, Development and Execution
  • Review Campaign selection specifications and ensure complete understanding of campaign / journey goals and requirements as outlined by Direct Marketing leads.
  • Know and manage campaign and journey business rules for a portfolio of events.
  • Use CDP audience builder to pre-analyze target customer segments in order to forecast audience size and formulate contact strategy. Some SQL querying may be necessary for more complicated targeted.
  • Create targeted audiences and assign offers and versions using CDP audience creator and recommendation engines and SalesForce Marketing Cloud platform. 
  • Audit results for each step using basic SQL queries directly against the CDP to ensure selection is accurate.
  • Perform campaign / journey analysis and provide audience results / insights to Direct Marketing owner in summary form to inform future strategy decisions.
  • Ensure quality control checks are executed at each step of campaign / journey set-up.
  • Ensure all internal and external files are delivered, processed and retained or disposed of as needed for the campaign / journey.
  • Automate triggered campaigns / journeys and QA regularly to ensure they are running correctly.

Quality Control Checks
  • Collaborate with other campaign analysts and external partners to ensure campaign / journey goals, requirements and specifications are met; Provide input on best practices in campaign / journey design and execution.
  • Document, evaluate and improve the audience selection / targeting and QC process. Complete root cause analysis on any errors and modify the process to avoid future errors.
  • Work with CDP provider and SalesForce Marketing Cloud contacts to resolve any application issues and improve future functionality.

  • Bachelor's Degree in Marketing, Business, Computer Science or other related field, or equivalent work experience
  • Experience in target marketing strategy / analytics or campaign management..  This experience can include database marketing / targeting, marketing analytics, audience modeling and building,, list coding experience or other relevant experience. (Required)
  • Experience in SQL coding and/or SalesForce Marketing Cloud (Desired).
  • 2+ years of experience working in a customer / marketing database or operational environment. (Desired)
  • Proven technical, analytical and problem solving skills
  • Experience successfully working with at least 5 MM household consumer databases (understanding data structures, relational databases, query optimization, file hygiene, etc.) (Desired)
  • Strong attention to detail and focus on high quality
  • Excellent project management / organization skills, with a track record of consistently producing deliverables on-time with high quality
  • Good team work / relationship building skills, especially with team mates with whom you will only work with on the phone and through email

Company Overview
We provide general merchandise, Pharmacy, and Optical services in our store formats of Shopko, Shopko Hometown, and Shopko Express.   
At Shopko, we understand what matters to our customers.  Our stores are designed to be simple, clean, and welcoming, not overwhelming.  We offer the essentials our customers need and the brands they trust at a fair price.  Shopko, the Stuff that counts.
Shopko offers a professional team-oriented work environment, career advancement opportunities, competitive wages, and a comprehensive benefits package! 
Shopko is an Equal Opportunity Employer functioning under an Affirmative Action Plan m/f/d/v.

Apply Now