Data Warehouse Manager - San Francisco, CA, United States - University of California - San Francisco Campus and Health

Description

Data Warehouse Manager (Marketing) Hybrid/Remote

IT - Enterprise Analytics

Full Time

As a preeminent health sciences campus and health system, the University of California, San Francisco (UCSF) is at the forefront of creating new knowledge from the exploding volume of clinical, discovery, and educational data that it creates and manages.

UCSF believes that the ability to leverage these data assets is an essential 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.

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.

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
Identify and prioritize data needs and projects
Coordinate, collaborate, and influence across disparate domains, entities, business units, departments, and levels as needed to establish and provide standards
Define policies and establish standards for modeling, structuring, naming, describing, securing, and formatting data
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
Undertake data modeling, sourcing, and profiling in support of specific enterprise and customer-facing data-driven initiatives
Design and implement data warehouses, marts, cubes, and universes to support analytics work product requirements
Lead efforts to implement a reference data and master data management plan
Build a centralized data architecture practice in support of strategic business and IT goals
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 advise 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 customer-focused, and have extensive experience in developing enterprise data architecture solutions. This manager will have a focus on the UCSF Marketing domain.

UCSF Health Marketing 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, research insights, and strategic support to the Health Marketing Department.

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

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

The Enterprise Analytics department functions as the 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 behaviors and ultimately outcomes through use of data and information.

A Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field
~- 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
~ Experience in developing technical staff
~ 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
~ 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

Utilize excellent customer service skills to build service-based relationships with Medical Center and Campus customers
Dependable, self-motivated, and able to work with minimal supervision
Broad working knowledge of MS SQL, Oracle, and other DB systems
Working knowledge of information security best practices and demonstrated commitment to information security
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
Masters in related field preferred
~ Epic Clarity, Caboodle, Cogito Certifications
~8+ years architecting and modeling data management solutions
~ Eight years as 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
~ Experience with Epic Clarity and Cogito
~ Experience with financial, operational, HR, payroll, and research data

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.

News & World Report - UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere.

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.

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.

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

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

DATA SYS MGR 1

Clinical Systems / IT Professionals, Professional and Managerial

Bargaining Unit

9- Policy-Covered (No Bargaining Unit)

Flexible (combination of onsite and remote work), Mission Center Building (SF), San Francisco, CA

Shift

Shift Length

Additional Shift Details

Monday - Friday

#