Apply Now    

Unique! Oracle BI Developer (Secret clearance)

Req #: 238861
Location: Arlington, VA US
Job Category: Information Technology
Minimum Clearance Required: Secret

Job Description

CACI is making a significant impact to the Army by developing and integrating the Army's Integrated Personnel and Pay System-Army (IPPS-A). IPPS-A is the Army's future Web-based Human Resources (HR) solution to provide integrated HR capabilities across all Army Components. IPPS-A is designed to alleviate the Army's current reliance on 45 stove-piped HR systems that do not efficiently share information with one another. As a result of its implementation, IPPS-A will provide a centralized resource for Soldiers, Leaders, and HR Professionals to better manage personnel and pay information. Join us to be a part of this exciting and monumental effort.  Once complete, IPPS-A will be the largest integrated personnel and pay system in the world!

CACI is currently seeking an Oracle BI / Data Integration Developer for the IPPS-A program based in Crystal City, VA. The person we are seeking will provide expertise in performing application development, configuration and unit testing of Data Integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications including HR Analytics (prebuilt Warehouse, ELT, & OBIEE models) for the IPPS-A project. Participate in development, integration and deployment of solutions. Responsible for designing, developing, and supporting BI solutions based on client requirements.

What You’ll Get to Do:

  • Work closely with OBI team members, SMEs, and Testers using Agile sessions to develop high BI data models to support reporting needs.
  • Provide hands-on technical solutions to business challenges & translates them into process/technical solutions.
  • Assist with the design, development and delivery of OBIA/OBIEE application including ODI ELT, Data Integration through PL/SQL, SQL, scripts.
  • Assist with HR Analytics design, development, enhancements, configuration (BIACM, ODI).
  • Interpret requirements, performs highly complex analysis and presents options and recommendations to obtain desired results.
  • Create, update and edit functional and technical design specifications and solutions to satisfy project requirements.
  • Participate in code and design reviews and technical presentations to cross functional staff.
  • Develop technological ideas and guides development into a final product.
  • Assist with layouts, product support, devices, methods or procedures.

Qualifications that you’ll bring:

  • Must have or be able to obtain a Secret clearance.
  • Bachelor’s degree in Computer Science, Information Systems, or another technically relevant degree.
  • 5 - 7 years of overall technical experience in system design, project development and production support of large applications/systems.
  • 2 - 4 years enterprise level design and development experience using OBIA HR Analytics.
  • 2 - 4 years of experience with creating data solutions using ODI/PLSQL/SQL.
  • Knowledge of required processes for a successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
  • Strong knowledge of Oracle databases, UNIX environment, UNIX shell scripts, SQL and PL/SQL, and XML and encryption technologies.
  • Possesses knowledge of application modeling principles, concepts and techniques.
  • Ability to work collaboratively in a team environment with a strong focus on customer service and solution ownership.
  • Must have strong analytical skills and can demonstrate strong problem-solving skills.
  • Ability to communicate in a clear and concise manner and success working in Integrated Product Teams (IPTs).
  • Ability to meet deadlines and manage multiple, dynamic priorities.

These Qualifications Would be Nice to Have:

  • Possess prior experience of supporting large scale organizations with successful ERP implementation(s).
  • Knowledge of OBIEE Visual Analyzer, DVD (Data Visualizations Desktop), or other visualization tools.
  • Experience with defining and delivering Data Warehousing and Business Intelligence capabilities.
  • Experience using several different Data Warehousing methodologies.
  • Good working knowledge of integration of HR Analytics with ODI, Oracle Access Manager, PeopleSoft, BI Publisher, and SharePoint.
  • Experience with Oracle Data Warehousing and Star schemas.
  • Experience with PeopleSoft HCM 9.x.
  • Experience with OBIEE 12c.

What We Can Offer You:

  • We’ve been named a Best Place to Work by the Washington Post.
  • Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.
  • We offer competitive benefits and learning and development opportunities.
  • We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.
  • For over 55 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.

Job Location



CACI employs a diverse range of talent to create an environment that fuels innovation and fosters continuous improvement and success. At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is proud to provide dynamic careers for employees worldwide. CACI is an Equal Opportunity Employer - Females/Minorities/Protected Veterans/Individuals with Disabilities.

Apply Now