Special Selection Applicants: Apply by 12/01/23. Eligible Special Selection clients should contact their Disability Counselor for assistance.
This is a contract position with the possibility of extension/career conversion.
This position will work a hybrid schedule which includes a combination of working both onsite at Towne Centre Drive and remote.
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.
Active Directory experience.
Must be able to work various hours and locations based on business needs.
Employment is subject to a criminal background check and pre-employment physical.
Pay Transparency Act
Annual Full Pay Range: $78,900 - $179,900 (will be prorated if the appointment percentage is less than 100%)
Hourly Equivalent: $37.79 - $86.16
Factors in determining the appropriate compensation for a role include experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. The Hiring Pay Scale referenced in the job posting is the budgeted salary or hourly range that the University reasonably expects to pay for this position. The Annual Full Pay Range may be broader than what the University anticipates to pay for this position, based on internal equity, budget, and collective bargaining agreements (when applicable).
UC San Diego is an academic powerhouse and economic engine, recognized as one of the top 8 public universities by U.S. News and World Report. Innovation is central to who we are and what we do. Here, students learn that knowledge isn't just acquired in the classroom - life is their laboratory. UC San Diego's rich academic portfolio includes six undergraduate colleges, five academic divisions and five graduate and professional schools. The university's award-winning scholars are experts at the forefront of their fields with an impressive track record for achieving scientific, medical and technological breakthroughs.