• You have already applied to this job.
Business Intelligence Officer
BI and Finance Department, Lahore
Apply By Dec 18, 2020
Job Description (total positions: 2, posted on: Nov 18, 2020)

Job Summary:

Business Intelligence Officer will capture the business requirements in concise requirement document, and conceptualize and derive logical & physical database design for Data Warehouse and establish reporting & Dashboards layer for accurate and timely delivery to business users.

Job Description:

  • Capture and document the business requirements in concise requirement document.
  • Conceptualize and derive logical database design based on requirements given by business users.
  • Developing physical data model of the Data Warehouse databases using MS SQL Server and Oracle RDBMS
  • Developing, Designing and development of Extraction-Transform-Load (ETL) processes for data warehouse and data marts.
  • Design and develop reports for effective visualization for analytics to users.
  • Running and monitoring the Scheduled ETL Jobs to ensure timely processing and refresh of Reports.

Core Competencies:

  • 1-2 years hands on work experience in Data Warehouse/Business Intelligence solution design, development and/or operations for Telco/Banking/Retail Industry.
  • Hands on skill in Data Warehouse design and development using Microsoft SQL Server/Oracle/Teradata Suite of BI Applications.
  • Good Knowledge of ETL tools, ETL scripting using custom and standard tools like IBM Data Stage, Informatica, Talend etc.
  • Hands on working experience in reporting & analysis using standard BI tools like IBM Cognos, Business Objects, Micro-Strategy. 

 

 

 

 

Required Skills

MS SQL Server, MySQL, Business Intelligence Tools, Business Intelligence,

Industry
Banking/Financial Services
Category
Management Information System (MIS)
Job Type
Full Time/Permanent ( First Shift (Day) )
Gender
No Preference
Minimum Education
Bachelors
Degree Title
BSCS / BCS /BIT/ MCS /MSCS / MIT
Career Level
Experienced Professional
Minimum Experience
1 Year(1-2 years hands on work experience in Data Warehouse/Business Intelligence solution design, development and/or operations for Telco/Banking/Retail Industry.)