VAM Systems is currently looking for Senior Oracle Analytics Server (OAS) BI Developer for our UAE operations with the following skillsets & terms and conditions:
1. Educational Background
Bachelors or Masters degree in a relevant field such as:
o Computer Science
o Information Technology
o Data Analytics
o Business Intelligence
o Data Science or a related discipline
2.Certifications (Optional but Beneficial)
- Oracle Analytics Cloud 2022 Professional
- Oracle Database SQL Certified Associate
- Oracle Data Integration and ETL Tools Certification
- Certifications in data visualization or data storytelling (e.g. Tableau Power BI) for complementary skills.
3. Experience Requirements
5 years of experience in designing developing and maintaining Oracle BI solutions including OAS or OBIEE.
Experience in:
- Endtoend BI solution development.
- Migrating from Oracle Business Intelligence Enterprise Edition (OBIEE) to Oracle Analytics Server (OAS).
- Integrating OAS with external systems (e.g. APIs Excel or thirdparty BI tools).
4. Technical Expertise
Core Expertise in Oracle Analytics Server (OAS):
- Proficiency in building interactive dashboards pixelperfect reports and narrative visualizations using OAS.
- Strong understanding of the Oracle BI Repository (RPD):
- Physical Layer
- Business Model and Mapping (BMM) Layer
- Presentation Layer
- Experience in configuring rowlevel and columnlevel security and implementing user/rolebased access controls in OAS.
- Mastery of Oracle BI Publisher for creating formatted reports.
- Expertise in using Data Visualizations and custom features like mapbased visualizations and geospatial analytics.
Database Skills:
- Proficiency in SQL and PL/SQL for data manipulation and querying.
- Strong knowledge of Oracle Database including:
- Query optimization
- Indexing and partitioning
- Working with Oracle Autonomous Data Warehouse (ADW)
- Familiarity with other databases (e.g. SQL Server PostgreSQL) is a plus.
Data Warehousing and BI Concepts:
- Strong understanding of:
- Dimensional modeling (Star Schema Snowflake Schema)
- Fact tables dimension tables and aggregates
- ETL processes for loading and transforming data
- Experience with data warehousing tools like Oracle Data Integrator (ODI) or other ETL tools.
Performance Tuning and Optimization:
- Ability to troubleshoot and optimize the performance of:
- Dashboards
- Reports
- Queries and data models
- Experience with caching strategies materialized views and aggregate tables to improve report performance.
Cloud and Big Data Knowledge (Optional):
- Familiarity with Oracle Analytics Cloud (OAC) for hybrid or cloud deployments.
- Knowledge of integrating OAS with Big Data environments (e.g. Hadoop Spark).
- Understanding of cloud platforms like Oracle Cloud Infrastructure (OCI) AWS or Azure.
Additional Skills
- Scripting and Customization:
- Knowledge of JavaScript CSS and XML for customizing OAS dashboards and reports.
- Experience with scripting tools (e.g. Python or Bash) for automation and integration tasks.
- Big Data and Advanced Analytics:
- Knowledge of integrating machine learning models or advanced analytics features into OAS reports.
- Security and Compliance:
Expertise in configuring Single SignOn (SSO) SSL and ensuring compliance with data security standards like GDPR or HIPAA.
Soft Skills and Leadership
- Communication Skills: Ability to explain technical concepts to nontechnical stakeholders and gather business requirements effectively.
- ProblemSolving Skills: Proficiency in identifying analyzing and solving complex technical issues.
- Project Management: Experience managing BI projects setting priorities and delivering solutions on time.
- Team Leadership: Ability to mentor junior developers and work collaboratively with crossfunctional teams.
- Client Relationship Management: Skilled in managing stakeholder expectations and ensuring alignment with business goals.
Domain: Banking
Terms and conditions
Joining time frame: 15 30 days)
Additional Information :
Terms and conditions:
Joining time frame: maximum 4 weeks
Remote Work :
No
Employment Type :
Fulltime