Was founded in 2003, supporting IBM in providing skilled resources to install - move - add -change (IMAC), and to perform other activities that relates to after sales support for IBM products in Indonesia.
To support the Strategic Objectives of IBM Indonesia in providing comprehensive end-to-end IT solutions for the community, in July 2010 IBM-JTI was transformed, re-shaping its missions, and strengthening the company with new Organizations structure, including the establishment of Business Development function that will focus in developing Solutions that will address the needs of comprehensive IT solutions of the Clients in the market.Today, IBM-JTI provides Total solution services, from IT Infrastructure aspect: Hardware and Software, to the Business aspect, which includes not only IBM Products but also other leading non IBM Products. IBM-JTI will propose the best available solutions that meet Clients needs and requirements regardless the Brand of the Products.
As an IBM company, we embrace IBM Values and Business Conduct Guidelines. IBM-JTI aims to build the company into a well established and respectable Indonesia company with a strong management team by continuing strive for excellence and commitment to quality, providing effective and efficient Solution to Clients, contributing to the country in creating job opportunities and transfer of advanced technology.
**Responsibilities**:
Perform end-to-end data warehouse development, including source to target mapping, ETL processes, and data modeling.
Collaborate with data originators to understand data requirements, fill gaps in collected data, and optimize data structures for analysis.
Review project plans, develop and test specifications, and perform comprehensive data analysis.
Provide support for existing systems, troubleshoot data and system issues, and extend tool sets for improved functionality.
Create and maintain batch jobs, online systems, and comprehensive documentation.
Identify and address data-related issues within the Data Warehouse environment and source systems.
Adapt quickly to changing needs, adjusted processes, and ambiguous situations.
Ensure high-quality service satisfaction by possessing strong customer service skill sets.
Create and maintain logical and physical dimensional data models.
**Requirements**:
Bachelor's degree in Computer Science, Information Technology, or a related field.
Proven experience working in a Data Warehouse role.
Strong proficiency in ETL programming within a Data Warehouse environment
Expertise in scripting languages such as Python, Shell, and SQL, along with PL/SQL programming skills.
Advanced SQL writing, tuning/optimization, and analytics experience.
In-depth knowledge of Data Warehousing, ETL processes, Cloud Computing, and Data Security concepts.
Experience with Cloud Platforms such as AWS, Azure, or GCP.
Familiarity with enterprise-class RDBMS (e.g., Oracle, SQL Server) and Cloud Data Warehouses (e.g., Snowflake, Redshift).
Solid understanding of database/information systems design, analysis, and development.
Experience with the development and implementation of enterprise-level data warehousing and supporting business intelligence initiatives.
Strong written/oral communication and organizational skills.
Ability to self-manage and multitask on multiple projects