Description Job Summary: 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. Key Responsibilities: - 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
- Optimize performance
- Follow new and emerging technologies
Core Skill Preferences - Either:
- 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
- Other requirements:
- Critical thinker and problem-solving skills
- Team player
- Good organizational and time-management skills
- Great interpersonal and communication skills
Preferred experience - 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
Department Summary: 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.
|
.png?sfvrsn=8cb5512c_0 "ACA(WEBusage)")
