Job Description

Virtual Vision

Business Intelligence & Data Warehouse Professional

Bookmark and Share

Job id: 257196

08 Jan 2019

Job Location

Eastern Province, Saudi Arabia

Experience

3 to 7 years

Qualification Level

Graduate; Engineering Graduates/PG; Management Post Graduates

Job Function

Corporate Planning / Consulting
IT - Hardware
IT - Software

Skillset

Architecting, optimizing and maintaining enterprises databases, IBM Cognos version 10/11 for developing reports, dashboards, KPI’s.

Jobseeker Nationality

Jobseekers from any country

Business Intelligence & Data Warehouse Professional

Job Location : Eastern Province

Good Salary Package will be offered

Job Description :

• Enterprise wide Data Warehouse Administration and Development
• Dimensional Data Modeling and Oracle OLAP cubes development.

Qualifications and Experience :

• Bachelor’s degree in Computer Science & Software Engineering or Equivalent.
• 3 years’ experience in Data Warehouse Administrator.
• Certification in Oracle ODI is a must
• 2 years’ experience in IBM Cognos version 10/11 for developing reports, dashboards, KPI’s.
• 2 years’ experience in Tableau Qlik for dashboards and mobile apps.
• Experience in a higher Education / University environment is preferred.

Duties and Responsibilities :

• Data warehouse and Server administration.
• Maintenance and development of ETL mappings in Oracle Data Integrator 11g.
• Design and Implement Data Warehousing and Business Intelligence solutions using Dimensional Modeling and Star Schema.
• Designing backup and recovery Policy for the Enterprise Data warehouse (EDW)
• Maintain data Quality and Integrity of EDW.
• Integration of diverse data sources with the EDW.
• Developing .Analysis Model for the business subject areas.
• Developing identifying KPls, developing dashboards, and mobile apps.
• Developing Oracle OLAP cube models.
• Working with Techno-Functlonal consultants to Identify and understand Source Data Systems.
• Map Source System Data to EDW Data Model.
• Develop and test extraction, transformation, and load (ETL) processes.
• Define and capture Meta Data and rules associated with ETL processes.
• Query Tuning for performance.
• Use Business Intelligence tools and OLAP to generate cubes and analytical reports on large volumes of data.

Knowledge, Skills and Abilities required :

• Experience in architecting, optimizing and maintaining enterprises databases
• ETL/Data profiling experience using Oracle ODI
• Data Architect / Modeling experience using Oracle AWM.
• Expert knowledge of SQL/PL/SQL
• Knowledge off Oracle Query tuning and use of Query hints & indexes.
• Excellent grasp of databses design normalization, denormalization, physical database design, relational models and dimensional modelling.
• BI experience with strong understanding of DWH concepts, datamodelling concepts and design.
• Strong Analytical skills.
• Excellent written and Oral communication skills and the ability to work as part of a team in a dynamic fast paced environment are also required.
• Must have strong capacity for attention to detail and be able to document work.

Interested candidate can apply with your updated resume

Disclaimer: GotoGulf is a platform that facilitates recruiters and jobseekers reach out to each other. Applicants are advised to research the bonafides of recruiters independently. We do not endorse requests for money payments and strictly advise against sharing personal or financial information. If you suspect malpractice, please email to us.