As an employee you will enjoy generous benefits and work/life programs. For detailed information on Benefits for this position, click here.
A higher degree of healthcare.
All across UW Medicine, our employees collaborate to perform the highest quality work with integrity and compassion and to create a respectful, welcoming environment where every patient, family, student and colleague is valued and honored.
UW Medicine’s IT Services department has an outstanding opportunity for a Research IT Infrastructure Engineer!
UW Medicine’s Information Technology Services (ITS) department is a shared services organization that supports all of UW Medicine. UW Medicine is comprised of Harborview Medical Center (HMC), UW Medical Center-Montlake Campus (UWMC-Montlake), UW Medical Center-Northwest Campus (UWMC-NW), Valley Medical Center (VMC), UW Neighborhood Clinics (UWNC), UW Physicians (UWP), UW School of Medicine (SOM) and Airlift Northwest (ALNW). In addition, UW Medicine shares in the ownership and governance of Children’s University Medical Group and Seattle Cancer Care Alliance (a partnership between UW Medicine, Fred Hutchinson Cancer Research and Seattle Children’s). ITS is responsible for the ongoing support and maintenance of the infrastructure and applications which support all of these institutions, along with the implementation of new services and applications that are used to support and further the UW Medicine mission.
In collaboration with UW Medicine IT Services (‘ITS’) and under the general guidance of the Director of Research IT, the primary focuses of the Research IT Infrastructure Engineer (‘Engineer’) analyzes existing systems to ensure they offer adequate security and are effectively meeting the needs of researchers and their studies. This position will coordinate with all areas of the organization to see that systems are working as optimally as they should and will analyze business requirements to identify where they can integrate new hardware, operating systems, or connectivity solutions.
The incumbent will build and maintain strong, long-lasting stakeholder relationships by developing a solid understanding of Research IT infrastructure needs, current practices, pain points, and strategic initiatives. The Engineer will ensure the timely and successful delivery of Research IT infrastructure solutions according to stakeholder needs and objectives and will organize the successful planning, design, implementation and transition to support research in systems and applications that further the mission of patient care, research and teaching.
To carry out this mission, we need an experienced database administrator and infrastructure specialist who is comfortable having conversations at many different levels. This position requires the ability to work well with members of steering committees, executive leadership, project managers, developers and operational staff. This role also requires an individual with very strong experience in technology coupled with excellent communication and project management skills.
Design and Develop Data Management Solutions (35%)
Gather system requirements and design technical solutions to bridge clinical and translational research data management environments.
Participate in translating business requirements into technical solutions that address organizational, clinical and research systems needs.
Work closely with other team members on systems architecture and data integration. Collaborate with analysts and programmers to support Research IT infrastructure plan and implementation strategy.
Design and test data interfaces among clinical systems. Document source and target system data requirements. Define database / message correspondence and associated data transformations, using familiarity with health industry standards (HL7, IDC, CPT).
Design responsibilities to include participation in data source mapping, data transactional/transformation mapping, and data stream mapping, and optimization.
Participate in assessment of changes to system feeds (both structure and content) due to system/application upgrade or enhancement to determine if there is any impact to existing data transfer and/or system interface programming.
Work with project teams, staff and clients to integrate new data sources into UW Medicine’s clinical repository architectures (EMRs and data warehouses) for general access. Includes database design, interface design and business process analysis.
Design, develop and support programs to extract, transform and load (ETL) data between systems. Includes writing / debugging complex SQL, stored procedures, triggers, scripts and SSIS / DTS using MS SQL Server.
Research IT Infrastructure Support and Maintenance (35%)
Respond to technical design issues and questions for any and all matters specific to Research IT infrastructure. Responsibilities may include operational, technical and administrative elements that ensure the availability, reliability, security and performance of the servers necessary to support the needs of the researchers.
Regularly communicate with stakeholders and proactively identify any issues that might impact the on time delivery of the project and propose options to keep the project on schedule.
Design and document monitoring processes to assure the health and operation of database systems, including routine database maintenance, reorganization, backup and archive mechanisms.
Ensure performance service levels are met by monitoring database operations and resolving database performance issues through system tuning activities, performing troubleshooting techniques and taking corrective actions. Communicate operational support processes to team.
Ensure data integrity and against data losses by implementing operational procedures for scheduled database backups.
Plan, test and implement software maintenance fixes and major releases supplied by database vendors. Plan and execute data migrations for major database upgrades. Perform capacity planning and operating system configuration activities.
Participate in the planning, maintenance and implementation of all aspects of database disaster recovery and business resumption planning.
Consultation and End-User Training (15%)
Evaluate and provide expert advice and configuration support for integrating third party tools with existing systems.
Provide advice and consultation to partners and management regarding development of database technologies and interfaces.
Provide architectural expertise in analyzing, designing and developing the enterprise database systems and setting standards for operations, development and security. Participate in the design and specification of the hardware and storage architectures supporting the database platforms. Interact with business stakeholders in designing a database infrastructure to support identified business objectives.
Provide routine technical assistance for problem diagnosis, resolution and ongoing maintenance activities for partners, Senior Computing Specialists and Systems Programmers as they relate to the use and access to databases, the content of specific databases, and the relationships among enterprise data stores.
Train end users to effectively utilize assigned computer systems.
Best Practices and Technology Development (10%)
Keep up-to-date on industry trends and new technology.
Participate in technical user groups and online forums to maintain current knowledge of research infrastructure technologies and how they may be effectively used to solve business problems.
Foster the use of modern data integration principles at UW Medicine.
Collaborate with other team members to maintain best practices and create training curriculum.
Work with the Research IT teams to develop and enforce standardized methodology for the development of interface systems and participate in technology reviews and continual improvement of UWM technologies.
Participate in all aspects of improving the team, including education/training of other team members and contributing to process/communication improvement initiatives.
Work with manager to set professional goals for career development.
Act as back-up for other team members and functions, as needed.
Bachelor's degree in Computer Science, Information Technology, Business Administration, or related field or equivalent combination of education/experience.
4+ years experience must include the following:
4+ years’ progressively responsible experience in a healthcare or research IT setting.
4+ years' experience in network and security design.
Significant experience in clinical or biomedical research environment with data modeling, application design and database development.
Experience with enterprise level database management, including Oracle.
Experience with virtualization technologies.
Experience working in small, creative teams.
Demonstrated end-user and customer service orientation.
The successful candidate will also possess:
Values consistent with those of UW Medicine's mission to improve the health of the public by advancing medical knowledge, providing outstanding primary and specialty care to the people of the region, and preparing tomorrow's physicians, scientists, and other health professionals.
Proven customer service orientation with a history of delivering high quality products on time.
Excellent written and oral communication abilities with the ability to convey a positive and professional image in person, on the telephone and in correspondence.
Ability to translate complex issues into comprehensible ideas and concepts with both technical and non-technical staff.
Strong interpersonal skills with the ability to work effectively with a diversity of personalities while forging effective partnerships.
Flexibility with proven ability to conform to shifting priorities, demands, and timelines through analytical and problem-solving capabilities.
Strong organizational, multitasking, and collaboration skills in various work environments including complex, matrix environments with proven attention to detail.
Proven ability to work creatively and analytically in a problem-solving environment demonstrating teamwork, innovation, and excellence.
Internal motivation to be action oriented and results driven with ability to adapt to change.
Proven ability to work in an ambiguous environment and collaborate across multiple areas in order to achieve a common business objective.
Decisiveness in resolving business problems, making decisions, and identifying priorities.
Must be able to learn, understand, and apply new technologies.
Previous experience in and knowledge of academic healthcare systems and/or operational environments.
Advanced degree (e.g., Master’s, PhD, etc.)
Experience with or knowledge of containerization processes.
Experience with several of the following database platforms: Microsoft SQL Server, Oracle, PostgreSQL, MySQL.
Understanding of Data Architecture, Data Warehousing, Data Mining and Business Intelligence concepts and technologies.
Experience with large academic health care enterprise projects or operations.
Experience administering a clustered, or otherwise highly available environment.
Familiarity with current web programming and development technology.
Knowledge of Microsoft Windows scripting tools, utilities and languages in the context of SQL Server.
Working knowledge of UNIX and/or Linux operating systems, including programming using Bash shell, Korn shell and/or Python scripting languages.
CONDITIONS OF EMPLOYMENT
This is an Information Technology deadline-driven work environment.
The individual in this position is expected to work normal daytime hours. The work may be performed in either an office environment or by telecommuting with manager approval; however, significant off-hours and weekends may be needed to resolve problems and respond to emergencies. This individual is expected to be available for emergencies (business continuity/disaster recovery efforts) on a 24x7 basis as needed.
Must have the ability to meet in person as directed by manager.
Because of the physically separated sites for UW Medicine, this position requires the ability to travel to alternative work locations as needed.
Must coordinate projects without direct supervisory authority.
Must work within the constraints of multiple technical environments.
ITS provides services to all UW Medicine organizations – HMC, UWMC-Montlake, UWMC-NW, VMC, UWNC, UWP, SOM, and ALNW. The individual in this position must learn many organizational structures and cultures and continually foster collaboration.
Ability to communicate effectively in English, both verbally and in writing.
Founded in 1861, the University of Washington is one of the oldest public institutions in the west coast and one of the preeminent research universities in the world. The University of Washington is a multi-campus university comprised of three different campuses: Seattle, Tacoma, and Bothell. The Seattle campus is made up of sixteen schools and colleges that serve students ranging from an undergraduate level to a doctoral level. The university is home to world-class libraries, arts, music, drama, and sports, as well as the highest quality medical care in Washington State and a world-class academic medical center. The teaching and research of the University’s many professional schools provide undergraduate and graduate students the education necessary toward achieving an excellence that will serve the state, the region, and the nation. As part of a large and diverse community, the University of Washington serves more students than any other institution in the Northwest.