Senior Oracle Data Warehousing Programmer - Remote

Clearance Level
Database Analysis/Design
Germantown, Maryland

REQ#: RQ130722

Travel Required: Less than 10%
Public Trust: Other
Requisition Type: Regular

We are GDIT. The people supporting and securing some of the most complex government, defense, and intelligence projects across the country. GDIT is seeking a Senior Oracle Data Warehousing Programmer  to join our team supporting the U.S. Department of Energy’s (DOE 's) Office of Corporate Information Systems Operations and Maintenance (O&M) Support Services of their Corporate Business Systems (CBSOM). As the Senior Oracle Data Warehousing Programmer you'll be providing functional/technical solutions to improve the existing design as well as build new Dashboards, Reports, KPIs, ETLs and Advanced Analytics using DOE Applications, Oracle Analytics Server (OAS)/Business Intelligence (OBIEE), Oracle Data Integrator (ODI), Visual Analyzer, Analytics, and other Oracle products. You will support DOE’s Corporate Business Systems, used by over 14,000 users to fulfill the agency’s mission to promote energy independence, progress scientific research, and protect the nation through nuclear security.

The IDW/iPortal is a single-entry point to business applications, content, collaborative tools and web sites that uses portlets to present functionality to the users focusing on strategic communications, news and finance, communities of practice, and finance tools. As a key component of the Corporate Business Systems (CBS) program, DOE relies on IDW for internal executive, management, and operational reporting. IDW provides personalized dashboards, messaging (thresholds/alerts), reporting, graphing, and data exchange capabilities to DOE executives, managers, and staff. The IDW integrates accounting, procurement, and human capital data elements.  In this role, a typical day will include:

  • Assess current implementation of OAS/OBIEE including business, data and system architecture, configurations, dashboards, ETLs, reports development, and provide recommendations and roadmaps for the future state solution architecture.
  • Installation and configuration of system environments
  • Assess DOE application modules and source data for various lines of business and architect solutions using Oracle Analytics (OA)/Business Intelligence (BI) tools and technologies.
  • Collaborate effectively with customers, users, lines of business and internal teams to come up new requirements and OA/BI solutions
  • Implement real-time optimal and scalable solutions with advanced analytics
  • Assess current data warehouse data model, and update and develop new data model using data modeling tools
  • Design and develop new OA/BI reports and ODI ETL processes following industry best practices
  • Recommend application changes based on information such as client feedback, testing, requirement changes, and technology trends
  • Responsible for development of testing solutions/test plans/scenarios
  • Conduct work group meetings, perform requirements analysis, application design, and develop functional and technical design documents
  • Participate in and conduct peer reviews as needed


  • Bachelor’s degree in Computer Science, Software Engineering or relevant discipline with 7 years of relevant experience in Extract Transform and Load (ETL) and Oracle Analytics. Without a degree 8-10 years of relevant experience is required. Two thirds of the experience needs to be in a data warehouse environment supporting Oracle Analytics with managing Oracle and Prism implementations being preferred
  • Extensive experience using OAS/OBIEE, OA/BI Apps, ODI, Advanced Analytics, and Oracle database
  • Experience with SQL, PL/SQL
  • Identify and analyze business needs versus existing applications and serve as the expert guiding through innovative solutions
  • Experience with Analytics and Data Visualization using Oracle Analytics tools and Visual Analyzer
  • Full lifecycle ODI implementation experience including data modeling, data mart design and architecture, ETL design, and advanced customization and configuration of ODI repository objects including Mappings, Interfaces, Packages, Scenarios and Knowledge Modules
  • Extensive experience configuring the OAS repository (RPD) at the physical, business model, and presentation layers to meet business requirements
  • Extensive experience developing Dashboards, Analyses, Agents, Prompts, Actions and other Presentation Services elements in OAS/OBIEE to meet business requirements
  • Experience driving continuous improvement of business processes and technical operations. 
  • Good team player, able to manage multiple assignments, and adapt to changing client needs
  • Preferred qualifications (optional)
    • ITIL v3 or v4 certification
    • Experience with ServiceNow for incident management, problem management, and service request management
    • Oracle Analytics Server and Application Express certifications
    • Functional or technical experience with federal Oracle e-Business Suite (EBS) and Unison/Compusearch PRISM
    • Experience with Oracle SOA, Oracle Identity Management, and Oracle RAC
    • Previous Department of Energy experience.


  • Full-flex work week
  • 401K with company match
  • Internal mobility team dedicated to helping you own your career
  • Collaborative teams of highly motivated critical thinkers and innovators
  • Ability to make a real impact on the world around you

Not sure this job’s the one for you? Check out our other openings at
Do you have a friend or colleague this posting describes? Let them know about the opportunity by clicking “Share.”

EDUCATION AND EXPERIENCE: BA/BS or equivalent, 8+ years of experience

The likely salary range for this position is $100,000 - $150,000, this is not, however, a guarantee of compensation or salary; rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

View information about benefits and our total rewards program.

About Our Work

We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

COVID-19 Vaccination

GDIT does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.