Job Details
This ad is expired.
- SR COGNOS / BI DEVELOPER
- Go to our website »
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
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