Systems And Database Sr (07461)

Colorado Springs Utilities Colorado Springs , CO 80928

Posted 7 months ago

Data Warehouse and Business Intelligence Developer - Senior

Colorado Springs Utilities is hiring a Data Warehouse and Business Intelligence Developer. In this job you will build and maintain the data warehouse technical environment and the technical and business processes needed to deliver integrated data in support of operational functions, compliance requirements, and business intelligence activities.

In the role of Data Warehouse and Business Intelligence Developer, you will work in a state-of-the-art environment using the latest Oracle Cloud at Customer and ExaCC cloud solutions, utilizing Data Integration Platform Cloud (DIPC) inclusive of Oracle Golden Gate (OGG), Oracle Data Integrator (ODI), Oracle Analytics Cloud (OAC) and other related software and tools. In addition, the individual in this role will contribute to the planning, design and execution of the new enterprise data warehouse platform.


  • Collaborate and partner in the design and gathering of business needs for Business Intelligence and Analytics at Colorado Springs Utilities

  • Plan, design, build and maintain the data warehouse technical environment

  • Employ best practices and enterprise data warehouse strategies to plan, design and implement system processes that provide decision support data for knowledge workers engaged in reporting, query and analysis

  • Assist in designing a limited set of new/revised data integration patterns to fit the new platform architecture and Oracle tools

  • Design and build transactional and analytics data integration solutions using defined patterns as a part of our transition to the new Oracle Utilities Analytics Suite

  • Collaborate with and support other members of our team as they migrate and build existing and new application integration (primarily SOA-based) solutions using Oracle SOA and MFT tools

  • Mentor other technical staff on best practices and out of the box technical functionality

  • Provide clear and timely communication and documentation to technical and business audiences

  • Develop strong partnerships with other internal teams and with business customers

  • Engage in projects, small enhancements, changes and support activities

  • Learn the business practices and requirements of our customers and use best practices and patterns to meet their needs

  • Leverage patterns and automation for productivity improvement

  • Apply continuous improvement principles to our processes and documentation

  • Initiate problem solving and collaboration within our team and across units/sections

  • Champion security

  • Ensure solutions can be integrated, deployed, operated and maintained in a cost-effective and timely manner

  • Ensure technical designs are compliant with development and architecture standards

  • Produce design, release and support documents that describe how to manage the implementation and integration of technical environments that support business strategies

  • Maintain high quality business intelligence data based on the availability of information in the system(s) of records (source systems)

  • Provide data warehouse and business intelligence support by establishing and maintaining effective health and performance monitoring, responding to support requests and incidents in accordance with Service Level Agreements (SLA's) and providing root cause analysis on problems as situationally appropriate

  • Utilize appropriate tools and technological components to perform work

  • Perform Extract, Transfer and Load (ETL) development & Support using ODI

  • Perform data integration work as needed to evolve and maintain the Enterprise Data Warehouse

Why should you apply? This position rewards you with intellectually challenging work, including complex professional level data warehouse and integration design and development for mission-critical business systems. We are a cohesive team building a new data warehouse from the ground up. This is an opportunity to help us shape our data management architecture and infrastructure and to have a real impact on the organization's analytics capabilities.

Colorado Springs Utilities is widely seen as a treasured community asset, and our Information Technology team is comprised of a diverse team of professionals who take pride in delivering exceptional service to our community through new and innovative technologies. Help us develop a brand new, state of the art repository for our most treasured and strategic information assets.

What will it take to be successful in this position? The ideal candidate will have demonstrated expertise in using Oracle tools for design and development of data integration and warehousing. A Bachelor's degree in computer technology or a closely related field is desired, along with requisite experience.

The ideal candidate should have experience with 1 or more of the following Oracle data integration and management solutions:

  • Oracle Golden Gate (OGG)

  • Oracle Data Integrator (ODI)

  • Oracle Database

  • Oracle application frameworks (e.g. J2EE, ADF, OUAF, WebLogic, etc.)

In addition, experience with the following will be helpful:

  • Oracle Analytics

  • Oracle Fusion and Oracle Utilities Application solutions

  • Oracle Business Intelligence (OBI)

  • Oracle Business Intelligence Publisher

  • Oracle Enterprise Data Quality (EDQ)

  • Enterprise semantic modeling SQL Developer Data Modeler (SDDM)

  • Oracle MFT, OSB, BPEL and other SOA Suite tools

What a career at Colorado Springs Utilities can offer you...

As a community-owned enterprise for over 100 years, we offer the stability of providing a required service and commodity for our community.

We are a diverse team of professionals who take pride in delivering exceptional service to our community through new and innovative technologies.

We understand employees have competing priorities. That is why we have created an environment which embraces teamwork and flexibility.

Nestled at the base of the Rocky Mountains, Colorado Springs is the perfect blend of mountain and city living. Colorado Springs boasts breath-taking scenery, abundant recreation activities, and diverse populations. With the recent spotlight on energy in our country, energy careers are on the fast track. At Colorado Springs Utilities, we continue to innovate by using state-of-the-art technology. Our employees enjoy the satisfaction of fulfilling work that impacts our citizen owners and community daily.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Systems Administrator Sr

Lockheed Martin Corporation

Posted 2 weeks ago

VIEW JOBS 2/6/2020 12:00:00 AM 2020-05-06T00:00 Description:Position Responsibilities: * As a member of the TMAC the local SME provides on-site technical leadership/direction to crew members. * Maintains involvement in all technical issues and advises on resolutions. Supervises crew members performing software and system administration on the Integrated Tactical Warning and Attack Assessment (ITW/AA) assets in support of the Air Warning, Missile Warning and Space Defense missions. * Performs daily system administration tasks in support of Software Engineering, Integration and Test organizations. * Proficient in diagnosis and troubleshooting of Enterprise system issues/anomalies. Facilitates TMAC crew communications and real time on-site response. * Develops crew training modules, maintains Job Qualification Standard, and conducts requalification activities as needed. * TMAC SME will be expected to support crew shifts as needed to maintain schedule coverage. * Applies Software Change Requests per direction and approval of Software Integration. Maintains crew certification; acting backfill for crew members. * Opens or closes the Test Development Facility daily, ensuring facility is lock/unlock and alarms are activated/deactivated in accordance with Government regulations. * TMAC SME will manage time between TDF and Lockheed Martin to support forward looking tasks to provide insight and technical experience with systems, products, and changes being introduced to the ITW/AA and Legacy Space enterprise. * Qualified candidate will be expected to take knowledge and skills learned at the development/test locations and incorporate training/lessons learned to prepare local support personnel. * In addition to the TDF, the TMAC SME will be expected to provide technical support to NISSC II supported systems at PAFB Bldg 2, Bldg 1470, Bldg 1471 and the NSDC (National Space Defense Center) at Schriever AFB. * Participates in technical and programmatic meetings as needed. * Performs in support of the TMAC Lead as required. Position requires occasional shift work with the potential of extended hours and weekend support upon request. Must be willing to support on-call duty based upon a rotating schedule with other MAC SMEs. Work to be performed at Peterson Air Force Base (AFB). Basic Qualifications: Ability to perform expert level Windows and UNIX system administration * Experience with administrating a multi-level Active Directory structure is required * Experience with HP Blade Architecture and Enclosure administration. * Experience with Altiris and/ or Symantec Management Console for server/client software deployment. * Practical experience with Cisco Network Architecture, services and functionality. * Practical experience with VMware ESX to manage virtualized servers. * Experience with BEA WebLogic instances and Oracle database administration. Candidate must meet minimum certification requirement for DoD Directive 8570, "Information Assurance Training, Certification, and Workforce Management". This position requires a minimum certification associated with IAM Level I, which may be met with Security+ or higher. Candidate must possess a qualifying 8570 certification within 3 months of hire date. Initial certification expenses will not be covered by the program. Desired Skills: * Experience using HP Operations Manager for system monitoring/management. * Experience with LAN/WAN network architecture, services, and functionality is required * Experience with any of the following platforms/applications is a desired: HP blade architecture, HP Operations Manager, HP Remote Graphics Software, LINUX, Six VMWare, Cisco and Juniper switch platforms, NetApp, and vSphere Virtual Center Server, Solaris 10, Oracle DB. * Experience Cloning and Reimaging Windows and Solaris servers. * Familiarity with IBM Time Sharing Option (TSO) and Multiple Virtual Storage (MVS) operating systems. Lockheed Martin Corporation Colorado Springs CO

Systems And Database Sr (07461)

Colorado Springs Utilities