Business Intelligence Developer
Business Intelligence Developer
Job Number Full/Part Time Schedule Salary 201702165462 Full Time 8AM - 5PM $60,100 - $89,200
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.
Education
Education Requirements Degree Requirement Bachelor's degree in related area and/or equivalent experience/training. Required
Experience
Experience Requirement Experience in other BI platforms such as Tableau. Preferred Minimum of 5 years of related experience. Required
Special Conditions
Special Condition Requirement Must pass a background check. Required Travel may be required for developmental activities. Required
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.
Preferred Qualifications
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, 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
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
Job Description Details
View complete Job Description for this position
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
Job Number Full/Part Time Schedule Salary 201702165462 Full Time 8AM - 5PM $60,100 - $89,200
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.
Education
Education Requirements Degree Requirement Bachelor's degree in related area and/or equivalent experience/training. Required
Experience
Experience Requirement Experience in other BI platforms such as Tableau. Preferred Minimum of 5 years of related experience. Required
Special Conditions
Special Condition Requirement Must pass a background check. Required Travel may be required for developmental activities. Required
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.
Preferred Qualifications
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, 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
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
Job Description Details
View complete Job Description for this position
. Apply now!Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
