Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      cermati

      Is this your company?

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: cermati reviews | cermati jobs | cermati salaries | cermati benefits
      cermati interviewscermati Business Intelligence Analyst interviewscermati interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Indeed, Inc. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Indeed, Inc.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Business Intelligence Analyst Interview

      15 Aug 2023
      Anonymous interview candidate
      Jakarta
      No offer
      Neutral experience
      Difficult interview

      Application

      I applied online. I interviewed at cermati (Jakarta) in Aug 2023

      Interview

      There were 4 steps overall. First, you will be given a take home test regarding SQL and data analysis. The second one is phone interview with recruiter. Third one is panel interview with BI leads from Indodana and Cermati. Last is interview with VP. I failed at the third one.

      Interview questions [1]

      Question 1

      HR one was pretty basic HR questions like: why choose us, why changing job, expected salary, current package, current responsibilities and etc. The panel interview was more difficult. They are trying to gauge you by what you have done in your previous company, like what the insights and actionable item you can get from your dashboards or reports. Then they will gave you case study: 1. They will show you two tables: transaction and price. They wanted you to: a) take the price of every transactions (easy left join) b) the price table don't have the price for weekends while transactions happens all the time. They wanted to take the price of the last Friday as the price of weekends on that week. (Difficult one) They gave you 10 minutes to do this task. I panicked so I only gave whatever I could think of at the time. 2. You are asked to give idea of a dashboard for credit monitoring performance. They asked you to tell in detail what would be in the dashboard from top to bottom.
      1 Answer
      3

      Other Business Intelligence Analyst interview reviews for cermati

      Business Intelligence Analyst Interview

      21 Jan 2021
      Anonymous interview candidate
      No offer
      Neutral experience
      Average interview

      Application

      I interviewed at cermati

      Interview

      First is a take home SQL test with 2 days deadline, then on-site interview on the office with the user and the the HR. Not getting any info from them afterwards

      Interview questions [1]

      Question 1

      My approach to solve a use case using SQL
      Answer question