• You have already applied to this job.

BI Analyst

Print   |  
Industry:
Banking/Financial Services
Category:
Software & Web Development
Total Position:
1
Job Type:
Full Time/Permanent ( First Shift (Day) )
Department:
IT
Job Location:
Islamabad
Gender:
No Preference
Minimum Education:
Bachelors
Career Level:
Experienced Professional
Minimum Experience:
3 Years
Apply By:
Feb 15, 2020
Posted On:
Jan 15, 2020
Job Description

Job Objective:

  • Responsible for the Support, implementation, analysis of T2 Interfaces, enquiries, BI reports and oracle financial interfaces with T24 integration issues, Enquiries, T24 DW EXPORT module, maintenance of Data warehouse, DataMart’s, documenting data sources, maintaining the meta  data repository, monitoring and reporting on data quality reports, scorecards, dashboards and analytic tools to represent various operational, administrative and analytical data to a variety of reporting consumers

Key Responsibilities:

BI System Analysis & Support:

  • Work with business and IT management to understand and prioritize data and information needs, including the enrichment of data for: classifications and roll-ups to support analytics; building expressions and calculations; working with data stewards to clearly define and document definitions and metadata.
  • Design, implement and maintain load, stage, dimension, fact table (OLAP) structures to support the daily running of the data warehouse.
  • Solves complex technical problems related to dashboard and report design, BI tools. i.e. MS SQL Server SSIS, SSAS, SSRS, and collaborating with vendors on issues relating to data architecture and database/data warehouse/data mart design.
  • Responsible for unit, integration, stress/load testing of reports and dashboards to ensure functional and performance requirements are met.
  • Lead a group of dedicated Data Integration and Database developers in the design and implementation of reporting solutions. 
  • Work effectively with the other Business Intelligence Architects and DBA teams to ensure that all approved development and deployment procedures are followed. 
  • Coordinate the development activities during project implementation for Business Intelligence, Reporting, and Data Visualization systems.

T24 & OF Support

  • Work with finance for financial reconciliation of trial balance.
  • Daily processing of trial balance.
  • Invoice, Vendor payment, Asset depreciation integration support.
  • Integration of T24 & OF files issues rectification.
  • DW export application management.Frequency management of t24 app in DW.

Optimization: 

  • Indexing, Hashing.
  • ETL optimization.
  • DW optimization.
  • Re arrangement of CORE jobs.
  • Query Optimization.

BI Support & Troubleshooting:

  • Serve as the first point of escalation for reporting and data analysis issues that are raised by stakeholders.
  • Performing detailed data analysis, data validation and identify data quality issues. 
  • Monitor ETL jobs and troubleshoot any issues relating to the ETL jobs.
  • Maintain and support Data Warehouse Architecture.
  • Maintain the Meta data and documentation process to support the data warehouse.
  • Prioritize and schedule problems, escalate problems (when required) to the appropriately experienced technician and/or team leaders as needed. 
  • Identify and learn appropriate software and hardware used and   supported by the business to be able to give technical support when needed. 
  • Monitor all the ETL jobs to make sure they are running as   scheduled 
  • Develop technical documentation 
  • Any other duties as reasonably required.

Training & Reporting:

  • Coordinates coaching and training of other developers on business intelligence tools, reporting and analytic best practices and data visualization techniques.

Education:

  • Preferably a Bachelor’s degree in Information Systems or a related field from an HEC recognized / overseas university. 
  • Candidates with certifications in CBIP or Oracle BI will be given preference. 

Skills:

  • Experience developing large-scale systems in a controlled development and testing environment.
  • Sound understanding of Relational Data Warehousing. 
  • Solid work ethic, self-driven with the ability to work with minimal supervision
  • Strong written and oral communication skill 
  • Excellent problem-solving and quantitative skills 
  • Proficient in MS Office Suite
  • Exhibits and upholds KMBL’s values and social performance objectives.
  • Knowledge of best practices/methodologies in Data Warehousing and Multi-dimensional data modelling (OLAP) 
  • Proficiently in ETL development and maintenance with SSIS
  • Capable of utilizing Micro Strategy, Microsoft Power BI, Tableau or similar products for developing dynamic reports and dashboards 
  • Experience developing large-scale systems in a controlled development and testing environment.
  • Sound understanding of Relational Data Warehousing. 
  • Solid work ethic, self-driven with the ability to work with minimal supervision
  • Strong written and oral communication skill 
  • Excellent problem-solving and quantitative skills 
  • Proficient in MS Office Suite
  • Exhibits and upholds KMBL’s values and social performance objectives.

Duration and Nature of Previous Experience: 

  • Minimum 3 years of hands-on experience in designing and developing business intelligence applications (Reports, dashboards, data visualization applications, and data extraction procedures) in the data warehousing environment.
  • Microsoft Tabular Model design experience is preferred. 

Required Skills

Indexing, BI system, System analysis,

Contents and Compilation ©2020 Rozee.pk
©2020 All other Rights Reserved to Khushhalibank Limited.
Jobs in Pakistan
Jobs in Pakistan