Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments. Designs dimensional models with conformed dimensions, following the business processes Develops and automates ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS) Studies and understands the company’s business processes and applications, including their effect on data and reporting, and applies the knowledge gained in designing data warehouses and reports. Assembles performance statistics, analyzes them, and makes recommendations for improvements Should be proficient in Oracle SQL, PL/SQL, SQL Server. Responsible for the full range of Datawarehouse development on MS SQL Server, SSRS, SSIS, SSAS (Cube), Crystal Reports, MS Sharepoint, .Net Framework, business data analytics and all aspects of the Financial System in regard to reporting/data warehousing and data analytics. Design, develop, test and implement financial reports and dashboard using SSIS & SSRS , BI Tools (TABLEAU / QLIKSENSE). Write and run queries/stored procedures across multiple databases, troubleshoot and resolve data related issues. Assist in research and development of new business intelligence tools and techniques for report writing. Ability to understand complex program structure, strong analysis and problem-solving skills. Assist in troubleshooting data loading and data warehouse performance issues.

Surabaya