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
Bachelor’s or Master’s degree in a relevant field such as:
• Computer Science
• Information Technology
• Data Analytics
• Business Intelligence
• 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:
• End-to-end 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 third-party BI tools).
4. Technical Expertise:
Core Expertise in Oracle Analytics Server (OAS):
• Proficiency in building interactive dashboards, pixel-perfect 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 row-level and column-level security and implementing user/role-based access controls in OAS.
• Mastery of Oracle BI Publisher for creating formatted reports.
• Expertise in using Data Visualizations and custom features like map-based visualizations and geo-spatial 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 modelling (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 Sign-On (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 non-technical stakeholders and gather business requirements effectively.
• Problem-Solving 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 cross-functional 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)
• The selected candidates shall join VAM Systems – UAE and shall be deputed to one of the leading Banks in UAE.
Should you be interested in this opportunity, please send your latest resume at the earliest