Oracle OAS / BI Developer

About the role

We are seeking an Oracle OAS/BI Developer with hands-on experience designing, building, and maintaining reports and dashboards for Oracle E Business Suite (EBS) environments to support a program for the Defense Logistics Agency (DLA).

Responsibilities

• Design, develop, test, and deploy reports, dashboards, KPIs, and data visualizations in Oracle OAS.
• Work with functional stakeholders to gather, refine, and validate analytic and reporting requirements.
• Customize and extend OAS RPD, subject areas, metadata layers, and data models supporting Oracle EBS financial modules.
• Build analyses leveraging EBS data structures (GL, AP, AR, PO, Projects, Costing, etc.).
• Optimize SQL queries and BI data models for performance, accuracy, and scalability.
• Ensure compliance with DLA/DoD data governance, security, and audit requirements.
• Perform impact analyses and deliver enhancements in alignment with change control processes.
• Support integration of OAS with EBS, ODI, and related ETL components where required.
• Prepare documentation, user guides, and support materials for reports and dashboards.
• Collaborate with technical and functional leads on modernization initiatives, upgrades, and data migration activities.

Requirements

• Bachelor's degree in computer science, Information Systems, Analytics, or related field.
• 4+ years of experience developing with Oracle OAS, OBIEE, or Oracle Analytics Cloud (OAC).
• Hands-on experience in Oracle EBS R12—particularly financials—and understanding of EBS data structures.
• Strong SQL skills, including query tuning and working with complex joins and EBS schemas.
• Experience with OAS repository development (RPD), subject areas, metadata modeling, and data lineage.
• Ability to obtain and maintain required government clearance.

Qualifications

• Familiarity with DoD or federal financial data environments and associated compliance standards.
• Knowledge of Oracle Data Integrator (ODI), Oracle APEX, or PL/SQL.
• Understanding of federal accounting, budget execution, or auditability requirements.
• Oracle certifications in Analytics, EBS, or related tools.

Skills

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Proficiency in Oracle OAS, OBIEE, and related tools.

Benefits

• Competitive compensation including profit participation program.
• Comprehensive medical, dental, and vision benefits.
• Basic life and accidental death & dismemberment insurance.
• Matching contributions through 401(k) plan, and CGI share purchase plan.
• Flexible and paid accrued vacation leave.
• Paid parental leave.
• Wellness and well-being programs.

Pay

To support the ability to reward for merit-based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $89,600.00 - $176,300.00.

Schedule

The position can be located anywhere in the Continental US.