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
WHAT YOU’LL NEED:
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.
WHAT GDIT CAN OFFER YOU:
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 gdit.com/careers. 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.
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.
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.