Applications Program Manager 3: 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 disparitiesJob SummaryFinal Filing Date : 11/18/19Salary Range : $2,329.50 to $4,678.16Salary Frequency : Bi-weeklyAppointment Type : CareerPercentage of Time : 100Shift Hour : 8 hoursLocation : Institute for Population Health Improvement - CalCARES Program, Alhambra CanneryCity : SacramentoUnion Representation : NoBenefits Eligible : Yes 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 OPPORTUNITYResponsibilitiesUnder the direct supervision of the IT/Informatics Manager of the CalCARES program, the Application Programmer 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 Programmer 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 Programmer 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.
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 ListingsTo apply: 1. Visit https://hr.ucdavis.edu/careers2. Enter the Job ID or Job Title in the Keywords search field3. Confirm UC Davis is checked under Locations and UC Davis Health is unchecked4. Select Search5. Continue to apply for the job If you have questions or if you need assistance submitting an application, please email firstname.lastname@example.org
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.
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.