Data Warehouse Manager

Job Summary

As a preeminent health sciences campus and health system, the University of California, San Francisco (UCSF) is at the forefront of creation new knowledge from the exploding volume of clinical, discovery, and education data that it creates and manages. UCSF believes that the ability to leverage these data assets is an important differentiator for an academic healthcare center and is critical to our drive toward Precision Medicine and the execution of key UCSF strategies for the Clinical Enterprise. These strategies include supporting better population health by improving the quality of care and population health of the University of California health system’s 14 million patients. As part of this exciting and important endeavor, UCSF is seeking a highly qualified Manager on the Enterprise Information & Analytics – Health team.

UCSF IT Enterprise Information and Analytics (EIA) department is looking for a Data Warehouse Manager to join the team. The Data Warehouse Manager will be responsible and take ownership in supporting the EIA data and analytics portfolio that includes, but is not limited to, resources that manage back-end data curation, data visualization, business data strategy, data governance, and other data warehousing and data science needs in the future to support the needs of EIA. This role will also work closely with other UCSF IT teams. The Data Warehouse Manager will also recruit and manage a strong engineering team, set direction, set goals, plan for their career growth, and provide mentorship for the team.  In addition, the Data Warehouse Manager on the Enterprise Information & Analytics – Health team will be responsible for developing and implementing an enterprise data strategy that aligns enterprise information assets with business and technology strategy. This will include documenting and rationalizing multiple data repositories and organizing them into a logically networked, highly scaled, enterprise data warehouse (EDW) containing clinical, financial operational, research and educational data. The Manager on the Enterprise Information & Analytics – Health team will enable the efficient and actionable use of data across the UCSF Enterprise.

The Data Warehouse Manager will work with key business leaders and stakeholders, EDW and analytics management, data governance staff, primary and secondary data owners, and BI and data management professionals to:

• Define and implement a data strategy and roadmap for UCSF
• Define and document the data architecture for enterprise data assets, working with business and IT stakeholders throughout the enterprise
• Develop conceptual, logical, and physical data models with associated metadata, including data lineage and technical data definitions
• Oversee the extraction, transformation, and loading (ETL) processes to ensure accurate and timely data integration from various source systems.
• Coordinate, collaborate and influence across disparate domains, entities, business units, departments and levels as needed to establish and provide standards, define, and prioritize data analytics and reporting requirements, ensuring alignment with organizational goals.
• Define governance policies and establish standards for modeling, structuring, naming, describing, securing and formatting data, ensuring data integrity, security, and compliance with regulatory requirements.
• Collaborate with IT and other departments to implement data governance and data management best practices across the organization.
• Leads in design and implement data models, data marts, and dimensional schemas to support efficient and effective data retrieval and analysis.
• Build a centralized data-architecture practice in support of strategic business and IT goals
• Manage a team of data engineers and analysts, providing guidance, support, and performance feedback.
• Stay up-to-date on industry trends and advancements in data warehouse management and healthcare data standards, identifying opportunities for system enhancements and process improvements.
• Support the development and implementation of data analytics and reporting tools and technologies, such as data visualization and business intelligence platforms.
• Disseminate program strategies, activities and accomplishments
• Lead efforts to implement a reference data and master data management plan
• Supervise, hire, train, counsel staff. Develop and deliver performance appraisals.

The Manager on the Enterprise Information & Analytics – Health team will stay abreast of current and emerging data management technologies and trends and advice on how they can be used to support business and technology objectives. The Manager will create a framework in information assets for multiple business domains that can be delivered in a consistent, standards-based framework. The successful candidate will have leadership skills, be customers focused and have extensive experience in developing enterprise data architecture solutions. This manager will have a focus in the UCSF Marketing domain.

UCSF Health Patient Experiences has been a top organizational goal for years and raises the profile of UCSF Health, improves professional recognition, and helps foster sustainable growth by clearly and consistently communicating why UCSF is the best place to come for care. The Data Warehouse Manager will lead efforts to provide critical data, analyze insights, and strategic support to the Health Service Excellence Department and enterprise Business Units.

The final salary and offer components are subject to additional approvals based on UC policy.

To see the salary range for this position (we recommend that you make a note of the job code and use that to look up): TCS Non-Academic Titles Search (ucop.edu)

Please note: An offer will take into consideration the experience of the final candidate AND the current salary level of individuals working at UCSF in a similar role.

For roles covered by a bargaining unit agreement, there will be specific rules about where a new hire would be placed on the range.

To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html

Department Description

The Enterprise Information & Analytics – Health team functions as a liaison between the customer or partners in the organization (including clinical, financial, administration, education, and research domains) and technical resources to provide optimal analytic solutions to solve problems, answer questions and meet the needs of our customers. The team is involved in strategic and operational activities to drive change in behavior and ultimately outcomes through the use of data and information.

Required Qualifications

• A Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field
• 7 - 10 years experience in healthcare or related field
• 5+ years’ experience architecting and modeling data management solutions in the healthcare or related industry
• Successful track record of eliciting, defining, creating, and analyzing functional and non-functional requirements, developing system design and architecture, system configuration, testing, and deployment. With proven aptitude in the delivery of high-quality products in short timelines
• Strong critical thinking and problem-solving skills to lead teams, manage complex information, assess problems, and develop effective solutions.  Ability to demonstrate excellent judgment, attention to process and detail.
• Strong analytical skills and knowledge in documentation and reporting, with the ability to collect and analyze system performance data, and produce substantive reports and analyses
• Customer Service
  • Utilize excellent customer service skills to build service-based relationships with Medical Center and Campus customers.
• Demonstrate exceptional leadership skills and proven success in managing and motivating teams, creating an atmosphere of trust, and encouraging improvement and innovation
• Prioritization
  • Demonstrated ability to determine relevance and prioritize tasks
  • Able to prioritize effectively according to department and / or customer needs, and ability to organize a large number of changing variables.
  • Detail-oriented, with ability to manage time and organize competing priorities.
• Other duties as assigned
• Leadership:
  • Dependable, self-motivated, and able to work with minimal supervision.
  • Have a strong sense of leadership & entrepreneurial spirit.
  • Be a self-starter & highly respected people leader.
  • Be result-oriented.
    • High level of accuracy and attention to detail
• Expertise in the fields of data quality, data profiling, data security, Master Data concepts, and data migration
• Ability to define and implement technical processes and data systems
• Broad, working knowledge of MS SQL, Oracle, and other DB systems
• Manage several priorities and tasks
• Demonstrate leadership skills and proven success in managing and motivating teams, create an atmosphere of trust, and encourage improvement and innovation
• Working knowledge of information security best practices and demonstrated commitment to information security
• Strong leadership, interpersonal, influencing, collaboration, and negotiation skills
• Ability to communicate with high proficiency, both verbally and in writing, with all levels of management and staff, in both technical language and layman’s terms
• Ability to work independently with minimum supervision
• Able to prioritize effectively according to department needs, and ability to organize a large number of changing variables
• Ability to assess and solve complex technical problems
• Experience in developing technical staff

Preferred Qualifications

• Masters in related field preferred 
• Epic Clarity, Caboodle, Cogito Certifications
• 8+ years of architecting and modeling data management solutions
• 8 years performing data science and data analytics
• Experience in healthcare business data management, analysis, and support, or IT consulting
• Experience in IT project / Software development across full systems development lifecycle
• Experience working with agile development process
• Consulting experience a plus – a professional service industry environment within a global matrix
• Experience with Epic Clarity and Cogito
• Experience with financial, operational, HR, payroll, and research data

About UCSF

At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what’s possible for the patients we serve – a promise we share with the professionals who make up our team.

Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report – UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California San Francisco is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

Job Code and Payroll Title

000675 DATA SYS MGR 1

Job Category

Clinical Systems / IT Professionals

Bargaining Unit

99 - Policy-Covered (No Bargaining Unit)

Location

Mission Center Building (SF)

Additional Shift Details

Monday - Friday