Jobs Career Advice Signup

Send this job to a friend


Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Apr 30, 2024
    Deadline: May 7, 2024
  • Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us

    Coca-Cola is the most popular and biggest-selling soft drink in history. An icon of all times, Coca-Cola is the best-known product in the world. Created in Atlanta, Georgia, by Dr. John S. Pemberton, Coca-Cola was first offered as a fountain beverage by mixing Coca-Cola syrup with carbonated water. Coca-Cola was introduced in 1886, patented in 1887, regis...
    Read more about this company


    D2C BI Analyst

    Job Summary

    • We are looking for a BI Analyst to join our Direct-to-consumer (D2C) team and help us deliver data-driven insights and recommendations to optimize our online sales and marketing strategies.
    • You will be responsible for collecting, analyzing, and reporting on our different D2C initiatives, such as consumer behavior, product performance, sales trends, and conversion rates.
    • You will also collaborate closely with our DTPS, DIA and dCom teams to identify opportunities and challenges, and provide actionable solutions based on data.

    Job Responsibilities

    • Analyze, clean, and transform data from various sources, such as web analytics, CRM, SAP, and third-party platforms
    • Collaborate with DTPS to ensure that all relevant data sources are integrated in data mesh 
    • Prepare recurrent reporting for senior stakeholders and business owners
    • Build and maintain dashboards, reports, and visualizations that track and communicate key D2C metrics and KBIs (unit economics, CLTV, RR, NPS etc.)
    • Perform exploratory analyses to uncover insights and trends that support data-driven decision making
    • Unveil consumer trends, purchasing behaviors and patterns, demographic specifics etc.  that drive tailored and targeted marketing activities 
    • Work closely with the D2C product owners and marketers to understand their business goals and provide data-driven recommendations and solutions
    • Communicate and present findings and recommendations to various audiences, both technical and non-technical

    Deliverables Y1

    Coke & Go Power BI Dashboard: Build, enhance and maintain a dashboard for Coke & Go, collecting data from multiple different data sources. Agree with the vendor and other stakeholders on data sharing structure, frequency and method. 1st stage dashboard KBIs (phase 1, non PII data): 

    • Performance dashboard (admin portal, SAP, televend) for: Actuals vs BP vs RE, GSR, NSR, Incremental revenues: totals, % share of total, Transactions/Orders, Units,UC,Consumers: Downloads, registered users, MAU, registered w/o credit card,New consumers, Reactivated consumers, returning consumers, lost consumers,NPS,CLTV,Machines connected,Offline transactions per machine, C&G share vs offline
    • Filters: Country, City, Currency, Machine number, Machine type: TVM, Smart Cooler, Year, Quarter, Month, Week


    • Own, enhance and maintain current consumer panel dashboard and provide data-driven recommendations and solutions to the team
    • Explore the root cause of data discrepancies and suggest solutions to fix it
    • Own, enhance and maintain current performance reporting dashboard

    Egypt Home Delivery: Creation of holistic dashboard capturing:

    • Performance (website, call center) from SAP, Salesbuzz
    • Consumer insights from SAP, KO
    • Digital Marketing data from Adobe MC
    • Website analytics from Google Analytics

    Job Requirements

    • Bachelor's degree in Business Analytics, Economics, Computer Science, Statistics, or related field
    • At least 3 years of experience in BI, data analysis, or a similar role
    • Proficient in SQL and Excel
    • Experience with BI tools, such as Tableau, Power BI, or Looker
    • Experience with web analytics tools, preferably Google Analytics, Adobe Analytics
    • Fluent in English
    • Knowledge of D2C business models and e-commerce best practices
    • Strong analytical and problem-solving skills
    • Excellent communication and presentation skills
    • Ability to work independently and collaboratively in a fast-paced environment

    Method of Application

    Interested and qualified? Go to Coca-Cola on to apply

    Build your CV for free. Download in different templates.

  • Send your application

    View All Vacancies at Coca-Cola Back To Home

Subscribe to Job Alert


Join our happy subscribers

Send your application through

GmailGmail YahoomailYahoomail