Job Description
The jobholder works directly with senior manager BI to analyse the business problems and provide appropriate Business Intelligence solutions by designing and implementing reporting and dashboards. The jobholder should execute technical and analytical functions to ensure smooth flow of business operations. The jobholder will be responsible for design and development of a data environment used for analytics, reporting and translates business requirements into specifications required.
Duties and Responsibilities
Your main responsibilities in this role include the following:
The jobholder is responsible to conceptualize and create interactive Dashboards with embedded analysis capability and ensures monthly reconciliation of these Dashboards. Additionally creating business metrics as dash board styled reports.
Creating the operational and analytical reports/dashboards for business, based on the requirements with an instant access to information to monitor measure and manage performance.
The jobholder is responsible to collaborate with users to identify needs and opportunities for improved data management and delivery; Gather business requirements and deliver standard reporting and analysis.
The Jobholder needs to be able to have an end-to-end vision, and to see how a logical design will translate into one or more data mart, and how the data will flow through the successive stages involved in the journey of report creation.
Support in creation of metadata/business layers by empowering users to enable the adoption of self-service reporting.
Reconcile data with the General Ledger for Portfolio balance, Interest and Fees.
Simplify and automate management reporting process to reduce close cycle time by creating, managing and providing various daily, monthly, quarterly, annual and reports to the management/departments/branches.
The jobholder is responsible for updating the Sales Achievement for Relationship Managers compared to the budget on a daily and monthly basis.
The jobholder is responsible to design automation processes to control data access transformation and movement and ensures source system data availability.
Job Requirements
Bachelor’s Degree in Computer Science/ Accounting / Finance or Equivalent
BI development experience and expertise in Business Intelligence tools such as Business Objects/Cognos/Tableau, Click view etc.
Experience in ETL Tools, Data Modelling, and Data Warehousing.
Solid understanding of SQL by writing complex SQL queries with exposure and experience of Sybase, MS SQL Server, Oracle, DB2, and Informix including T-SQL.
6+ years’ experience in Business Intelligence, enterprise level Data warehouse/business intelligence projects
ETL experience - mappings and transformations
Sound knowledge of Banking procedures, Accounting standards
Strong analytical, problem-solving, and conceptual skills.
Planning and organizing skills
Report writing and Communications skills.
Job Details
Company: Commercial Bank of Dubai - CBD
Employment Type: Full-time
Job Location: United Arab Emirates
