Details
Posted: 09-Jun-24
Location: San Francisco, California
Type: Full-time
Salary: Open
Categories:
Staff/Administrative
Internal Number: 78975BR
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 (https://tcs.ucop.edu/non-academic-titles)
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
Similar Positions
-
Senior Data Warehouse Operations Analyst, University of California, San Francisco, United States, 15 days ago
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 desig...
-
Senior Data Warehouse Operations Analyst, University of California, San Francisco, United States, 6 days ago
IT - Enterprise Information Management Full Time 78975BR Job Summary This key position will be intergral in using data to support our Education mission. This position is responsible for the desig...
-
Sr. Data Analyst, University of California, San Francisco, United States, 6 days ago
IT - Enterprise Analytics Full Time 79061BR Job Summary Having significant experience, applies advanced data/information management concepts and campus / medical center / OP objectives to resolve ...
-
Sr. Project Manager, University of California, San Francisco, United States, 15 days ago
New Hospital at Parnassus Heights Full Time 78832BR Job Summary Under the direction and supervision of the Director of Medical Equipment and IT, and in close coordination with the Director of Proj...
-
Client Service Manager Revenue, University of California, San Francisco, United States, 23 days ago
Medical Group Business Services Full Time 78702BR Job Summary The Client Service Manager is a manager within the Client Service and Analysis unit. He/she will have exposure to all facets of the C...
-
Senior Business Systems Analyst, Hybrid, University of California, San Francisco, United States, 10 days ago
F_IT CLS Business Systems Dev Full Time 78872BR Job Summary Applies advanced business process and analysis concepts and organizational objectives to resolve highly complex issues where analysis of...