111820 - Sr. ETL Developer
As a federally-funded institution, UC San Diego Health maintains a marijuana and drug free campus. New employees are subject to drug screening.
#111820 Sr. ETL DeveloperInitial Review Date: Wed 10/6/2021
For the safety and well-being of the entire university community, the University of California requires, with few exceptions, that all students, faculty and staff be vaccinated against the COVID-19 virus before they will be allowed on campus or in a facility or office. For more information visit: https://ucnet.universityofcalifornia.edu/news/2021/10/flu-vaccination-requirement-for-uc-students,-faculty-and-staff-issued-for-2021-2022.html
UCSD Layoff from Career Appointment: Apply by 09/24/21 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor.
Special Selection Applicants: Apply by 10/06/21. Eligible Special Selection clients should contact their Disability Counselor for assistance.
This position will remain open until filled.
The Senior ETL Developer is responsible for top-level technical coordination and design of complex SQL data transformation and warehouse systems in a large computing environment. Incumbent designs programs collaborating with key staff and faculty from various organizational units. Prepares detailed specifications for the design, implementation, and maintenance of multiple data-marts and data warehouses linking clinical, financial, and operational data together for analytics. Guides junior ETL developers on daily operations and maintenance of systems assigned. The Sr. ETL Developer, maintains system integrity, investigates and solves performance issues as they arise, and participates in the review, install, and configuration of any SQL system that the enterprise decides to implement. The Sr. ETL Developer will be the technical expert in SQL Server Integration Services and utilize other ETL approaches when appropriate.
Involves planning databases, including schema definition, structure, documentation, long-range requirements, data security, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools. May establish database management systems, standards, guidelines and quality assurance for database deliverables. This does not include technologies that are typically deemed as desktop-centric (i.e., Access, Filemaker Pro, etc.).
Nine (9) years of related experience, education/training, OR a Bachelor’s degree in related area plus five (5) years of related experience/training
Professional experience, and proven success, providing database administration and management in a large scale organization.
Advanced knowledge of database management systems and standards.
SQL Server development
SSIS (SQL Server Integration Services - the primary ETL tool for SQL Server) development
- Tableau development
- Healthcare experience
- Epic experience
- Active Directory experience
- Mulesoft development
- Must pass a background check.
- Must pass physical, drug screen and TB test.
- Must be willing to work various hours & locations based on business needs.
Job offer is contingent on successful engagement in the UC COVID-19 Vaccination program (fully vaccinated with documented proof or approved exception/deferral).
UC San Diego Health is the only academic health system in the San Diego region, providing leading-edge care in patient care, biomedical research, education, and community service. Our facilities include two university hospitals, a National Cancer Institute-designated Comprehensive Cancer Center, Shiley Eye Institute, Sulpizio Cardiovascular Center, and several outpatient clinics. UC San Diego Medical Center in Hillcrest is a designated Level I Trauma Center and has the only Burn Center in the county. We invite you to join our dynamic team!
Applications/Resumes are accepted for current job openings only. For full consideration on any job, applications must be received prior to the initial closing date. If a job has an extended deadline, applications/resumes will be considered during the extension period; however, a job may be filled before the extended date is reached.
UC San Diego Health is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age, protected veteran status, gender identity or sexual orientation. For the complete University of California nondiscrimination and affirmative action policy see: http://www-hr.ucsd.edu/saa/nondiscr.html
UC San Diego is a smoke and tobacco free environment. Please visit smokefree.ucsd.edu for more information.