Oracle OAS / BI Developer

Summary

CGI is an IT and business consulting services firm supporting enterprise and federal government programs. The Oracle OAS/BI Developer will design, develop, and maintain analytics, reports, dashboards, and data models for Oracle EBS financial environments while collaborating with functional, data, and technical stakeholders. The role also supports performance optimization, data governance, integrations, documentation, modernization, upgrades, and data migration activities.

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

Skills

• • 4+ years of relevant project 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/maintain IT II Non Critical Sensitive security clearance or Tier 3 (T3) investigation suitability
• Understanding of federal accounting, budget execution, or auditability requirements
• • Familiarity with DoD or federal financial data environments and associated compliance standards
• • Knowledge of Oracle Data Integrator (ODI), Oracle APEX, or PL/SQL
• • Oracle certifications in Analytics, EBS, or related tools
• • Using a Scaled Agile Framework (SAFe) 6.0 methodology to the maximum extent possible
• • Strong communication and analytical skills
• • Ability to translate functional accounting issues into clear technical requirements
• • Detail oriented, organized, and comfortable working within structured federal programs

Qualifications

Must Haves

• • 4+ years of relevant project 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/maintain IT II Non Critical Sensitive security clearance or Tier 3 (T3) investigation suitability
• Understanding of federal accounting, budget execution, or auditability requirements
• • Familiarity with DoD or federal financial data environments and associated compliance standards
• • Knowledge of Oracle Data Integrator (ODI), Oracle APEX, or PL/SQL
• • Oracle certifications in Analytics, EBS, or related tools
• • Using a Scaled Agile Framework (SAFe) 6.0 methodology to the maximum extent possible
• • Strong communication and analytical skills
• • Ability to translate functional accounting issues into clear technical requirements
• • Detail oriented, organized, and comfortable working within structured federal programs

Benefits

• Profit participation program
• Comprehensive medical, dental, and vision benefits
• Basic life and accidental death & dismemberment insurance
• Matching contributions through 401(k) plan
• CGI share purchase plan
• Flexibility and paid accrued vacation leave, ranging from 10 to 20 days per year, based on job level, years of relevant prior experience, and years of service
• 80 hours of floating holiday leave per year to observe holidays that are important to you
• At least 80 consecutive hours of paid sick/safe leave (except where applicable state/local law requires more)
• Paid parental leave, ranging from 20 to 70 consecutive business days based on circumstances of leave and applicable laws
• Bereavement leave, ranging from 1 to 7 days per year based on relationship
• Paid jury duty leave, up to time summoned
• Learning opportunities and tuition assistance
• Wellness and Well being programs
• Remote work arrangement