IT - Enterprise Information Management

Full Time

76046BR

Job Summary

This key position will be intergral in using data to support our Education mission. This position is responsible for the design, specifications, coding, testing, implementation, maintenance, documentation, debugging, and troubleshooting of data warehouse solutions. Its work includes analyzing source system data, designing dimensional data models, developing ETLs, and creating data visualization products such as reports and dashboards. The position plays a critical role in requirement gathering, project plan planning, technical architecture design, go-live implementation, and ongoing system support. In addition to these duties, the position is required to perform any other tasks assigned to support the department's function.
A data engineer is responsible for designing, developing, testing, documenting, and maintaining data warehouse and analytics architecture to meet UCSF's data and analytics needs.

• Collaborate with business and technology partners to gather business requirements and create architectural designs spanning UCSF missions: Education, Research, Health, and Financial and Administrative Services
• Use business domain knowledge to profile data and determine the best approaches to extract data into data warehouses.
• Design data models and ETLs to in the Education Data Warehouse for all UCSF Schools and Programs.
• Apply the Kimball dimensional data modeling technique to build and enhance the enterprise data warehouse; this ties to the need for enterprise design intention, connecting Education to other UCSF mission assets.
• Design, develop, test, document, and support new and existing ETL processes using Microsoft SQL Server Integration Services (SSIS), AWS Glue, Azure Data Factory, IBM InfoSphere DataStage, or other tools.
• Write ETL specifications for more junior data engineers to execute.
• Demonstrate fluency in SQL programming and performance tuning.
• Develop business intelligence products, such as reports and dashboards, using Tableau or other data visualization tools.
• Document business rules and metadata in the data dictionary and keep the information updated.
• Possess excellent communication skills and the ability to articulate system designs and patterns to varying levels of leadership.
• Participate in project planning, including scoping backlogs and determining estimates.
• Assume on-call duties to support the operation of reporting and analytics systems.
• Maintain appropriate business domain knowledge in healthcare, education, research, finance, and business administration.

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

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:

Department Description

UCSF: 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 education data it creates and manages. UCSF believes that leveraging 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. As part of this exciting and important endeavor, UCSF seeks a highly qualified Senior Data Engineer / Architect.
Information Technology Services: This position will reside within the Enterprise Information and Analytics team and work in close alignment with IT Education to develop an overall education data strategy and data warehouse to support the education mission at UCSF.
Enterprise Information and Analytics: EIA's vision is to advance UCSF's ability to care, heal, teach, and discover by providing ubiquitous access to relevant and high-quality information and analytics. We work with our clinical, research, education, and business customers to organize, integrate, and govern UCSF's information assets and develop targeted data sets and analyses that provide important insights.
IT Education: To better serve the Education Mission, UCSF IT has recently created a new IT Education unit, which is in a period of growth. Led by the Associate CIO for Education, this unit develops collaborative relationships, processes, and services that appropriately enable the education community to execute its mission while keeping UCSF's IT environment secure and sufficiently cost-effective. With a focus on diversity, equity, inclusion, and accessibility, this IT Education team is actively working to establish a computing architecture and services to support digital equity and digital transformation to support and advance the UCSF education mission.

Required Qualifications

• Bachelor's degree in a related area and / or equivalent experience/training.
• Must be able to work with multiple RDBMS environments such e.g. Oracle, SQL Server, MySQL, and so on.
• At least 5 years of designing and creating reports, scorecards, and dashboards using Tableau, Power BI, or any data visualization tools.
• Expertise in documenting business and functional requirements and data flows. Able to document business rules and metadata.
• Experience developing and executing complex test plans.
• At least 5 years of writing T-SQL. Experienced in writing complex SQL queries and stored procedures. Understanding of query performance tuning.
• Minimum of 5 years using at least one ETL tool such as Microsoft SQL Server Integration Services (SSIS), Microsoft Azure Data Factory, AWS Glue, IBM InfoSphere DataStage, or any ETL applications. Capable of designing and developing data extraction, integration, and transformation solutions. Demonstrate the ability to create, code, and test ETL routines. Possess an understanding of the principles of effective ETL design.
• Demonstrate effective communication and interpersonal skills. Demonstrate ability to communicate technical information to technical and non-technical personnel at various organizational levels.
• Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines.
• Demonstrate complex problem-solving skills.
• Experienced in enterprise data warehousing development, with a focus on cross-domain design in an academic setting. Possesses strong experience developing logical and physical dimensional data models with a demonstrated understanding of fact and dimension design principles. Experienced in creating database objects and applying security.

Preferred Qualifications

• Understanding of advanced statistical analytics, machine learning, and data science principles.
• Experience cloud computing and technologies.
• Experience in an Agile working environment is desired.
• Experience in one programming language such as Python, R, Java, C , C , etc.
• Advanced knowledge of secure software development
• Highly advanced skills associated with software specification, design, modification, implementation, and deployment of large-scale scope.
• Excellent project leadership and management skills.
• Able to resolve and improve performance issues. Experience in working with other technical and business teams to carry out system performance tuning.
• Experience with clinical and healthcare administration data
• Experience with healthcare, education, research, financial, or business administrative data.
• Experience with the data and business processes in ERP, CRM, business administration, tertiary education, and research proposals/grants is a plus.

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
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.

Organization

Health

Job Code and Payroll Title

000599 DATA SYS ANL 4

Job Category

Clinical Systems / IT Professionals

Bargaining Unit

99 - Policy-Covered (No Bargaining Unit)

Employee Class

Career

Percentage

100%

Location

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

Shift

Days

Shift Length

8 Hours

Additional Shift Details

M-F 8am to 5pm