The ETL Application Developer will be essential in working on a data repository and API that is central to "All of Us" Data and Research Center. VUMC has been chosen by the National Institutes of Health (NIH) to be the Data and Research Center for the Precision Medicine Initiative "All of Us" Research Program, a landmark study of genetic, environmental, and lifestyle factors affecting the health of a million or more people. This initiative requires the development and maintenance of web applications and APIs to support participants, health provider staff, and researchers.We are looking for an ETL Application Developer with experience using modern web application frameworks. All of our applications are continually evolving, requiring flexible software architecture and the ability to rapidly refactor and modernize. The collaborative nature of this project requires excellent communication skills and the ability to understand and refine requirements.
Main Focus: data integration, including Implementation, execution and maintenance of data integration technology solutions
Be involved and participant in the overall application life cycle
Collaborate with multidisciplinary team of designers, developers and system administrators
Provide training, help and support to other team members
Build high-quality reusable code
Develop functional and sustainable web applications with clean codes
Troubleshoot and debug
Stay up to date with current best practices
Follow new and emerging technologies
Core Skill Preferences
Bachelor's degree in CS (or similar relevant field) and 2 years of ETL development experience
6 years of ETL development experience
Experience with and knowledge of:
2+ years with big data tool (Hadoop, Spark, Kafka, Nifi, etc)
2+ years with Object-oriented/object function scripting languages in production (Java, Python, etc)
3+ years managing data cross relational SQL and NoSQL database (MySQL, Postgres, Cassandra, HDFS, Redis and Elasticsearch)
3+ years with Linux environment
2+ years with REST APIs
Strong experience in working with both open-source and commercial technologies
3+ years with stream data integration technologies (Apache Nifi, Apache Beam, Apache Kafka Streams, Amazon Kinesis)
Experience with performance tuning of ETL jobs
Critical thinker and problem-solving skills
Good organizational and time-management skills
Great interpersonal and communication skills
Flask, SQLAlchemy, and Alembic
Google Cloud (App Engine, Cloud SQL, Cloud Storage, Datastore, etc.)
Git, GitHub pull requests, and continuous integration
Deep understanding of the Python ecosystem and idioms for writing performant and scalable code
Understanding of Cloud Computing, Containers, CI/CD, Deployments, preferably on Google Cloud Platform
Designing/developing platform components like caching, messaging, event processing, automation, transformation, and tooling frameworks
Working experience with popular data discovery, analytics and BI software tools (eg. Tableau) and OBI for semantic-layer-based data discovery
Experience with ETL tools, such as Pentaho, NiFi, Informatica, DataStage, Talend or equivalent
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.
Vanderbilt University Medical Center is home to Vanderbilt University Hospital, The Monroe Carell Jr. Children’s Hospital at Vanderbilt, the Vanderbilt Psychiatric Hospital and the Vanderbilt Stallworth Rehabilitation Hospital. These hospitals experienced more than 61,000 inpatient admissions during fiscal year 2015. Vanderbilt’s adult and pediatric clinics treated nearly 2 million patients during this same period. Vanderbilt University Hospital and the Monroe Carell Jr. Children’s Hospital at Vanderbilt are recognized again this year by U.S. News & World Report’s Best Hospitals as among the nation’s best with 18 nationally ranked specialties. Vanderbilt University Medical Center is world renowned because of the innovation, work ethic and collegiality of its employees. From our health care advances to our compassionate care, Vanderbilt owes its accomplishments and reputation to staff and faculty who bring skill and drive and innovation to the medical center day after day. World-leading academic departments and comprehensive centers of excellence pursue scientific discoveries and transformational educational and clinical advances across the entire spectrum of health and disease.As t...he largest employer in middle Tennessee, we welcome those who are interested in ongoing development in a caring, culturally sensitive and professional atmosphere. Most of us spend so much of our lives at work, we want to be part of maintaining a workplace in which people support one another and encourage reaching for excellence. Many high-achieving employees stay at Vanderbilt because of the professional growth they experience and because of their appreciation of Vanderbilt’s benefits, public events and discussions, athletic opportunities, beautiful setting and, above all, sense of community and purpose.Vanderbilt and its employees share a set of mutual expectations that have been created with productivity, legality, fairness and safety always in mind. We believe that our investment in training and compensating employees multiplies in value when we enable individuals to deliver their best performance for the benefit of us all.