Sr. Business Systems Analyst – Loyalty & Marketing Technology

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.

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

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

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