Campaign Data Analyst
Job Summary
We are seeking a highly analytical and detail-oriented Campaign Data Analyst to support the planning, execution, audience management, and performance measurement of marketing and customer engagement campaigns. This role combines strong data analytics expertise with hands-on campaign and CRM management experience, particularly within platforms such as HubSpot. The successful candidate will be responsible for customer segmentation, campaign audience preparation, performance reporting, data validation, and generating actionable insights that drive customer acquisition, engagement, retention, and revenue growth.
The ideal candidate will possess advanced SQL skills, strong analytical capabilities, experience working with CRM and marketing automation platforms, and expertise in developing dashboards and reporting solutions using Power BI and Excel.
Key Responsibilities
Campaign Management & Audience Preparation
- Support the execution and management of marketing campaigns through CRM and campaign platforms, with preference for HubSpot experience.
- Create, validate, and maintain campaign audiences utilizing segmentation, targeting, suppression, and exclusion criteria.
- Work closely with Marketing, CRM, Loyalty, and Digital teams to ensure campaign requirements are accurately translated into data-driven audience selections.
- Support customer journey planning and campaign deployment activities across multiple communication channels.
- Ensure campaign audiences are accurately prepared, validated, and delivered within agreed timelines.
Data Analysis & Business Intelligence
- Extract, manipulate, and analyze large datasets using SQL to support campaign planning and performance measurement.
- Analyze customer, transaction, membership, loyalty, and engagement data from multiple data sources to identify trends and opportunities.
- Develop reports, dashboards, and visualizations using Power BI and Excel to monitor campaign effectiveness and business performance.
- Deliver actionable recommendations that improve customer targeting, engagement, retention, and campaign ROI.
- Identify customer behavior patterns and opportunities for growth through data-driven insights.
Campaign Performance & Reporting
- Monitor, track, and report campaign KPIs including:
- Conversion Rate
- Response Rate
- Engagement Rate
- Customer Retention
- Incremental Revenue and Performance
- Return on Marketing Investment (ROMI)
- Conduct campaign effectiveness analysis and provide recommendations for optimization.
- Support A/B testing initiatives and evaluate campaign outcomes to identify winning strategies and opportunities for improvement.
- Prepare regular performance reports and presentations for key stakeholders.
Data Quality & Governance
- Perform data validation, reconciliation, and quality assurance checks before and after campaign execution.
- Ensure customer data accuracy, completeness, and consistency across campaign activities.
- Investigate and resolve data discrepancies affecting campaign performance and reporting.
- Support compliance with data governance and customer data management standards.
Automation & Technology
- Support automation of recurring reporting, audience creation, and campaign processes.
- Collaborate with technology and data teams to improve campaign workflows and operational efficiency.
- Work with Microsoft Fabric, Azure, data warehouses, and cloud-based analytics environments where applicable.
- Support integration and utilization of CRM, loyalty, and marketing automation platforms.
Required Qualifications & Experience
- Bachelor's Degree in Data Analytics, Business Analytics, Computer Science, Statistics, Information Systems, Marketing Analytics, or a related field.
- Minimum 3-5 years of experience in Data Analytics, CRM Analytics, Campaign Analytics, Marketing Analytics, or Customer Insights.
- Strong hands-on experience using SQL for:
- Data extraction
- Customer segmentation
- Audience creation
- Campaign analysis
- Performance reporting
- Advanced Microsoft Excel skills including Pivot Tables, Power Query, Lookups, Data Modelling, and Reporting.
- Hands-on experience with Power BI for dashboard development and business reporting.
- Experience working with CRM, loyalty, customer, and campaign management platforms.
- Strong understanding of:
- Customer Segmentation
- Campaign Targeting
- Exclusions & Suppression Logic
- Customer Journeys
- Campaign Lifecycle Management
- Experience working with customer, transactional, membership, and engagement datasets.
- Strong analytical, problem-solving, and stakeholder management skills.
- Exceptional attention to detail and data accuracy.
Preferred Qualifications
- Hands-on experience with HubSpot CRM and Marketing Automation.
- Knowledge of Python for data analysis, automation, and reporting enhancement.
- Experience with Microsoft Fabric, Azure Data Services, or similar cloud-based analytics environments.
- Understanding of data warehousing, ETL processes, and enterprise data platforms.
- Experience within hospitality, leisure, membership, retail, e-commerce, or customer-centric industries is advantageous.
Key Competencies
- Campaign Analytics & Performance Measurement
- CRM & Marketing Technology
- Customer Segmentation & Audience Management
- SQL Database Management
- Power BI Dashboard Development
- Data Visualization & Reporting
- HubSpot Campaign Management
- Data Quality & Validation
- Business Intelligence & Insights
- Process Automation
- Stakeholder Collaboration
- Problem Solving & Critical Thinking
Success Measures
- Accurate and timely delivery of campaign audiences and segmentation requirements.
- High-quality campaign reporting and actionable business insights.
- Improved campaign performance through data-driven recommendations.
- Strong data governance and reporting accuracy.
- Effective utilization of HubSpot and CRM platforms to drive customer engagement.
- Enhanced automation and operational efficiency across campaign processes.
- Strong collaboration with Marketing, CRM, Loyalty, Digital, and Business stakeholders.
