Oracle OAS / BI Developer

The Oracle OAS/BI Developer role supports the Defense Logistics Agency program by designing, building, and maintaining Oracle EBS reports and dashboards using Oracle Analytics Server and OBIEE lineage within a federal financial management environment. This onsite position is based in Arlington, VA, with a salary range of USD 89,600 - 176,300 per yearly.

Responsibilities

• Design, develop, test, and deploy reports, dashboards, KPIs, and data visualizations in Oracle OAS.
• Collaborate 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 such as GL, AP, AR, PO, Projects, and Costing.
• Optimize SQL queries and BI data models for performance, accuracy, and scalability.
• Ensure compliance with DLA and 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 needed.
• 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 a related field.
• 4+ years of experience developing with Oracle OAS, OBIEE, or Oracle Analytics Cloud (OAC).
• Hands-on experience with Oracle EBS R12 (financials).
• 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 the required government clearance.

Technologies

• OBIEE
• Oracle Analytics Server (OAS)
• Oracle Business Intelligence
• Oracle APEX (App Express)
• Oracle Fusion
• Oracle E-Business Suite (EBS)
• Oracle Data Integrator (ODI)
• PL/SQL

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 vacation leave, 10 to 20 days per year, based on role, experience, and tenure
• 80 hours of floating holiday leave per year
• At least 80 consecutive hours of paid sick/safe leave
• Paid parental leave, 20 to 70 consecutive business days depending on circumstances
• Bereavement leave, 1 to 7 days per year based on relationship
• Paid jury duty leave, up to time summoned
• Learning opportunities and tuition assistance
• Wellness and wellbeing programs

Position Description

We seek an Oracle OAS/BI Developer with hands-on experience in designing, building, and maintaining reports and dashboards for Oracle EBS environments to support a Defense Logistics Agency program. The ideal candidate converts functional and financial requirements into reliable, performant analytics using Oracle Analytics Server, OBIEE lineage, and Oracle data models. This role supports an enterprise federal financial management environment. This position can be located anywhere in the Continental United States.

What You Can Expect From Us

• CGI fosters ownership, teamwork, respect, and belonging, with opportunities to grow and contribute meaningfully from day one.
• You will be part of a collaborative environment where ideas and capabilities are scaled across a global organization.
• You will engage with leaders who support your skill development and career progression.
• CGI is one of the largest IT and business consulting firms globally, offering diverse opportunities.
• CGI is an equal opportunity employer. Qualified applicants will receive consideration without regard to race, ethnicity, religion, gender, disability, veteran status, or other protected characteristics. CGI also provides reasonable accommodations during the application process and for qualified individuals with disabilities.
• For applicants needing accommodations to apply, contact CGI U.S. Employment Compliance with reference to the Position ID.
• CGI supports veterans and transitioning service members through dedicated programs.
• Employment is contingent upon successful completion of a background investigation, which may include a credit check depending on role and governmental requirements.
• CGI maintains policies regarding pay transparency and confidentiality of compensation information as required by law.