Data Warehouse & Integration Senior Manager

Nahdi; Makkah Region; On-site; SAR 240,000 - 360,000; Full time

Job summary

Nahdi seeks an experienced Data Warehouse and BI Architect to lead hands-on design, development and optimization of our data warehouse and BI infrastructure. You will architect ETL processes using Informatica and ODI, model data, and ensure integration across on‑premise and cloud sources to support business insights.

The role requires 8–10 years in DW/BI with strong focus on data quality, security, and performance. Expect collaboration across Finance, Operations and IT teams.

Qualifications

• Bachelor’s degree in Computer Science or related field.
• 8–10+ years of experience in data warehousing/BI design and development.
• Proficiency with ETL tools (Informatica/ODI) and data modeling.

Responsibilities

• Design, deploy and optimize data warehouse and BI solutions.
• Develop ETL processes to extract, transform and load data from on‑premises and cloud sources.
• Ensure data security, integrity and performance of DW/BI infra.
• Maintain documentation and promote reuse across on‑premise and cloud applications.

Skills

ETL design

Data modeling

BI reporting

Data integration

Data warehouse design

Education

BSc in Computer Science

Tools

Informatica

Oracle ODI

MicroStrategy

Oracle Hyperion

Oracle Exadata

Job description

This position is hands on design development and optimization of Data Warehouse and Business Intelligence Responsibility include detailed designing of the processes and integration for extract cleanse transform and load Data to Data Warehouse using engineered systems and ETL Tools ODI Informatica Must have the ability to understand the overall business requirements and integrate them into the design This individual must have required ETL design and integration skills to extract data from the source systems on premise and cloud applications E-business Suite Oracle Retail Applications Oracle Hyperion CRM Taleo etc Develop logical and physical design of Data warehouse to ensure design is consistent and well integrated with existing conceptual logical and physical application architecturesMaintain and communicate processes and standard practices related to the design development and implementation of Data warehouse and BI application solutions and patternFoster and encourage Data Warehouse solutions reuse within on premise and cloud applicationsResearch and evaluate Data warehouse BI and system integration technologies products and solutions and make recommendations on technology production introduction phase out and retirement Define data element requirements including history timeliness and frequency of dataSupport Company s Cloud Application initiatives and develop in premise and cloud application integrationsTest a Data Warehouse and BI to prepare for administer and validate the results of unit vendor component integration system acceptance deployment readiness and user acceptance testing to ensure conformance to business functional and quality requirementsDesign deploy and install data warehouse and business intelligence software and infrastructure as per the requirements of the business and evolution of technologyPerform maintenance of data warehouse and business intelligence infrastructure through specific activities such as patching upgrading troubleshooting etc in order to ensure and maximize performancePerform periodical back-ups for applications and database s in order to ensure availability of data and applications until point of failure and mitigate risk of data lossEnsure performance optimization for data warehouse and business intelligence infrastructure by reviewing configuration identifying areas of improvement and taking appropriate actions e g database and application tuning in order to maximize performanceEnsure high availability of data warehouse and business intelligence applications through specific actions e g scheduling maintenance activities increase availability of current solution etc in order to ensure limited unplanned interruptions in the performance and availability of business applications and sustain partial system failureDesign and develop automated complex and efficient ETL Extract Transform and Load processes in order to ultimately enable the business intelligence reportingManage data security by designing database and application infrastructure in alignment with data security requirements managing user access according to the business rules and processes in place monitor security compliance and mitigate security risks e g performing data masking for sensitive data in order to ensure security and integrity of dataMonitor data warehouse and business intelligence infrastructure and ETL processes by using appropriate ETL and enterprise management tools to ensure availability of data warehouse and business intelligence services with accurate dataSupport other functions of the business with specific reporting e g Finance department with business intelligence reporting by gathering requirements and building data warehouse capability e g sourcing data building visualization capability etc in order to enhance decision making process with data insightEnsure compliance with data security and integrity policies and procedures by monitoring database access and any other specific actions in order to ensure integrity security and legal complianceCreate and maintain technical documentation for all systems and servers by documenting administration activities in order to support users and for internal referenceEmployee duties are not limited only to the above-mentioned Accountabilities he she may perform other duties as nbsp

Education

BSc in computer science preferably masters in information technology related field

Experience

8 - 10 - Years of Experience

Computer Skills

MS Office Suite OCP (Oracle Certified Professional) Web Logic Servers Administration Micro Strategy (BI Solution) Oracle Exadata Database Oracle Business Intelligence Suite Enterprise Edition Oracle Hyperion Oracle Data Integrator Informatica Virtualization Data Warehouse designing Data Modeling System/Technology Integration

Languages

English Arabic