Sr. Business Systems Analyst - Loyalty & Marketing Technology

Sr. Business Systems Analyst – Loyalty & Marketing Technology

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.

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.

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.