Campaign Data Analyst

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

Job summary

Confidential Careers in Dubai is seeking a Campaign Data Analyst to support planning, execution, and performance measurement of marketing campaigns. The role involves extracting, cleaning, and analyzing customer data for accurate audience targeting and insightful reporting.

The ideal candidate brings strong SQL, Power BI, and Excel skills, with experience across CRM and marketing platforms to transform data into actionable business insights for cross-functional teams.

Qualifications

• Bachelor’s degree in a data/analytics field.
• 3–5 years in data analysis or marketing analytics.
• Strong SQL for data extraction and audience creation.
• Advanced Excel skills (Pivot Tables, Power Query).
• Hands-on Power BI for dashboards and data visualization.
• Experience with CRM, loyalty, and campaign platforms.
• Understanding of customer segmentation and campaign lifecycle.

Responsibilities

• Extract, manipulate, and analyze data using SQL to support campaigns.
• Develop and maintain audience lists with accurate targeting and journey rules.
• Create dashboards and reports in Excel and Power BI to monitor performance.
• Collaborate with Marketing, CRM, Loyalty, and Digital teams for campaign execution.
• Analyze data from multiple sources to identify trends and opportunities.
• Monitor campaign KPIs such as conversion, engagement, retention, and lift.

Skills

SQL

Pivot Tables

Power Query

Power BI

CRM analytics

Marketing analytics

Data storytelling

A/B testing

Education

Bachelor's degree in Data Analytics

Tools

HubSpot

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.