Campaign Data Analyst

Confidential Careers; Dubai; On-site; AED 180,000 - 240,000; Full time

Job summary

Confidential Careers is seeking a Campaign Data Analyst to support planning, execution, and performance measurement of marketing campaigns. You will extract, analyze, and prepare customer data for campaign activity, ensuring audience accuracy, data quality, and insightful reporting.

The role requires strong SQL, Excel, and Power BI skills, plus experience with CRM and marketing platforms. You will collaborate across Marketing, CRM, Loyalty, and Digital teams and work with cloud data environments

Qualifications

• Bachelor’s degree in a relevant field such as Data Analytics, CS, or Marketing Analytics.
• 3–5 years of experience in data/CRM/marketing analytics or campaign operations.
• Strong SQL for data extraction, segmentation, and audience creation.
• Advanced Excel (Pivot Tables, Power Query, lookups) and reporting functions.
• Hands-on Power BI for dashboards and data visualization.
• Experience with CRM, loyalty, and campaign management platforms.

Responsibilities

• Extract and analyze data using SQL to support campaigns, audience selection, and segmentation.
• Develop and maintain campaign audiences with accurate targeting and journey rules.
• Create dashboards and reports in Excel and Power BI to monitor campaign performance.
• Collaborate with Marketing, CRM, Loyalty, and Digital teams for execution.
• Analyze customer, transaction, membership, and engagement data for insights.
• Monitor KPIs like conversion, response, engagement, retention, and incremental impact.
• Support measurement frameworks and optimize targeting and segmentation.
• Perform audience validation, data reconciliation, and QA before/after deployment.
• Conduct A/B testing analyses to identify optimization opportunities.
• Work with HubSpot and other campaign platforms; assist in automation of recurring reporting.
• Contribute to data governance, accuracy, and compliance across datasets.
• Engage with cloud data environments like Microsoft Fabric or Azure.

Skills

SQL

Excel

Power BI

CRM analytics

Marketing analytics

Audience creation

Campaign analytics

A/B testing analysis

Education

Bachelor's degree in Data Analytics or related field

Tools

HubSpot

Python

Microsoft Fabric

Azure

Job description

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
• SQL & Database Management
• CRM & Marketing Technology
• Data Quality & Validation
• 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.