Organizational Area: Information Technology Services - Technology Support Services
Location: Oakland, CA
Posting Salary: salary commensurate with experience
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.
Special Conditions of Employment:
Other Special Conditions of Employment:
successful completion of a background check required
Job Close Date:
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.
Job Requirements Education/Experience: Bachelor's degree in related area and / or equivalent experience / training.
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.
4 - 6 years experience with Cognos BI Product Suite (Report Studio, Analysis Studio, Query Studio, Framework Manager, Transformer).
At least 3 - 5 years experience with Cognos Report & Dashboard Development experience.
Advanced experience analyzing and designing solutions for Cognos.
Experience with Cognos Administration, Cognos Analytics and SQL Server.
Deep experience in the SQL Server business intelligence and information processing such as data integration, reporting and analysis.
Experience with Framework Manager Dimensional Modeling, Transformer cubes, Design and Development.
Experience Implementing stored procedures and effectively writing advanced queries.
Experience with logical data design and data mapping or data conversion.
Experience building automated test scripts for work delivered. Required
Knowledge/Skills: Thorough knowledge of business and process analysis functions.
Knowledge of the design, development and application of technology and systems to meet business needs.
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. Required
Knowledgeable with working within AZURE and or AWS.
Strong experience with ETL development, preferably SSIS (MS-SQL server integration services).
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.
Demonstrated skill leading technical teams, including organizing workflow and scheduling assignments.
About us 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 corporate headquarters to the ten campuses, five medical centers and three Department of Energy National Labs and enrolls premier students from California, the nation and the world.
The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age or protected veteran status.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
About University of California Office of the President
The Office of the President is the systemwide headquarters of the University of California, managing its fiscal and business operations and supporting the academic and research missions across its campuses, labs and medical centers.