Career Center
Job Seekers, Welcome to MORS Career Center
Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus
University of California Davis
Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus
University of California Davis
Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus
Department Description
The mission of the Institute for Population Health Improvement is to create, apply and disseminate knowledge about the many determinants of health in order to improve health and health security and to support activities which improve health equity and eliminate health disparities
Job Summary
Final Filing Date : 12/17/19
Salary Range : $2,329.50 to $4,678.16
Salary Frequency : Bi-weekly
Appointment Type : Career
Percentage of Time : 100
Shift Hour : 8 hours
Location : Institute for Population Health Improvement - CalCARES Program, Alhambra Cannery
City : Sacramento
Union Representation : No
Benefits Eligible : Yes
Title has been revised to : Database Analyst and Administrator and reposted.
We offer exceptional employment benefits including medical, dental, and vision plans, generous paid vacations and holidays, excellent retirement savings and investment plans, continuing education, and reduced fee and cholarship programs.
THIS IS NOT AN H1- B OPPORTUNITY
Responsibilities
Under the direct supervision of the IT/Informatics Manager of the CalCARES program, the Database Analyst and Administrator functions as a database analyst with primary responsibilities creation and fine tuning of reporting solutions to complex systems as well as support, development and maintaining of business intelligence tools and processes. This position does also serve as the secondary position in database administration duties. The Database Analyst and Administrator consults with users, management, operations, researchers, and other stakeholders on business needs. Translates business needs into analytics/reporting requirements, and designs, develops tests, and implements reporting and analytic solutions for moderate-to-complete requests/business problems using various tool sets. The : Database Analyst and Administrator is responsible for maintaining 50+ internal and external production reports needed to support the organization, and to develop new reports in support of continuous process improvement work efforts. Other responsibilities include; collaborating with end users to identify needs and opportunities for improved data management and delivery, overseeing the ongoing development and operations of an operational data store and enterprise data warehouse; improving and streamlining processes regarding data flow and data quality to improve data accuracy, completeness, and timelines.
Required Qualifications
Intermediate experience with Crystal Reports, Microsoft SQL based databases, SQL Server, SQL Security.
Experience with Crystal Reports or MS SSRS (Reporting Services) programming.
Advanced knowledge of tools and environments; Microsoft SQL Server and its components (such as SSRS) and Crystal Reports
Experience with multi-dimensional cubes. Business Intelligence, Operational Data Store (ODS), online analytical processing (OLAP), reporting and analysis experience.
Familiarity working with large datasets.
Must be able to write complex SQL.
Experience with Microsoft SQL server BI stack (SSIS, SSAS & SSRS).
Experience with Data Warehousing and Business Intelligence principles and approaches.
Excellent verbal communication and interpersonal skills, with a proven ability to work collaboratively with all business units.
Excellent written skills.
Planning and organizational skills.
Interact with and influence cross-functionally at all levels of the organization.
Motivated self-starter, strong attention to detail, able to multi-task and prioritize.
Proactive approach to problem solving.
Work in team environment with a moderate level of noise.
Preferred Qualifications
Solid Business Intelligence development experience with an enterprise level extract, transform, load (ETL) tool.
Experience with a front-end OLAP cube software (i.e. ProClarity).
Working knowledge of Data Warehouse methodologies.
Experience in data modeling and design.
Information Systems experience in systems analysis and programming with progressively more complex projects.
Experience with and knowledge of Use Case and Functional Specification development.
Experience with and knowledge of Microsoft Team Foundation Server.
Experience with Dimensional and Relational modeling.
Experience with SQL Scripting, Stored Procedures.
Experience with modeling tools a plus (i.e., ERWin, ER/Studio, Visio).
Experience with Performance Point dashboards and SharePoint.
Familiarity with Agile, Scrum, Waterfall, etc. development methodologies.
SharePoint experience/site maintenance.
Securing SQL databases.
Developing or strong understanding of disaster recovery solutions for data systems.
EEO
The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.
For Schools of Health (SOM and SON) on the UC Davis Health job search, please apply through the Davis Campus Job Listings
To apply:
1. Visit https://hr.ucdavis.edu/careers
2. Enter the Job ID or Job Title in the Keywords search field
3. Confirm UC Davis is checked under Locations and UC Davis Health is unchecked
4. Select Search
5. Continue to apply for the job
If you have questions or if you need assistance submitting an application, please email applicanthelp@ucdavis.edu
To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucdmed/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=5&JobOpeningId=2659&PostingSeq=1
The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.
Copyright 2017 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency
jeid-4023fca8aa6bb24f8ee9d2b9aaba5b87
Internal Number: 1701839
About University of California Davis
UC Davis is the home of the Aggies — go-getters, change makers and problem solvers who make their mark at one of the top public universities in the United States. Since we first opened in 1908, we’ve been known for standout academics, sustainability and Aggie Pride as well as valuing the Northern California lifestyle. These themes are woven into our 100-plus-year history and our reputation for solving problems related to food, health, the environment and society.Our 5,300-acre campus is in the city of Davis, a vibrant college town of about 68,000 located in Yolo County. The state capital is 20 minutes away, and world-class destinations such as the San Francisco Bay Area, Lake Tahoe and the Napa Valley are within a two-hour drive.
BACK TO TOP
Powered By
Job Seekers, Welcome to MORS Career Center
Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus
University of California Davis
Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus
University of California Davis
| Database Analyst and Administrator : SOM: MED: Institution for Population Health Improvement Department-Sacramento Campus Department Description The mission of the Institute for Population Health Improvement is to create, apply and disseminate knowledge about the many determinants of health in order to improve health and health security and to support activities which improve health equity and eliminate health disparities Job Summary Final Filing Date : 12/17/19 Salary Range : $2,329.50 to $4,678.16 Salary Frequency : Bi-weekly Appointment Type : Career Percentage of Time : 100 Shift Hour : 8 hours Location : Institute for Population Health Improvement - CalCARES Program, Alhambra Cannery City : Sacramento Union Representation : No Benefits Eligible : Yes Title has been revised to : Database Analyst and Administrator and reposted. We offer exceptional employment benefits including medical, dental, and vision plans, generous paid vacations and holidays, excellent retirement savings and investment plans, continuing education, and reduced fee and cholarship programs. THIS IS NOT AN H1- B OPPORTUNITY Responsibilities Under the direct supervision of the IT/Informatics Manager of the CalCARES program, the Database Analyst and Administrator functions as a database analyst with primary responsibilities creation and fine tuning of reporting solutions to complex systems as well as support, development and maintaining of business intelligence tools and processes. This position does also serve as the secondary position in database administration duties. The Database Analyst and Administrator consults with users, management, operations, researchers, and other stakeholders on business needs. Translates business needs into analytics/reporting requirements, and designs, develops tests, and implements reporting and analytic solutions for moderate-to-complete requests/business problems using various tool sets. The : Database Analyst and Administrator is responsible for maintaining 50+ internal and external production reports needed to support the organization, and to develop new reports in support of continuous process improvement work efforts. Other responsibilities include; collaborating with end users to identify needs and opportunities for improved data management and delivery, overseeing the ongoing development and operations of an operational data store and enterprise data warehouse; improving and streamlining processes regarding data flow and data quality to improve data accuracy, completeness, and timelines. Required Qualifications
Preferred Qualifications
EEO The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy. For Schools of Health (SOM and SON) on the UC Davis Health job search, please apply through the Davis Campus Job Listings To apply: 1. Visit https://hr.ucdavis.edu/careers 2. Enter the Job ID or Job Title in the Keywords search field 3. Confirm UC Davis is checked under Locations and UC Davis Health is unchecked 4. Select Search 5. Continue to apply for the job If you have questions or if you need assistance submitting an application, please email applicanthelp@ucdavis.edu To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucdmed/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=5&JobOpeningId=2659&PostingSeq=1 The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy. Copyright 2017 Jobelephant.com Inc. All rights reserved. Posted by the FREE value-added recruitment advertising agency jeid-4023fca8aa6bb24f8ee9d2b9aaba5b87
|
Internal Number: 1701839
About University of California Davis
UC Davis is the home of the Aggies — go-getters, change makers and problem solvers who make their mark at one of the top public universities in the United States. Since we first opened in 1908, we’ve been known for standout academics, sustainability and Aggie Pride as well as valuing the Northern California lifestyle. These themes are woven into our 100-plus-year history and our reputation for solving problems related to food, health, the environment and society.Our 5,300-acre campus is in the city of Davis, a vibrant college town of about 68,000 located in Yolo County. The state capital is 20 minutes away, and world-class destinations such as the San Francisco Bay Area, Lake Tahoe and the Napa Valley are within a two-hour drive.
BACK TO TOP
Powered By
