Senior Campaign Developer

Responsibilities

• The Senior Campaign Developer is responsible for the team’s development, maintenance, and deployment of targeted recipient lists in partnership with a wide range of internal message sponsors, including marketing and product owners.
• Develop and deliver these communication campaigns to benefit plan participants.
• Audit and perform quality assurance to ensure flawless delivery, including peer and team design reviews.
• Support and monitor campaigns in production, troubleshoot technical issues, and make modifications as necessary to ensure communication accuracy.
• Call out issues related to scope, schedule, and quality.
• Build complex targeting rules in Unica Campaign, Twilio Segment, and/or Salesforce Journey Builder.
• Develop scalable, repeatable processes for building target populations.
• Understand communication targeting requirements and develop logic to identify and segment the intended audience.
• Work with large and varied data sets, from multiple data sources, to conduct analysis on current customer activity and generate concise reporting, contact lists, and relevant insights

Requirements

• Proficient in Oracle, Snowflake and SQL Server databases
• Proficient at SQL query development, including analytic functions, aggregate calculations, case statements, etc.
• Experience in managing extensive quality assurance processes prior to providing reports/data to internal customers
• Attention to detail (emphasis on quality a must)
• Ability to multi-task, prioritize, take on responsibility and work well under tight project timelines
• Dependable interpersonal skills and active listening skills to ensure understanding of, and alignment with, customer objectives
• Ability to interact with a variety of staff across functions and levels
• Campaign management experience (preferably Unica Campaign, Twilio Segment and/or Salesforce Journey Builder)
• Understand communication targeting requirements and develop logic to identify and segment the intended audience
• Work with large and varied data sets, from multiple data sources, to conduct analysis on current customer activity and generate concise reporting, contact lists, and relevant insights (experience with data visualization tools like PowerBI and Tableau a plus)