General Information
| Job Description | BUS INTEL SPEC 3 | Working Title | Data Analyst |
|---|---|---|---|
| Job Code | 004959 | Grade | 23 |
| Department Name | Technology Partnerships - D01278 | Department Head | Rosibel Ochoa |
| Supervisor | Rosibel Ochoa | Effective Date |
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 and experience as a seasoned business analytics professional to projects of medium size at all levels of complexity, or to portions of large, multidimensional projects. |
Department Custom Scope
| The Data Analyst will support the Office of Research and Economic Development and the Office of Technology Partnerships to improve decision making and facilitate continuous improvement of its processes and programs to maximize impact in the region. By understanding the generated data from the different processes at RED and OTP and by deriving insights the Data Analyst will help create efficiencies, maximize project outcomes and facilitate integrated grant reporting and progress reports. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
Experience Requirements
| Experience | Requirement |
|---|---|
| 4 - 7 years of related experience. | Required |
| Minimum 3 years of experience as a database administrator and with data analytics | Required |
License Requirements
Certification Requirements
| Certification | Requirement |
|---|
Educational Condition Requirements
| Condition | Requirement |
|---|
Key Responsibilities
| Description | % Time |
|---|---|
Consults with end users to gather and clarify data and reporting needs for complex business intelligence solutions and analytics. Writes queries, develops report templates, and dashboards.
|
30 |
Performs predictive analysis and forecasting to provide information that supports organizational goals. Mines data to quantify relationships and identify issues warranting further analysis.
|
25 |
Serves on internal committees and participates on cross-functional teams to solve business, process, service and/systems issues.
|
20 |
Conducts on-going analyses of data sources and data sets. Identifies issues and collaborates on developing solutions to data management challenges.
|
15 |
| Identifies and analyzes errors and problems for end users, developing and applying functional solutions and/or conducting specific training as needed. | 5 |
| Participates in developing and/or delivering curriculum for end user training to ensure user competence, data access, and optimal performance of BI tools and processes. | 5 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Strong interpersonal skills for effective collaboration with a broad range of professional and technical staff. | Required |
| Thorough knowledge of business intelligence functions, analytics, industry standards and best practices. | Required |
| Proven ability to serve as a technical resource providing advice and counsel on business intelligence issues. | Required |
| Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions. | Required |
| Strong written and verbal communication skills with the ability to convey complex information in a clear, concise manner. | Required |
| Thorough knowledge of relevant internal databases, BI applications and tools. Ability to produce high-quality reports and documentation. | Required |
| Detail oriented, with ability to manage time and organize competing priorities. | Required |
| Proficiency in data manipulation languages, including MS SQL, Oracle Database, or PostgreSQL. | Required |
| Experience using data analytics and reporting tools such as PowerBI, SAP business objects, Excel, etc. | Required |
| Ability to work under pressure in ambiguous situations. | Required |
| Basic understanding of domain business processes such as grant tracking and reporting, program management reporting, ERP (enterprise resources and planning), performance measurement and metrics development. | Required |
| Proficiency with a diversity of specialized databases, including UCOP databases, SBDC Neoserra, Wellspring Sophia and BASECAMP | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| General Supervision |
Environment
Working Environment
| Campus |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |