Sr. Business Systems Analyst – Loyalty &… at Publicis Groupe · Troy

Company Description

A division of Publicis Groupe, Publicis Digital Experience is a network of top-tier agencies designed to develop capabilities and solutions to enable growth and provide scaled access to the digital capabilities of Publicis Groupe in service of our clients. Together, the Publicis Digital Experience portfolio endeavors to create value at the intersection of technology and experiences to connect brands and people.

Our model to transform every brand experience will help clients navigate, develop, and activate commerce in a way that will provide them with a future-proof model for modern marketing. With our unique expertise in consumer engagement, CRM, and commerce, Publicis Digital Experience powers brands and empowers people in a new era of creativity. An ever-changing landscape and the need for fluid thinking is just part of our problem-solving nature. Which means we're untethered from any specific medium or method—we go where ideas will work best.

We are an expanding network with more than 5,000 employees, with agency brands throughout our global offices. Publicis Digital Experience brands include Razorfish, Digitas, Arc Worldwide, Saatchi Saatchi X, Plowshare, 3Share, and the Publicis Commerce Exchange.

Overview

The Sr. Business Systems Analyst – Loyalty & Marketing Technology supports the day-to-day operation of loyalty and promotional systems for a large-scale automotive loyalty program. This role focuses on marketing data and campaign execution, system configuration, documentation, and ongoing operational support across multiple initiatives. The ideal candidate is a flexible, proactive self-starter who is highly organized, detail-oriented, and enjoys problem-solving in a fast-paced environment.

You will partner closely with subject matter experts, business stakeholders, IT and development teams, and analytics groups to ensure data integrity, accurate reporting, and smooth execution of program initiatives and campaigns.

Responsibilities

Key Responsibilities

• Utilize SQL (e.g., Databricks or similar environments) to create reports, pull files, and build queries that support marketing campaigns, targeting, and loyalty program operations.
• Leverage Salesforce Marketing Cloud to support campaign set-up, audience segmentation, data extensions, and ongoing marketing automation activities.
• Provide ongoing systems and operational support for loyalty and promotional platforms, ensuring stability, data accuracy, and timely execution of offers and campaigns.
• Assist with offer configuration setup, updates, and maintenance, understanding downstream impacts to marketing data, reporting, and customer experience.
• Collaborate with internal and external stakeholders to translate business needs into clear technical requirements, process flows, and system specifications.
• Support and sometimes lead testing activities, including test case creation and execution, validation of results, and documentation of outcomes; manage test data and promotional scenarios in lower environments (e.g., UAT).
• Monitor and help maintain data integrity and reporting accuracy across platforms and tools (e.g., Databricks, Power BI, Excel).
• Support issue tracking, triage, and resolution, escalating when appropriate and partnering with IT/development on enhancements and defect fixes.
• Develop and maintain process documentation, user guides, and standard operating procedures to support repeatable, high-quality execution.
• Coordinate with cross-functional teams to ensure on-time delivery of system-related tasks and campaign milestones in a fast-paced environment.
• Where needed, assist with customer-facing content validation to ensure accuracy and alignment with configured offers and program rules.

Qualifications

Must-Have Skills & Experience

• Advanced SQL proficiency (e.g., Databricks, or equivalent tools) with demonstrated experience querying, transforming, and validating large datasets to support marketing and loyalty use cases.
• Hands-on experience with Salesforce Marketing Cloud, including building or supporting campaigns, journeys, automations, or audience segmentation.
• Proven track record as a flexible, proactive self-starter with a strong sense of ownership, initiative, and accountability; comfortable working independently and driving work forward with limited oversight.
• Ability to thrive in a fast-paced, evolving environment, managing multiple priorities and deadlines simultaneously while maintaining high quality and attention to detail.
• Strong analytical, problem-solving, and decision-making skills, with the ability to balance technical constraints and business needs.
• Excellent written and verbal communication skills, with the ability to clearly document and communicate requirements, findings, and recommendations to both technical and non-technical stakeholders.

Preferred Skills & Attributes

• Experience working with loyalty programs, customer engagement platforms, or automotive industry programs.
• Familiarity with Power BI, advanced Excel, and related reporting tools; comfort working with sensitive customer or program data.
• Ability to translate client/business needs into actionable data-driven solutions, including clear mapping of requirements to data and system behaviors.
• Strong interpersonal skills and a collaborative mindset, with the ability to build relationships and partner effectively with internal teams and external clients.
• Curiosity and openness to using AI and new tools to drive efficiency and improve workflows.
• Comfortable working within established frameworks while proactively identifying issues, risks, and opportunities for process improvement.
• Availability for occasional off-hours testing or release support, as required by deployment schedules.

Qualifications

• Bachelor’s degree or equivalent professional experience required.
• 5+ years of experience in a systems analyst, business systems analyst, or similar role supporting marketing, loyalty, or data-driven programs.
• Demonstrated expertise in SQL and advanced Excel, with experience in environments such as Databricks and modern productivity tools (e.g., Copilot, MS Office).
• Experience with Salesforce Marketing Cloud in a production environment.

Additional Information

The Power of One starts with our people! To do powerful things, we offer powerful resources. Our best-in-class wellness and benefits offerings include:

• Paid Family Care for parents and caregivers for 12 weeks or more
• Monetary assistance and support for Adoption, Surrogacy and Fertility
• Monetary assistance and support for pet adoption
• Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance
• Tuition Assistance
• Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more
• Matching Gifts programs
• Flexible working arrangements
• 'Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)
• Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to eligible U.S. Based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.

We also offer medical and voluntary benefits to our freelancers and temporary employees. Voluntary benefit options include supplemental medical insurance, transportation, and parking benefits, legal benefits, pet insurance, and auto and home insurance.

You must be actively employed for 90 consecutive calendar days in order to be eligible for Publicis medical and voluntary benefits. You will also be eligible to participate in the Publicis 401(k) Plan after you complete 1,000 work hours in a consecutive 12-month period.

Publicis Digital Experience is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances.

If you require accommodation or assistance with the application or onboarding process specifically, please contact USMSTACompliance@publicis.com. All your information will be kept confidential according to EEO guidelines.

Compensation Range: $55,765 - $73,400 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 07/26/2026.

#LI-LC1

Compensation Range: USD $55,765.00 - USD $73,400.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 8/3/2026.