Decision Support Analyst

OP RaaS; Detroit (MI); On-site; USD 65,000 - 100,000; Full time

Benefits offered by this job

Hybrid work model

In-person collaboration culture

Job summary

RAPP in Detroit seeks a Decision Support Analyst to design, build, and optimize audiences for omni-channel campaigns using Adobe Campaign Classic, AEP, or AJO. You will leverage SQL and data insights to inform segmentation decisions and maximize engagement.

You will collaborate with marketing, analytics, and IT teams, maintain data integrity, and document processes while supporting performance optimization across channels in a hybrid work environment.

Qualifications

• Bachelor’s degree in Marketing, Data Science, Statistics, Computer Science, or a related field.
• 3+ years of experience in audience segmentation and campaign management.
• Adobe Campaign Classic expertise required; certification preferred.
• Strong proficiency in SQL and database management.
• Experience with JavaScript in ACC for workflow control and querying schemas.
• Familiarity with Power BI is a plus; data visualization experience.
• Experience with Azure Data Factory or AWS Glue is a plus.
• Exposure to Databricks (notebooks, Spark/Python) is a plus.
• Analytical, detail-oriented with strong problem-solving abilities.
• Excellent communication and presentation skills; ability to manage multiple priorities.

Responsibilities

• Develop and manage audience segmentation strategies for personalized campaigns.
• Create and optimize audiences using Adobe Campaign Classic, AEP, or AJO.
• Analyze customer data to identify insights and trends.
• Assess campaign performance and provide actionable recommendations.
• Collaborate with marketing, data science, Analytics, and IT teams.
• Translate business goals into actionable audience strategies.
• Maintain data integrity in Adobe Campaign Classic from build to reporting.
• Troubleshoot issues related to audience builds and segmentation.
• Document processes and best practices; create stakeholder reports.

Skills

Audience segmentation

Campaign management

SQL proficiency

Communication skills

Analytical thinking

Attention to detail

Problem solving

Multitasking

Team collaboration

Presentation skills

Education

Bachelor’s degree in Marketing/Data Science/Statistics/CS

Tools

Adobe Campaign Classic

PowerBI

SQL

JavaScript in ACC

Azure Data Factory

AWS Glue

Databricks

Job description

TITLE:

Decision Support Analyst

LOCATION:

Detroit, MI

FOCUS:

Data & Technology

REPORT TO:

Director, Campaign engineering

GROUP:

Technology

ABOUT RAPP

WHO WE ARE

We are RAPP – world leaders in activating growth with precision and empathy at scale.

As a global next-generation precision marketing agency, we leverage data, creativity, technology, and empathy to foster client growth. We champion individuality in the marketing solutions we create, and in our workplace. We fight for solutions that adapt to the individual’s needs, beliefs, behaviors, and aspirations.
We foster an inclusive workplace that values diversity and emphasizes personal well-being.

HOW WE DO IT

At RAPP, our fearless superconnectors help to create value from personal brand experiences by focusing on three key areas: connected data, connected content and connected decisioning.
Our data analysts identify who that person is, our strategists understand what they want, and our award-winning technologists and creatives know how to deliver it – ensuring we’re able to activate authentic customer connections for our clients.

Part of Omnicom’s Precision Marketing Group, RAPP is comprised of 2,000+ creatives, technologists, strategists, and data and marketing scientists across 15+ global markets.

OUR CLIENTS

From creating inspiring experiences behind the wheel, to defining the future of online learning, and everything in between, we provide smart solutions for companies like Toyota, AAA, PNC Bank, US Army, University of Phoenix and more.

YOUR ROLE

We are seeking a talented and detail-oriented Decision Support Analyst to join our team. The ideal candidate will play a pivotal role in supporting our marketing operations by leveraging Adobe Campaign Classic to design, build and optimize audiences for personalized omni-channel campaigns. This role requires a blend of analytical skills, technical expertise, and marketing knowledge to drive impactful decisions and enhance customer engagement and marketing performance.

YOUR RESPONSIBILITIES

• Audience Segmentation and Targeting:
• Develop and manage audience segmentation strategies to support personalized marketing campaigns.
• Utilize Adobe Campaign Classic (v7/v8) and or AEP, AJO to create, maintain, and optimize audiences for multi-channel campaigns.
• Data Analysis and Insights:
• Analyze customer data to uncover insights and trends that inform audience strategies.
• Conduct performance analysis of campaigns and provide actionable recommendations for improvement.
• Collaboration:
• Work closely with marketing, data science, Analytics, and IT teams to ensure alignment on audience strategies and campaign execution.
• Partner with stakeholders to understand business goals and translate them into actionable audience strategies.
• System Management:
• Maintain and ensure the integrity of data within Adobe Campaign Classic, from initial audience build all the way through to reporting and optimization.
• Troubleshoot and resolve technical issues related to audience builds and segmentation.
• Documentation and Reporting:
• Document processes, workflows, and best practices related to audience building.
• Create detailed reports to communicate findings, metrics, and insights to stakeholders.

QUALIFICATIONS

• Educational Background:
• Bachelor’s degree in Marketing, Data Science, Statistics, Computer Science, or a related field.
• Experience:
• 3+ years of experience in a similar role, with a focus on audience segmentation and campaign management
• Proven expertise in Adobe Campaign Classic is required (Adobe campaign expert business practitioner or adobe campaign developer certification preferred)
• Technical Skills:
• Strong proficiency in SQL and database management.
• Experience leveraging Javascript in ACC to control workflows operations and query critical schemas.
• Familiarity with data visualization tools (PowerBI) is a plus.
• Experience working with data engineering solutions (Azure Data Factory, AWS Glue) is a plus.
• Exposure to Databricks (notebooks, spark/python, automations, versioning) is a plus.
• Analytical Skills:
• Ability to analyze large datasets and extract actionable insights.
• Strong problem-solving skills and attention to detail.
• Soft Skills:
• Excellent communication and presentation skills.
• Ability to manage multiple priorities in a fast-paced environment.
• Preferred Qualifications:
• Experience in a marketing or customer engagement role.
• Familiarity with other marketing automation tools and platforms.
• Understanding of data privacy regulations (CCPA, GDPR) and their impact on audience building.

• OUR HYBRID WORKING MODEL
  RAPP's current hybrid model is designed to enable in-person connections and collaboration that is core to our culture, while also supporting flexibility for all employees. As such, we have the option to work from home two days per week, if we'd like.
  NOTE: This job description is not intended to be all-inclusive. Employee may perform other related duties as negotiated to meet the ongoing needs of the organization.