Data Analyst
Junior data analyst on Ocoda's marketing team serving Hojuzat, an online travel agency. Day to day: stewarding the MarTech stack (Zoho, Adjust, GTM), building and maintaining Power BI dashboards, running daily data sanity checks, and automating API-based data integrations between the app/web products and analytics tools.
- Compensation
- Not disclosed
- Location
- Cairo, Egypt
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- Not specified
- Category
- Data analytics
- Posted
Skills
Must have
- Bachelor's degree in Business Intelligence, Data Analytics, Computer Science, or related field
- Strong foundational knowledge of Power BI (DAX, Power Query)
- High proficiency in Excel (Power Pivot)
- Solid understanding of SQL for querying databases and managing data routes
- Understand how GTM (Server-Side), MMPs (Adjust), and CRMs (Zoho) exchange data via APIs and webhooks
- Analytical thinking: envision the final report the business needs from raw data
Nice to have
- 1-2 years experience (high-potential junior or recent graduate)
- Portfolio with Power BI dashboards or GTM container management experience
- Understanding of the Saudi travel market (local search trends, consumer behavior)
Full description
We're looking for a Junior Data Analyst to join our Marketing Team at Ocoda who will be responsible for Hojuzat(OTA) Global Reservation Company.
Role Objective
The MarTech & Business Analytics Associate is the internal custodian of Hojuzat’s data "Core and Shell." You are responsible for the health of our Grid of Tools, ensuring that data flows seamlessly from our App/Web products into our analytical engines. You will shadow expert consultants to master our infrastructure and take full internal ownership of our data routes, specifically leading the visualization of business health through Power BI.
Key Responsibilities:
- MarTech Stewardship & Shadowing: Act as the internal shadow to the MarTech consultant. You must master the end-to-end setup (Adjust, GTM, Zoho) to ensure you can maintain and troubleshoot the infrastructure independently after the initial setup.
- Power BI & Visualization: Lead the creation of the "Business Shell." You will build and maintain high-level dashboards in Power BI, connecting directly to our data sources to provide a real-time view of revenue, user growth, and funnel performance.
- Data Sanity & Auditing: Perform daily "Sanity Checks" to ensure data consistency between the App, Web, Zoho CRM, and Power BI. You are the first line of defense against "leaking" data or broken tracking events (e.g., Check Availability).
- The Grid of Tools Management: Own the administration of our data stack, including Zoho Analytics, Power BI, Adjust, and GTM. You ensure every tool in the marketing and business departments is updated, integrated, and delivering accurate data.
- Automation & Data Integration: Design and implement automated data routes. Your goal is to eliminate manual Excel exports by creating live API-based integrations between our core database and our analytical tools.
- Analysis Facilitation: Directly support Ahmed ElSherif with on-demand data deep-dives. You will design "Analysis Paths" to solve specific business problems (e.g., "Correlating on-ground activations with app download spikes").
Requirements
##
- Education: Bachelor’s degree in Business Intelligence, Data Analytics, Computer Science, or a related field.
- Power BI Mastery: Strong foundational knowledge of Power BI (DAX, Power Query). You must be able to transform raw data into clean, interactive visualizations.
- Advanced Excel/SQL: High proficiency in Excel (Power Pivot) and a solid understanding of SQL for querying databases and managing data routes.
- Technical Logic: A quick learner who can understand how GTM (Server-Side), MMPs (Adjust), and CRMs (Zoho) exchange data via APIs and webhooks.