Main Task : - Balancing query experience and cost optimization when using Google BigQuery- Create and monitor data governance for using BI Tools (Looker)- Become a technical expert to guide and mentor for 10 BI Analyst when they develop Business Intelligence solutions- Work with data engineer to provide and monitor governance for Data Team when creating or updating data mart or data warehouse- Monitor BI Tools (Looker) usages and performancesAchievement : -… Show more Main Task : - Balancing query experience and cost optimization when using Google BigQuery- Create and monitor data governance for using BI Tools (Looker)- Become a technical expert to guide and mentor for 10 BI Analyst when they develop Business Intelligence solutions- Work with data engineer to provide and monitor governance for Data Team when creating or updating data mart or data warehouse- Monitor BI Tools (Looker) usages and performancesAchievement : - Create analysis, provide best option of bigquery slot config, and do jobs optimization in BigQuery to reduce 25% BigQuery cost in 2023- Create simulation and provide best option to avoid cost increase because of new pricing model in BigQuery (autoscaling slot) in Q2 2023- Optimized pipeline of data mart-like tables in Looker to have 95% of all tables already updated before 6AM in Q4 2023, previously the SLA is 90% before 9AM, and the trend is 78% before 6AM. It increased user experience by making sure the tables that were being used in their contents were already updated at 6AM. Show less

- Create a data warehouse design for fact transactions table from multiple business sources, including table schema, data sources, and transformation logic.- Create guideline on how to create or update data warehouse using Airflow- Become a technical expert to guide 4 BI Analyst and 2 Data Scientist as they develop Business Intelligence solutions- Create guideline to compare query performances so it can be used by other data developer to improve their queries- Store metadata of… Show more - Create a data warehouse design for fact transactions table from multiple business sources, including table schema, data sources, and transformation logic.- Create guideline on how to create or update data warehouse using Airflow- Become a technical expert to guide 4 BI Analyst and 2 Data Scientist as they develop Business Intelligence solutions- Create guideline to compare query performances so it can be used by other data developer to improve their queries- Store metadata of Bigquery and BI Tools (Looker) to monitor it’s usage and performance- Optimize Big Query cost by monitoring Big Query slot utilization- Utilize Looker API to create CI/CD pipeline to make sure all developments are validated and not breaking things- Create and monitor alert related to BigQuery and Looker Show less

- Project planning and management for Data Team (4 Data Analyst, 1 Data Engineer, 3 Data Scientist)- Work with HR and Product to build employee database and calculate incentive- Work with Funding and Management team to assess new Investors by providing Investment Simulation- Work with Risk Management team to make DPD and NPL Simulation, pandemic effect- Help Finance create Financial Reporting- Make and manage end to end Credit Scoring API- Make and manage dashboard for… Show more - Project planning and management for Data Team (4 Data Analyst, 1 Data Engineer, 3 Data Scientist)- Work with HR and Product to build employee database and calculate incentive- Work with Funding and Management team to assess new Investors by providing Investment Simulation- Work with Risk Management team to make DPD and NPL Simulation, pandemic effect- Help Finance create Financial Reporting- Make and manage end to end Credit Scoring API- Make and manage dashboard for Field Managers- Make and manage automate email reporting - Manage data-mart in redshift from production database so other team can use it easily- Update and manage metabase so other team can get data easily from data-mart- Deploy and manage Data Products / Services in cloud Show less

Make and manage Internal Dashboard using Redash and R ShinyHelp other team to track their KPI(s)Provide insight to the business by using data to figure out market and business trends forcompanies to increase profits and efficiencyProvide insight for other team so they can improve and reduce costWork with other Data Science team and Engineering team to make Credit Scoring Model and automate it.

Make Credit Scoring Model, and automate it to update weekly. Make dashboard using R for management and other team. Work with Growth team to analyze funnel customer and marketing performance.

Work with developer to setup game event tracking. Analyst user game data to make KPI report and get insight to improve game performance and increase revenue. Work with IT team to setup database and get another data if needed to support analysis.

Support IT Team to make automate Data Analytics tools that can be used in any kind of data and any kind method that needed.Support other team to Get, cleans and tidying the data from Big data Architecture and then make report Analysis or Prediction if needed.

Doing Data Selection & Preparation and Data Analysis using different data miningmethods such as clustering, classification, regression, association rules, etc.Create analytics report based on findings

Develop Analytics function, formula and tools to Support Analytics Division