Job Title: Senior OBIEE / OAS / OAC Developer
Location: Menands, NY
Length: 12 Months
About the Role
We are seeking an experienced Senior OBIEE / OAS / OAC Developer with strong expertise in Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Analytics Server (OAS), and Oracle Analytics Cloud (OAC). The ideal candidate should have a solid Data Warehousing background with hands-on experience in SQL, PL/SQL, RPD modeling, dashboard development, ETL, and Oracle Analytics solutions.
Key Responsibilities
Design, develop, and maintain enterprise reporting solutions using OBIEE, OAS, and OAC.
Develop and maintain RPD (Repository) models, metadata, security, and dimensional hierarchies.
Build complex dashboards, reports, scorecards, and analytical visualizations.
Develop optimized SQL and PL/SQL queries, stored procedures, and packages.
Perform Data Warehouse modeling and support ETL design and development.
Troubleshoot data issues from reports through the Data Warehouse to source systems.
Perform performance tuning, query optimization, reconciliation, and data validation.
Support code migration, deployment, version control, and change management.
Collaborate with business users to gather requirements and deliver scalable BI solutions.
Work with multiple on-premises and cloud databases.
Required Skills
8–14 years of experience in Oracle BI technologies.
Strong hands-on experience with OBIEE (11g/12c).
Experience in Oracle Analytics Server (OAS) and Oracle Analytics Cloud (OAC).
Strong experience in RPD Modeling & Development.
Expertise in Oracle SQL and PL/SQL.
Strong understanding of Data Warehousing concepts and Dimensional Modeling.
Experience developing BI Dashboards, Reports, BI Publisher Reports, Agents, and Analytics.
Experience with:
Time Series Analysis
Dimensional Hierarchies
Security Implementation
Metadata Modeling
Experience in performance tuning and troubleshooting.
Experience with ETL development and code migration.
Strong analytical and problem-solving skills.
Good to Have
Oracle ODI (Oracle Data Integrator)
Oracle BI Publisher
Oracle WebLogic Administration
Tableau / Power BI / Looker / Qlik Sense
Oracle ERP / Oracle EBS integration
OCI (Oracle Cloud Infrastructure)
Primary Skills
Oracle OBIEE (11g/12c)
Oracle Analytics Server (OAS)
Oracle Analytics Cloud (OAC)
Oracle BI Publisher
Oracle ODI
RPD Modeling
SQL
PL/SQL
Data Warehousing
ETL
Dashboard Development
Performance Tuning
Oracle Database
Oracle WebLogic
Never miss an opportunity! Create an alert based on the job you applied for.