Business Intelligence Analyst at Go-jek
South Jakarta, ID
1+ years of working experience in relevant field.
Able to write advanced SQL queries with no supervision across all SQL/NoSQL flavors.
Able to write SQL/NoSQL using various functions, CTEs, and programmed functions with proper index efficiencies and subqueries.
Can independently improve and rewrite legacy SQL code for better optimization.
Able to independently export data to CSVs and develop Excel-based charts for C-Level executives.
Proficient with writing Python/R code for analysis and data reporting.
Understand basic automation.
Ability to manipulate and insert data across databases using ETL tools (Pentaho).
Ability to comfortably navigate Jira, BitBucket repos, etc.
Ability to write datamart transformation requirements.
Ad hoc support for product owners.
Defining KPIs with product owners.
Building data models for longer term projects
Assist building of integration/access layer data marts.
Analytical Tableau reporting.
Presents findings for actionable changes across products.
Understand the basic pricing model of their product.
Volunteers for special project assignments.
Identifying trends and possible pain points for products or consumer/driver behaviors.
Support for new implementations.
Able to identify and liaison with engineering teams to find bugs and fix them.
Makes recommendations to product owners.