Sr. Business Systems Analyst – Loyalty & Marketing Technology

About the role

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.

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.
• Aid 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).
• 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.
• Cook up 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

• 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.