Data Warehouse and Integration Senior Manager

Job Overview

This role requires hands-on involvement in the design, development, and optimization of Data Warehouse and Business Intelligence systems. The manager will design detailed processes and integrations for data extraction, cleansing, transformation, and loading into the Data Warehouse using ETL tools such as ODI and Informatica. A strong understanding of business needs and integration of these within the design is essential. The role demands expertise in ETL and integration from source systems, including both on-premise and cloud applications like E-business Suite, Oracle Retail Applications, Oracle Hyperion, CRM, and Taleo.

Key Responsibilities

• Design both logical and physical Data Warehouse architectures ensuring alignment with existing application frameworks.
• Maintain and communicate standards and processes for Data Warehouse and BI solution development and deployment.
• Promote reuse of Data Warehouse solutions across on-premise and cloud environments.
• Conduct research and assessments on Data Warehouse, BI, and integration technologies to advise on adoption, phase-outs, and retirements.
• Define data requirements, including history, frequency, and timeliness.
• Support cloud application initiatives through integration development for both on-premise and cloud platforms.
• Execute comprehensive testing phases including unit, vendor, integration, system acceptance, and user acceptance tests to guarantee compliance with business and quality requirements.
• Design, deploy, and install relevant software and infrastructures to meet business demands and technological advancements.
• Perform maintenance such as patching, upgrades, and troubleshooting to maximize infrastructure performance.
• Conduct regular backups to protect data and applications, minimizing risk of data loss.
• Optimize performance by reviewing configurations, tuning databases, and applications.
• Ensure high availability and minimize unplanned interruptions through strategic maintenance and availability improvements.
• Create efficient, automated, and complex ETL processes enabling effective BI reporting.
• Manage data security by designing infrastructure compliant with security policies, administering user access, monitoring compliance, and implementing measures like data masking for sensitive information.
• Monitor infrastructure and ETL processes via appropriate management tools to ensure service availability and data accuracy.
• Support business functions such as Finance via tailored BI reporting and data warehouse capabilities development to aid informed decision-making.
• Ensure adherence to data security and integrity policies by monitoring database access and enforcing compliance.
• Create and maintain comprehensive technical documentation for systems and server administration to assist users and internal teams.

Work Environment

• Fully indoor work setting.
• Schedule: 5 working days each week with 2 days off.
• Working hours: 8:00 AM to 6:00 PM including a 1-hour break.

Qualifications

• Bachelor's degree in Computer Science, preferably a Master's in Information Technology or related field.
• 8 to 10 years of professional experience in relevant roles.

Technical Skills

• Proficient with MS Office Suite.
• Oracle Certified Professional (OCP) credential.
• Administration of WebLogic Servers.
• Experience with Micro Strategy BI solutions.
• Knowledge of Oracle Exadata Database.
• Expertise in Oracle Business Intelligence Suite Enterprise Edition.
• Skills in Oracle Hyperion and Oracle Data Integrator.
• Familiarity with Informatica platforms.
• Experience with virtualization technologies.
• Strong abilities in Data Warehouse design and Data Modeling.
• Expertise in system and technology integration.

Languages

• Proficiency in English.
• Proficiency in Arabic.