UCSD Layoff from Career Appointment: Apply by 04/24/2017 for consideration with preference for rehire. All layoff applicants should contact their Employment Advisor. Eligible Disability Counseling and Consulting services (DCC) or Special Selection clients should contact their Vocational Rehabilitation Counselor for assistance.
This position has been changed from an internal UCSD posting to external as of 4/19/2017. All applicants are welcome to apply.
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.).
Bachelor's degree in related area and/or an equivalent experience/training.
Five (5) or more years relevant experience.
Professional experience, and proven success, providing database administration and management in a large scale organization.
Advanced knowledge of database management systems and standards.
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.