Sr. Data Engineer

Sr. Data Engineer

F_IT EIA Core and Compliance

Full Time

83376BR

Job Summary

This key position will be intergral in using data to support all areas of our mission including strategy, operations, research, patient access, and overall optimization.

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.
• Use business domain knowledge to profile data and determine the best approaches to extract data into data warehouses.
• Apply the Kimball dimensional data modeling technique to build and enhance the enterprise data warehouse.
• Design, develop, test, document, and support new and existing ETL processes using Microsoft SQL Server Integration Services (SSIS), Microsoft Azure Data Factory, IBM InfoSphere DataStage, or other tools.
• Demonstrate proficiency 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, or business administration.

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

Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.

The salary range for this position is $138,100 - $207,100 (Annual Rate).

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

This role will work with the Enterprise Information and Analytics (EIA) department to advance UCSF's institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas. The EIA department archives its goals by working with clinical, research, education, and business partners to organize, integrate, govern, and transform UCSF's data assets into actionable insight and information.

Required Qualifications

Preferred Qualifications

About UCSF

The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world's leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.

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.

Organization

Campus

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

San Francisco, CA

Campus

Mission Center Building (SF)

Work Style

Hybrid

Shift

Days

Shift Length

8 Hours

Additional Shift Details

Mon-Fri; 8-5