Business Intelligence Analyst

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

Job summary

Join a dynamic and innovative team dedicated to transforming data and analytics for clients. In this role, you will become the subject matter expert in automating data extraction and optimizing integration processes between various systems. Collaborate with internal teams and customers to drive technical development and provide solutions to complex business challenges. If you are passionate about data and eager to make an impact in a forward-thinking environment, this opportunity is perfect for you!

Qualifications

• Experience with data integration and automating data extraction.
• Knowledge of various databases and programming languages.

Responsibilities

• Prepare complex data structures and implement ETL pipelines.
• Support in the conception of business intelligence solutions.

Skills

T-SQL querying

Analytical skills

Problem-solving

Communication skills

Team player

Initiative

Education

IT-related training or degree

Tools

MS SQL Server

Postgres

Exasol

Informix

SAP Hana

Oracle

Atlassian ecosystem

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.

Responsibilities:

1. Preparation of complex data structures and information and provision through queries and procedures.
2. Implementing ETL (extract/transform/load) pipelines.
3. Use of tools to store data in databases and cubes.
4. Carrying out testing and troubleshooting in support cases.
5. Support in the conception and implementation of business intelligence solutions.
6. Independent procurement of information and close cooperation with various departments at home and abroad.
7. Defining and ensuring standards, quality and stability along the entire process chain.
8. Setting up and monitoring the processing processes, as well as carrying out performance tuning.
9. Development and updating of technical documentation.
10. Evaluation and improvement of existing integration processes.

Training and work experience:

1. IT-related training or a degree is an advantage. However, qualified career changers are also welcome.
2. Relevant professional experience integrating data between different systems desirable, but not essential.

Expertise:

1. Safe handling of T-SQL querying according to the Ansi standard.
2. Confident use of at least one programming language, such as Java, ABAP, .NET, C++, Python or similar.
3. Initial experience with various databases, such as MS SQL Server, Postgres, Exasol, Informix, SAP Hana and Oracle.
4. Initial experience in dealing with SAP S4/Hana or SAP R3.
5. 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:

1. “Hands-on” mentality, completing tasks independently, but also a team player.
2. Strong analytical and conceptual skills.
3. Good knowledge of English and Microsoft Office.
4. Communicative, goal-oriented and resilient.
5. Ability to take the initiative to create innovative and sustainable solutions.