- Manage teams and oversees the project- Data Warehouse Design / Single source of truth - ETL Pipeline- Data quality prioritize- Data Architecture- Database management- Planning and Budgeting management- Play a decision strategic for team- Work closely with C-Level to define future project- Scrum master- SQL performance tuning- Stay updated on current trends and technology in Data Management

- Lead Team- Data warehouse Design- ETL processing- Database Tuning- Data Management- Data Visualization- Deployment SOP- Business Intelligence- Decision Support System- Amazon Quicksight

• Manage the Data Warehouse (DWH) to ensure continuous support to the development of DJPK data management and related operations.• Perform ETL (extract, transform, and load) tasks and validating results internally within DJPK divisions, and with external data repository of social protection programs and other relevant ministries and institutions as required.• Perform DWH review and visualization• Translate business questions into SQL queries to answer those questions appropriately, including produce specific data mart for data operations and accuracy.• Data preparation operations, data definition, data cleansing, data merge, and constraint definition.• Define and capture data metadata and data flow for overall database collections.• Monitor and review DWH performance and integrity from user perspective, and work with technical colleagues on identification and implementation of corrective and preventative actions, as required.• Keep all activities properly documented according to the DWH application development, implementation, and maintenance• Provide data for consolidation reports

- Identify, review performance and review configuration of existing databases- Perform tuning, balancing and enhancing for increasing performance databases- Preparing failover mechanism and high-availability database- Design database backup-restore mechanism- Design and implementing database staging needed for reporting- Design and implementing Extract Transform Load (ETL) mechanism- Design and implementing database OLAP and database reporting- Delivering transfer of knowledge and transfer of know-how from Database Core application that had been developed- Recommend solution for any daily problem found in client - Maintain nondisclosure for any data and information confidentiality for all work activity - Undertake any other tasks assigned by the Project Manager

• Build, maintenance, monitor and improve performance DATAWAREHOUSE• Developing extract transform and load for Business Project (consolidate various database and other source)• Create, Manage and Enhance Databases program• Prepare and provide data to POKJA user and other BUSINESS UNIT user with integrated data design• Manage security access for database program/ data warehouse to user• Create automatic data scraping from open data website• Work closely with analyst team to define data preparation• Design and deliver end-user training and training materials also provide technical support as necessary• Troubleshoot Database tools, systems, and software• Create Web Interface database which can access from website• Create Deployment document• Create source code documentation• Create SOP services document

Major Responsibilities:- Developing extract transform and load for Business Intelligence Project- Tuning SQL query performance- Transform user requirement document into technical solution- Create user report (excel, flat file, database/data warehouse access, reporting services)- Create Deployment document - Create Technical Analysis document- Create source code documentation

• Design and implement DATAWAREHOUSE concept for client• Create transformation data from source to target process solution regarding business need• Create report for business user• Create Deployment document• Create Technical Analysis document• Create source code documentation

• Create transformation data from source to target for client regarding business need• Create POC prototype for sales• Create Report using OBIEE• Implement DRC tool (Golden Gate)• Manage internal business intelligence application (HR and Finance)• Create source code documentation

• Responsibility to create transformation data from source to target regarding business need• Handling enhancement query for improve performance

• Develop program for user regarding business need• Monitor and handle company application• Computer and network troubleshooting• User support