Language

Market Insight Advisor

Operations
Best Practices
Marketing Specialist
Segmentation
Marketing Automation
Marketing Technology
Direct Mail
Marketing
Data Validation
HTML
SMS
Datasets
Data Analytics
Deployment
Migrations
SQL Queries
SQL
Description:

This position is a temporary assignment. As a contractor, you’ll be employed by Magnit, not The Cigna Group or any subsidiaries of The Cigna Group.

Job Description

Job Title: Market Insight Advisor (Contractor - 12 month) (Alternate: Segment Marketing Specialist)

Role Summary: 

This role is responsible for building and executing complex, data-driven customer campaigns across email and other digital channels, supporting both current-state campaign delivery and ongoing migration efforts from Unica to RedPoint Interaction (RPI). The position emphasizes translating campaign strategy into scalable, compliant execution within a multi-platform environment, ensuring consistency and accuracy across legacy and modern marketing technologies.

Key Responsibilities: 

 Build and execute customer campaigns within RedPoint Interaction (RPI), including segmentation, workflow orchestration, and deployment · Translate business and campaign requirements into executable data selections, logic, and campaign flows · Write and modify SQL queries to support audience creation, data validation, and troubleshooting · Develop and modify customer communications across email and digital channels using approved templates and dynamic content · Ensure campaigns meet brand, compliance, regulatory, and accessibility standards · Perform end-to-end QA and validation (data, logic, content, and output files) prior to deployment · Partner with cross-functional teams (strategy, analytics, data, technology) to ensure alignment and execution feasibility · Troubleshoot campaign, data, or platform issues across RPI and downstream systems · Manage multiple concurrent campaigns with competing timelines in a fast-paced environment · Document campaign logic, build approaches, and best practices to support consistency and process improvement

Core Competencies: 

 Experience working across multiple marketing platforms, including legacy (Unica) and modern orchestration tools (RPI or similar) · Strong understanding of data-driven campaign execution in complex and regulated environments · Proficiency in SQL for data selection, validation, and troubleshooting · Working knowledge of HTML for email development and rendering troubleshooting · Strong attention to detail with a focus on accuracy, compliance, and risk mitigation · Ability to manage multiple priorities and meet deadlines · Strong collaboration and communication skills across cross-functional teams

Required Qualifications:  

  • 5–7+ years of experience in campaign execution, lifecycle marketing, or marketing operations
  • Hands-on experience building and executing campaigns in a marketing automation or CDP platform ·
  • Direct experience with RedPoint Interaction (RPI) or similar journey orchestration platforms
  • Intermediate to advanced SQL skills (query writing, joins, validation, troubleshooting)
  •  Experience working with complex datasets, segmentation logic, and personalization rules
  • Demonstrated ability to manage multiple projects and deliver high-quality outputs under deadline                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Preferred Qualifications:  
  • Experience working within CDPs, Snowflake, or enterprise data environments
  •  Direct experience working with both Unica and RedPoint Interaction (highly preferred)
  • Experience supporting platform migrations or working across multiple MarTech environments
  • Strong experience working with complex datasets and advanced segmentation logic
  •  Healthcare or highly regulated industry experience (strongly preferred given compliance requirements)
  • Experience with omnichannel campaigns (email, SMS, push, direct mail)                                                                                                                                                                                                                                                                                                                     Education: 
  • Bachelor’s degree required (Marketing, Business, Data Analytics, Computer Science, or related field)
  • Advanced degree or relevant technical certifications (SQL, analytics, or MarTech platforms) is a plus
  • Equivalent professional experience may be considered

 

Hourly Pay Rate Range (dependent on location, experience, expectation)

The pay range that Magnit reasonably expects to pay for this position is: $37.00/hour-$42.00/hour

Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met)

We are unable to provide visa sponsorship or STEM OPT training.

Tundra Technical Solutions (the operator of this Talent Community) is a global leader of contingent talent services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations. 

 

Qualified applicants will be considered without regard to race, color, age, disability, sex, childbirth (including pregnancy) or related medical conditions including but not limited to lactation, sexual orientation, gender identity or expression, veteran or military status, religion, national origin, ancestry, marital or familial status, genetic information, status with regard to public assistance, citizenship status or any other characteristic protected by applicable equal employment opportunity laws.

QUALIFICATION/ LICENSURE :
  • Work Authorization : Green Card, US Citizen, Other valid work visa
  • Travel Required : No travel required
  • Shift timings: Not specified
Job Location Remote (Remote)
Pay USD 37.00 - USD 42.00 Per Hour
Contract Duration 12 month(s)