Sr Data Warehouse Operations Administrator
IT - Enterprise Information Management Job Summary This key position will be integral in providing data warehouse services to support all areas of our mission including strategy, operations, education and research, patient access, and overall optimization. This position is responsible for the maintenance and growth of our data warehouse technical stack. Its work includes consulting with developers for smooth deployments, satisfying ETL deployments with established governed practices, working with other teams in the department to provision access appropriately to the warehouse, and being a general technical resource available to automate key functions. The position plays a critical role in ensuring data is ingested and curated into our data warehouse on schedule and that developers and users are made aware of the statuses of their data flows and engaged to address issues. In addition to these duties, the position is required to perform any other tasks assigned to support the department's function.
A senior data warehouse operations administrator is responsible for administering the systems environment for the UCSF Enterprise Data Warehouse, creating databases, provisioning users, and supporting data engineers to meet UCSF's data and analytics needs:
- Provisions users in Microsoft SQL Server and develops automation processes to eliminate manual effort where possible.
- Creates new databases in SQL Server, hosted in the UCSF Secure Enterprise Cloud - Amazon Web Services (AWS) environment.
- Brings AWS systems administration experience to manage the environment (e.g. EC2, EBS, DMS, S3, Lambda)
- Creates new schemas in SQL Server with appropriate attention to data security
- Supports 20+ ETL developers to host SSIS packages on Integration Services Server
- Ensures all departmental best practices for ETL packages are maintained
- Troubleshoots ETL errors with developers
- Performs day-to-day monitoring of backups/CPU/storage growth
- Manages replication tool (DMS) to create/sync and maintain new assets. Works with developers to instantiate new DMS replication tasks for new data sources and maintains DMS tasks for existing data sources.
- Maintains the UCSF ETL Framework tool in concert with legacy orchestration methods.
- Automates and maintains handshakes between DMS replication and downstream data warehouse asset curation ETLs.
- Uses and supports all UCSF service tools, including ServiceNow, PagerDuty, portfolio task management, and technical tools SSIS, SSMS, and GitHub.
- Maintains thorough and detailed documentation around deployment practices, user provisioning, and database management.
- Creates and maintains ETL packages using Microsoft SQL Server Integration Services
- Possesses excellent communication skills and the ability to articulate system designs and patterns to varying levels of leadership.
- Participates in project planning, including scoping backlogs and determining estimates.
- Assumes on-call duties to support the operation of reporting and analytics systems.
- Mentors other data systems analysts to share data warehouse administration knowledge.
- Maintains 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. 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 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 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 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 advancing UCSF's ability to care, heal, teach and discover by providing ubiquitous access to relevant and high-quality information and analytics. We do this by working with our clinical, research, education and business customers to organize, integrate and govern UCSF's information assets and then develop targeted data sets and analyses that provide important insights. Required Qualifications
- Bachelor's degree in related area OR work-related experience in information technology with emphasis on database / data warehouse systems support.
- Minimum 5 years experience overall in the following technical areas:
- Microsoft SQL Server Database Administrator
- T-SQL. Experienced in writing complex SQL queries and stored procedures. Adept at performance tuning.
- Microsoft SQL Server Integration Services (SSIS). Demonstrate the ability to create, code, and test ETL routines with a heavy emphasis on data sourcing, ingestion and transformation in multiple steps across multiple ETL jobs. Possess an understanding of the principles of effective ETL design.
- Administering and orchestrating Jobs in Microsoft Integration Services Server.
- Experience developing and executing complex test plans.
- Demonstrated familiarity with AWS tools and terms (S3, EC2, EBS, DMS).
- Possesses working knowledge of networking and firewalls.
- Demonstrate effective communication and interpersonal skills. Demonstrate ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
- Demonstrate complex problem-solving skills.
- Detail oriented technical and process documentation writing and maintenance.
- Must be able to work with multiple RDBMS environments such as Oracle, SQL Server, MySQL, and so on.
- Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines.
- Demonstrated ability to automate functions in AWS (e.g. Lambda functions, PowerShell scripts).
Preferred Qualifications
- Epic Clarity Administration or Data Model
- Experience with AWS Glue, Microsoft Azure Data Factory, IBM InfoSphere DataStage, or any other ETL tool besides Microsoft SSIS.
- Experience with cloud computing and technologies.
- Experience in Agile working environment is desired.
- Experience in one programming language such as Python, R, Java, C++, C+, etc.
- Experience with clinical and healthcare administration data
- Experience with healthcare, education, research, financial, or business administrative data.
- Experience with the Epic electronic health record databases including Clarity and Caboodle.
- 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.
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 000599 DATA SYS ANL 4 Job Category Clinical Systems / IT Professionals Bargaining Unit 99 - Policy-Covered (No Bargaining Unit) Location San Francisco, CA Campus Mission Center Building (SF) Additional Shift Details M-F 8am to 5pm |
University of California - San Francisco Campus and Health
Nov 15, 2024