Senior Business Intelligence Developer

JOB SUMMARY:

This Senior Business Intelligence Developer develops and modifies Business Intelligence solutions independently. The Senior BI Developer designs data models used for reporting and analytics, develops ETL processes for data, and utilizes BI tools to satisfy end user data needs. Implements large/multiple development projects. Functions as lead on projects. May lead teams. Coaches development of Business Intelligence Developers.

KEY RESPONSIBILITIES:

• Develops or modifies data models, ETL processes, and BI tool solutions.
• Ensures appropriate documentation for all development and modification.
• Ensures integrity and security of institutional data.
• The responsibilities listed are a general overview of the position and additional duties may be assigned.

TECHNICAL CAPABILITIES:

BUSINESS INTELLIGENCE TOOLS (INTERMEDIATE): Demonstrates a thorough understanding of the effective use of the tool in complex applications. Experienced in all core features of the tool. Demonstrates a thorough understanding of advanced concepts and features. Uses tool consistently in delivering applications. May have successfully completed training in advanced techniques and tools.

DATA MARTS (INTERMEDIATE): Demonstrates a thorough understanding of the effective application, operation or practice in complex applications. Experienced in all core features and functions. Demonstrates a thorough understanding of advanced concepts. Applies concepts and tools consistently in delivering applications. May have successfully completed training in advanced techniques, features and tools.

DATA WAREHOUSING (INTERMEDIATE): Designed a system in which data warehousing was a primary component. Has detailed knowledge of corporate, as well as local, data warehouse models. Demonstrates in-depth knowledge of options available in various data warehouse components. Demonstrates an understanding of the different data warehouse structures , both in theory and practical application. Capable of predicting performance on the basis of the available options and environments, including the ability to synthesize local and regional data requirements into a specific data warehouse application.

ETL/ETT/ETM TOOLS AND PROCESS (INTERMEDIATE): Demonstrates the use of key ETL/ETT/ETM tools and utilities independently to accomplish appropriate database tasks. Has significant experience extracting data from a specified source database and taking out a desired subset of data for at least one major data warehouse project. Has transformed the acquired data - using complex rules or lookup tables, or creating combinations with other data - to convert it to the desired state. Responsible for writing the resulting data [either all of the subset or just the changes] to a target database. Capable of providing support and direction in the use of the Company's primary ETL/ETT/ETM tool for other team members. Identifies new features of immediate benefit and develops plans to incorporate them into existing procedures.

CORE ACCOUNTABILITIES:

• Organizational Impact: Independently delivers on objectives with understanding of how they impact the results of own area/team and other related teams.
• Problem Solving/ Complexity of work: Utilizes multiple sources of data to analyze and resolve complex problems; may take a new perspective on existing solution.
• Breadth of Knowledge: Has advanced knowledge within a professional area and basic knowledge across related areas.
• Team Interaction: Acts as a go-to resource for colleagues with less experience; may lead small project teams.

About the Department:

Health IT

HealthIT provides the best health information technology tools that support Vanderbilt University Medical Center’s mission of:

• Delivering distinctively personalized care
• Improving the health care of individuals and communities regionally, nationally and internationally
• Providing transformative learning programs
• Supporting compelling discoveries

Our tools, which form the digital arteries of VUMC, are either developed in-house by our innovative product teams or selected from the most cutting-edge solutions available in today’s ever-changing marketplace. Our 500 colleagues provide ongoing support over each product’s entire lifespan, ensuring that the tools are meeting the evolving needs of the Medical Center’s 24,000 colleagues.

Our solutions are driven by the incredible work and research of our colleagues throughout Vanderbilt and supported through a close partnership with VUMC Information Technology (VUMC IT). The strong collaboration among our teams means that VUMC can respond to clinical and operational issues with agility and innovation. Together, we ensure VUMC remains a leader in its pioneering use of healthcare information technology.

Underscoring our entire department are our core values of accountability, transparency and execution, delivered with a strong Partner Promise.

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: 6th year in a row that Vanderbilt University Medical Center was a Leader in LGBTQ Healthcare Equality.

POSITION QUALIFICATIONS:

• 5 years relevant experience
• Bachelor's Degree (Required)

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