Database System Analyst

Your tasks

• Lead System Architecture: Direct the technical configuration of the lead handling system to ensure that data captured from various paid and organic channels (Meta, Google, etc.) flows accurately into the CRM without manual intervention. • Salesforce-HubSpot Sync Optimization: Oversee the bi-directional integration between HubSpot and Salesforce, ensuring that lead statuses, marketing touchpoints, and conversion data are synchronized in real-time for both sales and marketing visibility. • Data Integrity Auditing: Establish regular reporting audits to identify "leaks" in the lead handling system, such as leads stuck in sync errors or records missing critical attribution data required for management reporting. Consultant Performance Analytics: Build reporting frameworks within Salesforce to monitor the efficiency of lead handling by consultants, tracking metrics like "Time to First Action" and "Follow-up Consistency" to optimize the sales process. • Build Salesforce reporting frameworks to track consultant performance, including response speed and follow-up consistency. • Develop unified performance insights across paid, owned, and earned channels, offering clear recommendations for improvement. • Deliver monthly and ad-hoc post-campaign reports (including SAP campaigns) with actionable email and media performance insights. • Support the Manager – Performance Marketing & Analytics by preparing data-driven presentations and strategic channel recommendations. • Monitor industry trends and updates across analytics tools, measurement practices, and marketing technologies. • Evaluate new data sources, platforms, and technologies to expand measurement and optimization opportunities. • Encourage innovative data use across Media, Creative, CRM, and eCommerce to solve business challenges. • Assist with MarTech integrations and troubleshoot data-related issues within the ecosystem. • Advise on measurement frameworks and help define the right KPIs for campaign success.

Requirements

• At least 3 years of experience in a media agency or relevant industry systems / data analyst role, ideally across all digital platforms. Industry knowledge of Citizenship by Investment / Residency by Investment is a plus. • Good understanding of each platform’s (digital and social) reporting nuances. • Working Knowledge of Salesforce is mandatory • Strong relationships and communication skills, with experience managing multiple projects across teams. • Strong analytical, critical-thinking, and problem-solving skills, with the ability to see the bigger picture and link performance data to actionable business decisions. • Strong sense of responsibility, takes ownership, self-starter, and proactive attitude. • Excellent written, visual, and verbal communication skills and ability to transform data into a concise, yet compelling story. • Experience with post-campaign reporting, typical metrics to consider, and how to present these in a compelling manner. • Strong grasp of media measurement solutions such as Digital Attribution, Marketing Mix Modelling, Lift Tests, etc. • Proven ability to gather, analyze, and document business and system requirements (e.g., BRDs, FRDs, user stories). • Skilled user of MS Office Suite including Excel and PowerPoint. • Experience with Alteryx and / or Power BI or any alternative automation / data wrangling tools is a bonus. • Fluent in English; Arabic is a plus.