General Information
| Job Description | BUS INTEL SPEC 3 | Working Title | Senior Data Analyst |
|---|---|---|---|
| Job Code | 004959 | Grade | 23 |
| Department Name | SOM Finance & Administration - D02013 | Department Head | Maria Aldana |
| Supervisor | Steven Staples | Effective Date | 04/17/2023 |
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
| Under direction from the Data Analytics Manager, this position will contribute to the growth and success of the School of Medicine (SOM) by serving as an expert in the usage of business intelligence (BI) solutions to establish high impact analytical reports/dashboards primarily relating to financial, administrative, and operational needs throughout the SOM enterprise. Specifically, the incumbent will collaborate with SOM units, IT, other analysts, end users, data owners, and BI and data management professionals to develop, maintain, and distribute reports to address the needs of the various units from a varied set of data types and sources. The BI solutions could include, but are not limited to, PowerBI, Qlik, SSRS, OBIEE, Cognos, Spotfire, SAS, R, and Looker. |
Education & Experience Requirements
Education Requirements
| Degree | Requirement |
|---|---|
| Bachelor's degree in related area and/or equivalent experience/training. | Required |
| Master's degree in related area. | Preferred |
Experience Requirements
| Experience | Requirement |
|---|---|
| 4 - 7 years of related experience. | Required |
| Five (5) years of experience designing, developing, testing and implementing secure, scalable and high-performance BI and analytic solutions; at least 3 years of experience as a BI Developer on PowerBI, Tableau, or similar solution platform. | Required |
| Proficient in developing technical specifications, presentations, training materials, user documentation, and technical documentation. Demonstrated success with overseeing software development lifecycle for enterprise-wide BI projects | Required |
| Experience with dimensional data modeling and relational databases. | Required |
| Experience with SQL and ETL | Preferred |
| BI and analytics in the Healthcare, Education, and Research. | Preferred |
| Financial reporting experience. Experience working on complex reports relating to budgeting, fund accounting, and human resource information. Ability to actively reconcile reports to identify issues. | Preferred |
License Requirements
| License | Requirement |
|---|---|
| Valid Driver License | Preferred |
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.
|
35 |
| Performs predictive analysis and forecasting to provide information that supports organizational goals. Mines data to quantify relationships and identify issues warranting further analysis. | 10 |
| Conducts industry benchmarking analysis and develops quantitative business cases. Presents recommendations to managers. | 10 |
| Identifies and analyzes errors and problems for end users, developing and applying functional solutions and/or conducting specific training as needed. | 10 |
Conducts on-going analyses of data sources and data sets. Identifies issues and collaborates on developing solutions to data management challenges.
|
10 |
| Serve as a technical leader and advisor on the BI solutions. Lead the development of BI solution prototypes that demonstrate performance and usability to business and IT stakeholders. | 10 |
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 |
Serves on internal committees and participates on cross-functional teams to solve business, process, service and/systems issues.
|
5 |
| Assist with the development of new Standard Operating Procedures (SOP) to communicate and support the BI technology used by the business unit. Supports agile process, change, and innovation. Seeks improvements in services. Consults with business units, using feedback to improve use of data analytics for end users. | 5 |
Knowledge, Skills & Abilities
| Knowledge/Skill/Ability | Requirement |
|---|---|
| Proven ability to serve as a technical resource providing advice and counsel on business intelligence issues. | Required |
| Detail oriented, with ability to manage time and organize competing priorities. | Required |
| Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions. | Required |
| Thorough knowledge of business intelligence functions, analytics, industry standards and best practices. | Required |
| Strong interpersonal skills for effective collaboration with a broad range of professional and technical staff. | 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 |
| Ability to train staff at a variety of technical skill levels. Experience in developing technical staff. | Preferred |
| Understanding of general finance and fund accounting to be able to study and learn the general ledger. | Preferred |
Special Requirements & Conditions
| Special Condition | Requirement |
|---|---|
| Travel to and from Campus/Intellicenter and between SOM sites | Required |
| Must possess or obtain a Valid CA Driver License in accordance with the California Department of Motor Vehicles, if driving a university/personal vehicle for university related business. | Required |
Other Special Requirements & Conditions
|
|
Level of Supervision Received
| General Supervision |
Environment
Working Environment
| Off campus - UC Path Intellicenter |
Other Requirements
Items Used
|
Physical Requirements
|
Mental Requirements
|
Environmental Requirements
|
Critical Position
| Is Critical Position: Yes |