Business Intelligence Analyst

Two95 International Inc.; Klang City; On-site; MYR 150,000 - 200,000; Full time

Job summary

A technology solutions provider in Klang City is seeking a skilled professional to join their team. The ideal candidate will automate and optimize data extraction across various systems and integrate them using ETL processes. Experience with T-SQL and programming languages is essential, along with strong analytical skills. The role offers the opportunity to work closely with internal and customer teams.

Qualifications

• Relevant professional experience integrating data between different systems desirable.
• Initial experience in dealing with SAP S4/Hana or SAP R3.
• Understanding of ERP and CRM systems for problem-solving.

Responsibilities

• Become a subject matter expert in automating data extraction.
• Responsible for tools that enable data integration.
• Identify and drive technical development of use cases.
• Implement ETL pipelines for data processing.
• Defining standards, quality, and stability along the process chain.

Skills

T-SQL querying

Programming languages (Java, .NET, C++, Python)

Data integration experience

Analytical and conceptually strong

Hands-on mentality

Good knowledge of English

Education

IT-related training or degree

Tools

MS SQL Server

Postgres

Exasol

Oracle

SAP Hana

Job description

· Exciting tasks and topics - You will become part of an experienced and growing team that takes care of the introduction and further development of digital platforms and technologies in the area of “data and analytics”.

· Impact & Responsibility - You will become our subject matter expert in the area of automating and optimizing data extraction from customer systems.

· Diverse areas of focus: You are responsible for the tools that make data integration between customer systems and other providers (e.g. SAP S4Hana, other ERP systems, CRM systems, Atlassian ecosystem) possible.

· Competent assistance - You identify and drive the technical development of use cases, together with both internal teams and our customer teams.

· Pass on expertise - you advise other teams and help translate business problems into technical solutions.

· Preparation of complex data structures and information and provision through queries and procedures

· Implementing ETL (extract/transform/load) pipelines

· Use of tools to store data in databases and cubes

· Carrying out testing and troubleshooting in support cases

· Support in the conception and implementation of business intelligence solutions

· Independent procurement of information and close cooperation with various departments at home and abroad

· Defining and ensuring standards, quality and stability along the entire process chain

· Setting up and monitoring the processing processes, as well as carrying out performance tuning

· Development and updating of technical documentation

· Evaluation and improvement of existing integration processes

Training and work experience

· IT-related training or a degree is an advantage. However, qualified career changers are also welcome

· Relevant professional experience integrating data between different systems desirable, but not essential

Expertise

· Safe handling of T-SQL querying according to the Ansi standard

· Confident use of at least one programming language, such as Java, ABAP,

· .NET | Build. Test. Deploy., C++, Python or similar

· Initial experience with various databases, such as MS SQL Server, Postgres, Exasol, Informix, SAP Hana and Oracle

· Initial experience in dealing with SAP S4/Hana or SAP R3

· Understanding of the basic structure and function of ERP systems, CRM systems and other systems that are used in everyday business in order to be able to support problem-solving.

Soft Skills

· “Hands-on” mentality, completing tasks independently, but also a team player

· Strong analytically and conceptually

· Good knowledge of English and Microsoft Office

· Communicative, goal-oriented and resilient

· Ability to take the initiative to create innovative and sustainable solutions