Job Details

This ad is expired.
University of California Office of the President
  • Position Number: 2248046
  • Location: Oakland, CA
  • Position Type: Computer and Information Technology


SR COGNOS / BI DEVELOPER

Location: Oakland
Job ID: 17736

Job Posting

For UCOP internal applicants, please login to the internal candidate gateway at: Jobs at UCOP

UC OFFICE OF THE PRESIDENT

At the University of California (UC), your contributions make a difference. A world leader producing Nobel and Pulitzer prize recipients with over 150 years of groundbreaking research transforming the world. Choose a career where you can leverage your knowledge, skills and aspirations to inspire and support some of the greatest minds in the world, and those who will follow in their footsteps. Working at the University of California is being part of a unique institution, and a vibrant and diverse community. At the University of California, Office of the President, we propel our mission through impactful work locally, in government centers and systemwide. We are passionate people, serving the greater good.

The University of California, one of the largest and most acclaimed institutions of higher learning in the world, is dedicated to excellence in teaching, research and public service. The University of California Office of the President is the headquarters to the 10 campuses, five medical centers and three national laboratories and enrolls premier students from California, the nation and the world. Learn more about the UC Office of the President

DEPARTMENT OVERVIEW

We deliver data and technology services and, through collaboration with partners, transform the role of Information Technology to advance the UC mission.

POSITION SUMMARY

UCPath is the University of California's priority program to implement a single payroll, benefits, human resources and academic personnel solution for all UC employees. This position is expected to participate and provide business intelligence and reporting support for the UCPath PeopleSoft system for the University of California Office of the President (UCOP) and campus wide systems and applications during the implementation of PeopleSoft HCM 9.2.

The UCPath Reporting Team provides research, design, development, and support services for the production UCPath environments for infrastructure and applications. This position is in the UC PATH Reporting Group within the Technology Delivery Services (TDS) department. The incumbent will work closely with campus locations, business partners, UC Path Center, Project Team and others and collaborates with a team of technology professionals who deliver service and support to a system-wide audience.

The Cognos / BI Developer has prior experience to successfully design, develop and maintain a reporting system including creating optimal interactive dashboards, ad-hoc query and analysis, interactive reporting, enterprise reporting and analytics. Understand and effectively handle the dynamics around a data warehouse and ETL automation project. Including analysis, design, development/modification/enhancement, implementation, and troubleshooting, monitoring, performance improvement and administration functions.

Responsibilities

35%

Acts as the Cognos Administrator for the majority of UC Cognos users. Designs, develops, modifies, debugs, deploys and evaluates complex software and scripts. Develop loosely coupled object-oriented solutions that are highly testable, modularized, and reusable. Develop solutions that leverage existing enterprise frameworks, align with the overall enterprise architecture and vision, and are compliant with the established coding standards and other development principles. Work with multiple stakeholders to develop solutions against the departmental road-map. Mentor team members who are less experienced.

25%

Creates technical design documents, test plans for applications developed, prepare time estimates, develop conversion and/or integration plans as well as system implementation plans. Review and prepare flow-charting and data analysis for existing applications for potential inclusion into an existing application framework and/or building out a new application framework that could be utilized by several applications

25%

Identifies, evaluates and develops complex systems, processes and procedures. Develops complex user interface designs. Gathers, analyzes, prepares and summarizes business and user needs, documenting requirements, and revising existing system and process logic issues as necessary. Documents intricate software and processes. Creates project plans.

15%

Collaborate with core team members, subject matter experts and business partners. Proactively engages other ITS teams in cross-functional efforts. Openly shares plans and strives to prevent surprises within and across the organization. Communicate technical information in a clear and concise manner. Understands and communicates with business partners in business terms and uses this understanding to assure the business partner's understanding of work status, risks, issues and proposals.

Required Qualifications
  • Minimum of 4 - 6 years proven experience working in Cognos as a developer and/or administrator and with PeopleSoft HCM 9.x, including extensive work experience on at least 2 large-scale system implementation projects involving large numbers of users and multiple locations
  • Advanced experience analyzing and designing solutions for Cognos. Thorough knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs.
  • Deep experience in the SQL Server business intelligence and information processing such as data integration, reporting and analysis. Experience with logical data design and data mapping or data conversion.
  • Strong verbal and written communication skills with an ability to express complex technical concepts in business terms and translate complex business rules into technical designs.
  • Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent/related functions.
  • Ability to perform source code management and application build and deployment using tools like GitHub and TFS. Experience building automated test scripts for work delivered.
  • 3 - 5 years' experience with Cognos Report & Dashboard Development experience
  • 4 - 6 years' experience with Cognos BI Product Suite (Report Studio, Analysis Studio, Query Studio, Framework Manager, Transformer)
  • Experience with Framework Manager Dimensional Modeling, Transformer cubes, Design and Development
  • Experience with Cognos Administration, Cognos Analytics and SQL Server
  • Experience Implementing stored procedures and effectively writing advanced queries
  • Demonstrated project management skills.
  • Interpersonal skills sufficient to work with both technical and non-technical personnel at various levels in the organization. Ability to elicit and communicate technical and non-technical information in a clear and concise manner.
  • Works independently and as part of a team. Demonstrated problem-solving skills. Ability to learn effectively and meet deadlines. Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments.

Preferred Qualifications
  • Knowledgeable with working within AZURE and/or AWS
  • Strong experience with ETL development, preferably SSIS (MS-SQL server integration services)

Education
  • Bachelor's degree in related area and/or equivalent experience/training.

License/Certifications
  • PeopleSoft Application Developer I/II (preferred)
  • PeopleTools & PeopleCode I/II (preferred)

SALARY AND BENEFITS

Salary: $132,000 - 142,000 based on experience

Benefits: For information on the comprehensive benefits package offered by the University visit: Benefits of Belonging

ADDITIONAL INFORMATION

HOW TO APPLY

Please be prepared to attach a cover letter and resume with your application.

APPLICATION REVIEW DATE

The first review date for this job is (5/24/2021). The position will be open until filled.

CONDITIONS OF EMPLOYMENT

Background Check Process: Successful completion of a background check is required for this critical position. Background check process at UCOP

Smoke Free Work Environment: The University of California, Office of the President, is smoke & tobacco-free as of January 1, 2014. UC Smoke & Tobacco Free Policy

EEO STATEMENT

The University of California, Office of the President, 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, age or protected veteran status. EEO/AA Employer UC Nondiscrimination Policy

The University of California, Office of the President, strives to make this job board accessible to any and all users. If you have comments regarding the accessibility of our website or need assistance completing the application process, please contact us at: Accessibility or email the Human Resource Department at: epost@ucop.edu.

*LI-SG1



To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucop/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=19&JobOpeningId=17736&PostingSeq=1

jeid-2ac6f30fb3c69e408c3125ad396edee0





Copyright 2017 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency