Campaign Data Analyst

Campaign Data Analyst

Job Summary

We are seeking a detail-oriented and analytical Campaign Data Analyst to support the planning, execution, and performance measurement of marketing campaigns. The role is responsible for extracting, analyzing, and preparing customer data for campaign activities, ensuring audience accuracy, data quality, and insightful performance reporting. The ideal candidate will have strong SQL and reporting skills, experience working with CRM and marketing platforms, and the ability to transform complex data into actionable business insights.

Key Responsibilities

• Extract, manipulate, and analyze data using SQL to support marketing campaigns, audience selection, customer segmentation, and campaign performance tracking.
• Develop and maintain campaign audience lists, ensuring accurate targeting, exclusion rules, and customer journey requirements are applied.
• Create dashboards, reports, and performance analyses using Excel and Power BI to monitor campaign effectiveness and business outcomes.
• Work closely with Marketing, CRM, Loyalty, and Digital teams to support campaign execution and customer engagement initiatives.
• Analyze customer, transaction, membership, and engagement data from multiple data sources to identify trends and opportunities.
• Monitor and report on campaign KPIs including conversion rates, response rates, engagement levels, retention, and incremental performance.
• Support campaign measurement frameworks and provide recommendations to improve targeting, segmentation, and overall campaign effectiveness.
• Perform audience validation, data reconciliation, and quality assurance checks before and after campaign deployment.
• Conduct A/B testing analysis and provide insights on campaign optimization opportunities.
• Collaborate with CRM and marketing platform users, including HubSpot and other campaign management solutions.
• Assist in automating recurring reporting and campaign processes where possible.
• Support data governance, accuracy, and compliance standards across campaign-related datasets.
• Work with Microsoft Fabric, Azure, or similar cloud-based data environments where applicable.

Required Qualifications & Experience

• Bachelor's degree in Data Analytics, Computer Science, Business Analytics, Statistics, Information Systems, Marketing Analytics, or a related field.
• Minimum 3-5 years of experience in data analysis, CRM analytics, marketing analytics, or campaign operations.
• Strong proficiency in SQL for data extraction, segmentation, analysis, and audience creation.
• Advanced Excel skills including Pivot Tables, Power Query, lookups, and reporting functions.
• Hands-on experience with Power BI for dashboard creation and data visualization.
• Experience working with CRM, loyalty, and campaign management platforms.
• Strong understanding of customer segmentation, targeting strategies, customer journeys, and campaign lifecycle management.
• Experience working with customer, transaction, membership, and engagement datasets.
• Knowledge of campaign performance metrics and marketing analytics.
• Strong analytical, problem-solving, and attention-to-detail skills.

Preferred Qualifications

• Experience with HubSpot or similar CRM and marketing automation platforms.
• Knowledge of Python for data analysis, reporting automation, and process improvement.
• Experience working with Microsoft Fabric and Azure data environments.
• Exposure to data warehousing, ETL processes, and cloud-based analytics platforms.
• Experience within hospitality, leisure, retail, membership, or customer-centric industries is advantageous.

• Data Analysis & Interpretation
• Campaign Analytics & Reporting
• Customer Segmentation
• SQL & Database Management
• Power BI Dashboard Development
• CRM & Marketing Technology
• Data Quality & Validation
• Business Intelligence
• Stakeholder Management
• Process Improvement & Automation

Success Measures

• Accurate campaign audience preparation and segmentation.
• Timely delivery of campaign reporting and business insights.
• Improved campaign performance through data-driven recommendations.
• High levels of data quality, compliance, and reporting accuracy.
• Effective collaboration with Marketing, CRM, and Business stakeholders.