Business Intelligence Developer
8AM - 5PM
$60,100 - $89,200
Under the general supervision of Computing and Communications Senior Director of Enterprise Solutions, the purpose of this position is to create design and technical specifications and develop effective and high quality solutions that meet the University's reporting requirements using Cognos. The technical domain of the Business Intelligence (BI) Developer includes understanding BI best practices, tools and technologies, security in the environment, understanding of different data warehousing and dimensional modelling concepts, BI development, performance tuning and support system testing. Additional responsibilities include: - Creating, enhancing and maintaining Framework Manager models and reporting data structures to support business requirements using a full lifecycle implementation - Working with business users to design, develop and deploy Cognos BI 10 multi-dimensional reports (such as Dynamic Cubes and MDX) using Report Studio with data drill-down and slice-and-dice options - Creating necessary PowerCubes by using the Transformer tool - Developing and implementing test plans to ensure successful delivery of a project - Administering security for users, roles and groups - Applying patches and upgrading - Exporting / importing definitions between various environments - Strong SQL knowledge and tuning skills - Preferred familiarity with the Linux environment, Oracle database design and version control Assignments typically require advanced, current knowledge of hardware, software, systems analysis techniques, and/or specialized knowledge in administrative functions or disciplines. All software applications produced must be of the highest production quality (e.g., available 24x7 with minimal scheduled downtime). The potential user base includes virtually all campus constituents (administrative and academic) as well as users at the University of California, Office of the President.
Advanced skills associated with software design, modification, implementation and deployment, including object-oriented programming concepts.
Demonstrated ability to understand functional needs and how systems can support those needs. Demonstrated ability to develop conversion and system implementation plans.
Demonstrated ability to interface with management on a regular basis.
Thorough experience with identification and use of code libraries and open-source forums.
Experience with planning for deployment and creation of feedback mechanisms.
Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
Demonstrated effective communication and interpersonal skills.
Demonstrated ability to contribute technical narrative to grant proposals.
Intermediate knowledge of secure software development.
Thorough experience with common programming tools. Demonstrated ability to follow software specifications.
Demonstrated broad problem solving skills.
Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines.
Demonstrated software repository skills. Demonstrated testing and test planning skills.
Demonstrated strong SQL knowledge and tuning skills and Oracle database design, along with an understanding of different data warehousing and dimensional modelling concepts.
Familiarity with the Linux environment, version control, and understanding of BI best practices, tools and technologies, BI development, performance tuning and support system testing.
Create, enhance and maintain Cognos Framework Manager models and reporting data structures to support business requirements using a full lifecycle implementation as well as creation of Cognos PowerCubes using the Transformer tool.
Design, develop and deploy Cognos BI 10 multi-dimensional reports (such as Dynamic Cubes and MDX) using Report Studio with data drill-down and slice-and-dice options.
Demonstrated ability to manage security for users, roles and groups, apply patches/upgrades, and export/import definitions to synchronize multiple Cognos environments.
Develop and implement test plans to ensure successful delivery of a project.
In the Heart of Inland Southern California, UC Riverside is located on nearly 1,200 acres near Box Springs Mountain in Southern California; the park-like campus provides convenient access to the vibrant and growing Inland region. The campus is a living laboratory for the exploration of issues critical to growing communities'air, water, energy, transportation, politics, the arts, history and culture. UCR gives every student, faculty and staff member the resources to explore, engage, imagine and excel.
UC Riverside is recognized as one of the most ethnically diverse research universities in the country boasting several key rankings of which we are extremely proud.
- Washington Monthly (August 2016) ranked UC Riverside 12th in the nation in its annual University and College Survey. \
- Education Trust placed UC Riverside 9th in the nation for closing the graduation gap between black and white students by 1.7 percentage points.
- In QS World University Rankings 2016/2017, UC Riverside's Department of Philosophy is #1 in the world for the frequency with which published papers are cited by other philosophers.
- U.S. News and World Report Survey (September 2016) ranked UC Riverside 118th overall; earns "Great Schools, Great Prices."
- Shanghai Jiao Tong University (August 2016) Academic Ranking of World Universities ranked UC Riverside among the top 151 to 200 institutions. This survey bills itself as "the most trustworthy precursor of global rankings of the world's top 500 universities."
- U.S. News and World Report's Best Graduate Schools (2016) including:
- Graduate School of Education - 62nd among ranked schools
- Bourns College of Engineering - 71st among ranked schools
For information about our generous employee benefits package, visit: Employee Benefits Overview