Business Intelligence Developer
Salary: $58,500 - $87,000
Title: Business Intelligence Developer
Category: Management and Professional
Department: Enterprise Info Systems
Date Posted: 04/06/2017
Position Information: 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.
Minimum Requirements: 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.
Additional Information: 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 the resources to explore, engage, imagine and excel.
At UC Riverside we celebrate diversity and are proud of our #12 ranking among the nation for most diverse universities (US News and World Report 2013-2014). Become part of a place that fosters success for all its constituents, students, faculty, and staff, and where work/life balance and campus culture are integral to our way of life.
UCR is ranked 55th among top public universities (US News and World Report 2013-2014).
The University of California is an Equal Opportunity/Affirmative Action Employer with a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by law.
For information about our generous employee benefits package, visit: Employee Benefits Overview