Campaign Manager (Unica/SQL)

STRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING!  

S3 is seeking a Campaign Manager for one of our partners in the Healthcare industry! This is a fully REMOTE role Monday – Friday, 8am – 5pm (no preferred time zone). Ideal candidates will have advanced SQL skills and experience with Unica in consumer marketing.

Job Title: Campaign Manager (Unica/SQL)

Location: Remote

Role Type: W2 Only, No C2C

Contract Length: 7 months

Pay: up to $45-55/hr.

JOB DESCRIPTION/RESPONSIBILITIES:

• Responsible for all aspects of the campaign development process, from requirements intake to file production, including the campaign design, development and execution.
• Tasks include:
  • Requirements documentation
  • In-depth data discovery and analysis
  • List management
  • Vendor management
  • Complex SQL query development
  • Campaign development in Unica
  • Test execution
  • Deployment
  • Production Support
• Requirements intake and translation of business requirements into SQL and a campaign
• Develop multiple complex communication campaigns (email, direct mail, outbound phone) simultaneously in the Unica tool
• Campaign Management for new and existing campaigns
• Collaborate with marketing communication owners on the goals, design, documentation and deployment of complex customer communication campaigns.
• Attend kick-off meetings and requirements gathering sessions to understand the business request and facilitate completion of intake documentation.
• Learn business rules and underlying data to support the delivery of quick, reliable solutions with the highest level of precision and data quality
• Collaborate with partners to ensure lists are not only timely and accurate but meet the business needs of the campaign
• Communicate and collaborate with vendors to set up new file transfer processes and initiate new email development
• Extract and summarize customer healthcare data by building advanced SQL programs to meet complex and changing requirements, while complying with privacy and security policies
• Follow best practices, processes, standards and strategy as it relates to campaign management
• Adhere to stringent quality control and testing procedures with the ability to investigate issues
• Proactively build and maintain processes, controls, and procedures to ensure data accuracy
• Ability to prioritize and manage a high number of concurrent tasks with a heightened sense of urgency and ability to adhere to deadlines
• Daily production support for existing campaigns
• Provide frequent progress updates and maintain documentation
• Support campaign reporting and analytical insights
• Ability to identify automation opportunities and campaign process improvements
• Translate highly complex concepts in a way that can be understood by a variety of audiences

REQUIRED SKILLS/QUALIFICATIONS:

• Bachelor’s degree and a minimum of 5 years experience in campaign development, consumer marketing, and reporting with focus on campaigns
• Advanced SQL skills are required and Unica experience is preferred
• Demonstrated ability managing projects; including overall responsibility, organization, and timelines
• Exceptional attention to detail, including technical and business specifics
• Ability to understand a variety of complex processes simultaneously operating
• Advanced ability in managing priorities and complexities in the day to day and overall projects
• An ability to both add creativity, while also developing within best practice frameworks and standards
• Strong data analysis skills and extensive knowledge of relational databases, data structures and design, data management, and data warehouses
• Excellent written and verbal communication skills
• Strong business acumen and consultation skills
• High regard for confidential and sensitive information
• Ability to work and maintain focus in a high pressure, high performance business environment
• Required Skills: DATA WAREHOUSES
• Additional Skills: QUALITY CONTROL SELF MOTIVATED MARKETING RESEARCH SELF-STARTER MARKETING ANALYSIS DEPLOYMENT VENDOR MANAGEMENT DATA STRUCTURES DATA MANAGEMENT DOCUMENTATION MAINTAIN DOCUMENTATION GOVERNANCE MANAGING PROJECTS SQL MARKETING BUSINESS REQUIREMENTS DATA QUALITY SECURITY POLICIES DATA ANALYSIS CAMPAIGN MANAGEMENT EXCELLENT WRITTEN AND VERBAL COMMUNICATION SKILLS ORGANIZATION SKILLS PROCESS IMPROVEMENTS TRANSLATE DIRECT MAIL

The S3 Difference

The global mission of S3 is to build trusting relationships and deliver solutions that positively impact our customers, our consultants, and our communities.  The four pillars of our company are to:

• Set the bar high for what a company should do
• Create jobs
• Offer people an opportunity to succeed and change their station in life
• Improve the communities where we live and work through volunteering and charitable giving

As an S3 employee, you’re eligible for a full benefits package that may include:

• Medical Insurance
• Dental Insurance
• Vision Insurance
• 401(k) Plan
• Vacation Package
• Life & Disability Insurance Plans
• Flexible Spending Accounts
• Tuition Reimbursement

Job ID: JOB-225944
Publish Date: 09 May 2023

Tagged as: Campaign Manager (Unica/SQL)