We are hiring an experienced Oracle Data Warehouse (DW) Associate to join a dynamic enterprise data team to be based in Riyadh. The ideal candidate will have strong expertise in Oracle EBS and data warehouse implementation, with hands-on experience in ETL development and enterprise reporting solutions.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field
- 7 years of experience in Oracle Data Warehouse implementation with Oracle EBS
- Strong hands-on experience with Oracle EBS (HR, Finance, Supply Chain)
- Expertise in ODI or similar ETL tools
- Strong SQL development and performance tuning skills
- Good understanding of data warehouse best practices
- Experience in data governance and data quality frameworks
- Solid understanding of Oracle EBS business processes
- Fluent in Arabic with strong written and spoken proficiency in English.
- Candidates must be locally available in Saudi, preferably in Riyadh, with transferable Iqama
Responsibilities:
- Design, develop, and maintain data warehouse architecture (Star & Snowflake schemas)
- Build and support ETL pipelines using Oracle Data Integrator (ODI) or similar tools
- Extract, transform, and load data from Oracle E-Business Suite (HR, Finance, Supply Chain)
- Work closely with Oracle EBS modules to map and integrate source data into the warehouse
- Ensure data quality, consistency, and integrity across all data pipelines
- Develop and optimize complex SQL queries for transformation and reporting
- Support BI reporting tools such as Power BI by delivering clean datasets
- Monitor ETL jobs, troubleshoot failures, and ensure smooth data flow operations
- Collaborate with business and IT teams to gather reporting requirements
- Document data models, data flows, and ETL architecture
