Business Intelligence And Data Analyst

Crystal System; Karachi Division; On-site; PKR 1,400,000 - 2,000,000; Full time

Job summary

A leading company in Karachi seeks a skilled Data Warehouse Engineer with over 5 years of experience in enhancing BI solutions and data modeling. The role involves supporting users, data analysis, and working with various ERP systems. Ideal candidates will possess expertise in SQL, Informatica, and IBM Cognos, along with strong problem-solving abilities.

Qualifications

• 5+ years experience in BI solutions and Data Warehouse, especially with SAP ERP.
• Solid understanding of Data Warehouse Architecture and Data Modeling.
• Very good SQL programming skills, preferably with Oracle PLSQL.

Responsibilities

• Analyze user requirements for reporting and OLAP analysis.
• Develop and operate a global Enterprise Data Warehouse.
• Handle support requests and provide ad-hoc data extracts.

Skills

SQL programming

Data Warehouse modeling

Oracle PLSQL

Informatica

Cognos BI suite

SAP CDS-Views knowledge

Database Operations

Fluency in English

Education

5+ Years of Experience in Enterprise Data Warehouse Environment

Tools

Informatica PowerCenter

IBM Cognos BI suite

SAP S/4HANA

Job description

Job Description:

Tasks and Responsibilities:

· Requirements engineering: Analysis of user requirements in terms of reporting and OLAP analysis

· Develop, enhance and operate a global Enterprise Data Warehouse and Business Intelligence (BI) system, with a variety of different ERP source systems to be integrated

· Data modeling and development of data flows (ETL)

· Handling of support requests (tickets), support users, and provide Ad-hoc data extracts

Job Specification:

Education and Experience:

· 5+ Years of Experience in an Enterprise Data Warehouse Environment, and development of BI solutions in a BI platform (Frontend: IBM Cognos BI suite) and/or ETL tools (Backend: Informatica PowerCenter)

· Solid Understanding of Data Warehouse Architecture and Data Modeling

· Awareness of best practices in Enterprise Data Warehousing

· Knowledge of the SAP S/4HANA ERP data model, using SAP ERP as a source system for the Data Warehouse; ideally also knowledge of JD Edwards or any other ERP-systems

Competencies:

· Very good SQL programming (preferred: Oracle PLSQL), and Data Warehouse modeling skills

· Informatica and/or Cognos BI suite

· Knowledge about SAP CDS-Views

· Database Operations with Oracle and HANA DB

· Fluent in English language