Chicago, IL-Hybrid Workplace
New Orleans, Louisiana
Modesto & Roseville, California
Springfield, Ohio
Chicago, Illinois
Posted: 21-Nov-23
Location: La Jolla, California
Salary: Open
Internal Number: 126691
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.
DESCRIPTION
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.).
MINIMUM QUALIFICATIONS
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.
PREFERRED QUALIFICATIONS
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.
SPECIAL CONDITIONS
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).