CRM & Campaign Analytics Specialist

Campaign Data AnalystJob SummaryWe 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 ResponsibilitiesCampaign Management & Audience PreparationSupport 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 IntelligenceExtract, 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 & ReportingMonitor, track, and report campaign KPIs including:Conversion RateResponse RateEngagement RateCustomer RetentionIncremental Revenue and PerformanceReturn 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 & GovernancePerform 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 & TechnologySupport 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 & ExperienceBachelor'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 extractionCustomer segmentationAudience creationCampaign analysisPerformance reportingAdvanced 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 SegmentationCampaign TargetingExclusions & Suppression LogicCustomer JourneysCampaign Lifecycle ManagementExperience working with customer, transactional, membership, and engagement datasets.Strong analytical, problem-solving, and stakeholder management skills.Exceptional attention to detail and data accuracy.Preferred QualificationsHands-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 CompetenciesCampaign Analytics & Performance MeasurementCRM & Marketing TechnologyCustomer Segmentation & Audience ManagementSQL Database ManagementPower BI Dashboard DevelopmentData Visualization & ReportingHubSpot Campaign ManagementData Quality & ValidationBusiness Intelligence & InsightsProcess AutomationStakeholder CollaborationProblem Solving & Critical ThinkingSuccess MeasuresAccurate 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.