General Information
| Job Description | APPLICATIONS PROGR 3 | Working Title | Business Intelligence Developer |
|---|---|---|---|
| Job Code | 007300 | Grade | 22 |
| Department Name | Enterprise Info Systems - D01135 | Department Head | |
| Supervisor | Effective Date | 07/17/2017 |
Position(s) Directly Supervised
| Job Code | Title | FTE |
|---|
Generic Scope
| Experienced professional who knows how to apply theory and put it into practice with in-depth understanding of the professional field; independently performs the full range of responsibilities within the function; possesses broad job knowledge; analyzes problems / issues of diverse scope and determines solutions. |
Custom Scope
| Applies skills as a seasoned, experienced software professional with a full understanding of industry practices, community standards and relevant policies and procedures to medium-sized projects or portions of large projects with moderate scope and complexity. Resolves a wide range of issues. Demonstrates competency in selecting tools, methods and techniques to obtain results. |
Department Custom Scope
| Under the general supervision of Computing and Communications Senior Director of Enterprise Solutions, the purpose of this position is to promote effective and high quality reporting solutions that meet the University's requirements using Cognos Business Intelligence. 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 & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
Experience Requirements
| Experience | Requirement |
|---|
License Requirements
Certification Requirements
| Certification | Requirement |
|---|
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
Plans, designs, develop, modify, debugs, deploys and evaluates complex software for functional areas. Analyzes existing software or works to formulate logic for new complex systems and devises complex algorithms. Performs complex data analysis and tests/debugs complex software. Analyzes the design and use of complex data sources. Applies moderately complex programming security practices.
|
35 |
| Negotiates, develops and executes moderately complex test plans. Develops conversion and system implementation plans. Trains users in conversion and implementation of system. Performs complex data modeling, performance and integration testing and builds interfaces for a variety of internal and external constituents. Monitors and employs source code control techniques and configuration management. | 35 |
| Gathers, analyzes, prepares and summarizes recommendations for approval of system and programming documentation. Recommends and implements changes in development, maintenance and system standards. Negotiates with stakeholders on the creation of software specifications. Ensures project reports are made. | 20 |
| Understands and applies industry practices, community standards and department policies and procedures relating to work assignments. Interacts with senior level internal personnel. May serve as technical lead for a software development project of moderate scope. Trains users in conversion and implementation of systems. Negotiates project plans with stakeholders. | 10 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Intermediate knowledge of secure software development. | Required |
| Advanced skills associated with software design, modification, implementation and deployment, including object-oriented programming concepts. | Required |
| Demonstrated ability to understand functional needs and how systems can support those needs. Demonstrated ability to develop conversion and system implementation plans. | Required |
| Demonstrated ability to interface with management on a regular basis. | Required |
| Demonstrated ability to contribute technical narrative to grant proposals. | Required |
| Thorough experience with identification and use of code libraries and open-source forums. | Required |
| Experience with planning for deployment and creation of feedback mechanisms. | Required |
| Demonstrated software repository skills. Demonstrated testing and test planning skills. | Required |
| Thorough experience with common programming tools. Demonstrated ability to follow software specifications. | Required |
| Demonstrated effective communication and interpersonal skills. | Required |
| Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. | Required |
| Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines. | Required |
| Demonstrated broad problem solving skills. | Required |
| Demonstrated strong SQL knowledge and tuning skills and Oracle database design, along with an understanding of different data warehousing and dimensional modelling concepts. | Required |
| Familiarity with the Linux environment, version control, and understanding of BI best practices, tools and technologies, BI development, performance tuning and support system testing. | Required |
| 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. | Required |
| 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. | Required |
| Demonstrated ability to manage security for users, roles and groups, apply patches/upgrades, and export/import definitions to synchronize multiple Cognos environments. | Required |
| Develop and implement test plans to ensure successful delivery of a project. | Required |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Must pass a background check. | Required |
| Travel may be required for developmental activities. | Required |
Other Special Requirements & Conditions
|
Level of Supervision Received
| GeneralSupervision |
Environment
Working Environment
| Campus |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: No |