Job Information
Vanderbilt University Medical Center ETL Application Developer (**REMOTE AVAILABLE**) in Nashville, Tennessee
ETL Application Developer (REMOTE AVAILABLE) - 2100587
Job : Information Technology
Primary Location : TN-Nashville-2525 West End Ave
Organization : VICTR 104242
Shift: : Days
Description
Overview:
We are looking for an ETL Application Developer who will perform a variety of programming tasks in support of the research and data teams. This person's main focus will be developing pipelines for data extraction and transformation processes, developing/modifying data models, and automating common workflows. This will include developing complex SQL scripts for data ingestion and extraction, developing and maintaining programs as required for the ETL process, keeping accurate and complete project documentation, performing quality testing and data assurance, and working with project managers to satisfy data and research needs. The person in this role will need to be adaptable and be able to pick up whatever new skills and expertise are needed to complete the project at hand.
Experience with and knowledge of:
SQL
Data harmonization and ETL processes
Relational databases (MySQL, Postgres, Oracle, etc.)
Shell Scripting
Preferred experience:
Microsoft Azure
Python or Java
Job Summary
This ETL Application Developer will perform a variety of programming tasks in support of the big data team. Our team builds and maintains large-scale clinical research data repositories, which contain data gathered from the EMR and across the clinical enterprise. We transform the data to make it more suitable for data mining and research as well as build tools that allow researchers to explore and interact with the data. This person's main focus will be developing software tools to fulfill phenotype requests and automate common analysis workflows. This will include developing complex SQL scripts for data analysis and extraction, developing and maintaining programs as required for the ETL process, keeping accurate and complete project documentation, performing quality testing and data assurance, and working with project managers and team members to satisfy research needs. The person in this role will need to be adaptable and be able to pick up whatever new skills and expertise are needed to complete the project at hand.
Expected Performances
This position will develop and modify software under occasional guidance; design, code, and perform benchmark testing, as well as debugging and documentation of programs. Implement small projects or components or large projects. Ability to solve medium to complex problems through the following technical core competencies:
1.
Application Development: Demonstrates proficiency of programming and other development tasks independently and without support from others for moderate to difficult applications. Has conducted all of the tasks and activities required to complete the applications development phase and participated in the process of fully implementing the system. Able to successfully debug complex routines. In terms of structured programming, has used structured code to produce modules of straightforward logic.
Applications Development Standards and Procedures: Possesses sufficient fundamental proficiency to successfully demonstrate knowledge of applications development standards and procedures in practical applications of moderate difficulty. Is attentive to existing applications development standards and procedures, and may recommend improvements to existing applications development standards and procedures within the work area.
Applications System Analysis: Has some training in or light exposure to basic systems analysis tasks. Participated in one or more systems analysis tasks such as: collection of documents, user interviews, file analysis, process flow charting, functional process modeling, data modeling, feasibility, prototyping, and evaluating existing systems. Able to analyze information and verify its completeness. If applicable, has knowledge of the concepts of structured functional specifications, modularity and partitioning.
Applications System Design: Demonstrates the ability to conduct systems design tasks in a team environment or independently to build or enhance a simple system. Has conducted the basic phases of systems design including preparing design and file specifications, preparing testing, conversion, and implementation plans, designing system architecture and process flows, and preparing program requirements and specifications. Creatively generates multiple potential solutions. In terms of structured systems design, if applicable, has participated in the structured design of one or more conventional, relatively uncomplicated data processing systems as a member of a project team. Is familiar with standard methods for functional decomposition. Has participated in structured design walk-throughs.
About the Department:
The Vanderbilt Institute for Clinical & Translational Research (VICTR) is Vanderbilt’s virtual home for clinical and translational research. Supported by Vanderbilt University Medical Center’s Office of Research and the NIH-sponsored Clinical and Translational Service Award (CTSA), the mission of the institute is to transform the way ideas and research discoveries make their way from origin to patient care. VICTR functions to help researchers and clinicians do their jobs better by providing tools and support to improve the quality of research, publications, grant writing, and training for future doctors and researchers. For more information, please visit https://victr.vumc.org/ .
Position Shift : Days
Discover Vanderbilt University Medical Center:
Located in Nashville, Tennessee, and operating at a global crossroads of teaching, discovery and patient care, VUMC is a community of individuals who come to work each day with the simple aim of changing the world. It is a place where your expertise will be valued, your knowledge expanded, and your abilities challenged. It is a place where your diversity — of culture, thinking, learning and leading — is sought and celebrated. It is a place where employees know they are part of something that is bigger than themselves, take exceptional pride in their work and never settle for what was good enough yesterday. Vanderbilt’s mission is to advance health and wellness through preeminent programs in patient care, education, and research.
VUMC Recent Accomplishments
Because we are committed to providing the best in patient care, education and research, we are proud of our recent accomplishments:
US News & World Report: #1 Adult Hospital in Tennessee and metropolitan Nashville, named to the Best Hospitals Honor Roll of the top 20 adult hospitals, 10 nationally ranked adult specialty programs, with 3 specialties rated in the top 10 nationally, Monroe Carell Jr. Children’s Hospital at Vanderbilt named as one of the Best Children’s Hospital in the nation, with 10 out of 10 pediatric specialties nationally ranked.
Healthcare’s Most Wired: Among the nation’s 100 “most-wired” hospitals and health systems for its efforts in innovative medical technology.
Becker’s Hospital Review: named as one of the “100 Great Hospitals in America”, in the roster of 100 Hospitals and Health Systems with Great Oncology Programs and to its list of the 100 Hospitals with Great Heart Programs.
The Leapfrog Group: One of only 10 children’s hospitals in the to be named at Leapfrog Top Hospital.
American Association for the Advancement of Science: The School of Medicine has 112 elected fellows
Magnet Recognition Program: Received our third consecutive Magnet designations.
National Academy of Medicine: 22 members, elected by their peers in recognition of outstanding achievement
Human Rights Campaign Healthcare Equality Index: 6 th year in a row that Vanderbilt University Medical Center was a Leader in LGBTQ Healthcare Equality.
Basic Qualifications
POSITION QUALIFICATIONS:
Bachelor's Degree (or equivalent experience) and 2 years relevant experience
Physical Requirements/Strengths needed & Physical Demands:
Sedentary category requiring exertion up to 10 lbs. of force occasionally and uses negligible amounts of force to move objects. Sedentary work involves sitting most of the time. Movement
Occasional: Standing: Remaining on one's feet without moving.
Occasional: Walking: Moving about on foot.
Occasional: Lifting under 35 lbs: Raising and lowering objects under 35 lbs from one level to another
Occasional: Carrying under 35 lbs: Transporting an object holding in hands, arms or shoulders, with help of coworkers or assistive device.
Occasional: Bending/Stooping: Trunk bending downward and forward by bending spine at waist requiring full use of lower extremities and back muscles
Occasional: Reaching above shoulders: Extending arms in any direction above shoulders.
Frequent: Sitting: Remaining in seated position
Frequent: Reaching below shoulders: Extending arms in any direction below shoulders.
Frequent: Fingering: Picking, pinching, gripping, working primarily with fingers requiring fine manipulation.
Frequent: Bimanual Dexterity: Requiring the use of both hands. Sensory
Continuous: Communication: Expressing or exchanging written/verbal/electronic information.
Continuous: Auditory: Perceiving the variances of sounds, tones and pitches and able to focus on single source of auditory information
Continuous: Vision: Clarity of near vision at 20 inches or less and far vision at 20 feet or more with depth perception, peripheral vision, color vision.
Continuous: Smell: Ability to detect and identify odors. Environmental Conditions
Req ID: 2100587
Vanderbilt University Medical Center is committed to principles of equal opportunity and affirmative action.