Data Warehouse and Business Intelligence

Jakarta Selatan·DKI Jakarta·IndonesiaIT

Job Type
:  Full Time
Job Industry
:  Information Technology and Services
Job Function
:  Information Technology
Experience
:  Staff / Junior Staff
Salary
:  IDR 6.000.000 - 20.000.000
Education
:  Bachelor Degree - S1
Description

•Works with the users to define the data requirements and structure for data warehouse and Business Intelligence

•Responsible for development and maintenance of the data warehouse and Business Intelligence that supports reporting and analytics for the users

•Create solution which targeted to meet business needs for information delivery via Reports, Cubes, and Dashboard

•Develop data solutions to help product and business teams make data driven decisions

•Work closely with data scientist or data analyst to construct creative solutions for their analysis tasks

•Support end users on ad hoc data usage and be a subject matter expert on the functional side of the business

•Design dimensional data models that are optimized for performance and ease of report creation

•Defining ETL/Data integration, strategy for master data and metadata management, dimensional and relational data modelling, development of ETL code and physical data models, and performance tuning towards fulfillment of business goals

•Analyze and improve efficiency, scalability, and stability of data collections, storage, and retrieval processes

•Optimize the infrastructure at both the software and hardware level

•Perform yearly capacity planning, monitoring data warehouse growth

Maintain an awareness of existing, new and emerging data warehousing technologies

Requirements

•Bachelor’s Degree from Computer Science/Information Technology, Engineering (Computer/Telecommunication) or equivalent

•Having capability in SQL query and knowledge in the database platform like MSSQL, DB2, MySQL, Oracle, Postgres, etc.

•Having knowledge in big data concept and capability in the platform like Hadoop, MapR, Cloudera, Hortonworks, etc.

•Expertise around database programming and performance tuning techniques

Advance problem resolution skills exhibiting the ability to decide complex database/data warehouse issues; successfully analyze and evaluate alternatives and draw valid conclusions

Benefits

Medical, BPJS, Transport Allowance, etc

Skills Requirements
TeamworkPlanning