Senior Business Intelligence Developer (Remote Available)

Discover Vanderbilt Health With eight hospitals and over 180 clinics, we are the region’s largest comprehensive academic health system. Vanderbilt Health has a long tradition of providing world-class care to the people of the Mid-South, living out our mission of moving medicine forward through preeminent programs in patient care, education and research. Here you’ll find a spirit of collaboration and a supportive community where your expertise is valued, your knowledge expanded and your uniqueness celebrated. We are committed to fostering an environment where talented, compassionate people are united in bringing the most advanced care to our neighbors throughout the region.

Organization: Quality, Safety & Risk Prevent

Job Summary: This Senior BI Developer will develop and modify Business Intelligence solutions independently. 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.

(Note: This role is available for remote work from most US locations)

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.

Requirements

• Bachelor’s degree - Required
• Strong backend SQL skills - Required
• Experience with Azure Databricks - Preferred
• Experience utilizing Tableau and Power BI for visualization - Required
• Strong communication skills - Required
• Any experience in healthcare or EMR systems (specifically Epic) - Preferred

Technical Capabilities

• 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.
• 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.
• 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.
• 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.

About the Department: The Department of Quality, Safety, and Risk Prevention (QSRP) equips and empowers Vanderbilt Health faculty and staff at our Main Campus, Regional Hospitals and Ambulatory Divisions to offer care that is safe, timely, effective, efficient and patient-centered. We are focused on providing high-quality care through doing the ri…