Senior Business Intelligence Automation Developer (Remote Available) (vumc)

Job Description

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 diverse 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. Vanderbilt Health recognizes that diversity is essential for excellence and innovation. We are committed to an inclusive environment where everyone has the chance to thrive and 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.

Organization:

VUMC IT Automation Services

Job Summary:

Specializing in automation services, plays a pivotal role in designing, developing, and maintaining data solutions that drive our automation initiatives. Leverages expertise in Databricks, SQL Server, and Tableau to create robust data pipelines, data that powers automation solutions forward and interacts with scripting and AI Agents, insightful analytics, and interactive visualizations that support decision-making and operational efficiency. Develops and modifies Business Intelligence solutions independently. Implements large/multiple development projects. Functions as lead on projects.

.

KEY RESPONSIBILITIES

• Design, develop, and maintain data models, ETL processes, and Automation data using Databricks and SQL Server to support automation services.
• Create, optimize, and manage complex SQL queries and stored procedures to extract, transform, and load data efficiently.

• Develop and maintain interactive and visually compelling dashboards and reports using Tableau to provide actionable insights for stakeholders.
• Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs.
• Stay current with the latest trends and best practices in BI, data analytics, and automation technologies.• 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.

Qualifications:

Required:

- Proven experience as a BI Developer or Data Engineer with a focus on automation services.

- Extensive experience with Databricks for data processing and analytics.

- Strong proficiency in SQL Server, including complex query writing, optimization, and database management.

- Expertise in Tableau for creating interactive dashboards and reports.

- Solid understanding of data warehousing concepts, ETL processes, and data modeling.

- Excellent problem-solving skills and attention to detail.

- Strong communication and collaboration abilities.

- Ability to work independently and manage multiple projects simultaneously.

Preferred:

- Bachelor's degree in Computer Science, Information Technology, or a related field.

- Machine learning Background

- AI Agent Data Prompting Background

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:

VUMC IT

VUMC IT provides hardware, software and service solutions for the entire Medical Center. With over 40,000 workstations in the Medical Center, our teams can assist not only with hardware support, but also software and application support and services to enhance security and protection of your information. 

Our professional administrative functions include critical supporting roles in information technology and informatics, finance, administration, legal and community affairs, human resources, communications and marketing, development, facilities, and many more.

At our growing health system, we support each other and encourage excellence among all who are part of our workforce. High-achieving employees stay at Vanderbilt Health for professional growth, appreciation of benefits, and a sense of community and purpose.

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.

Core Capabilities :

Supporting Colleagues: - Develops Self and Others: Invests time, energy, and enthusiasm in developing self/others to help improve performance e and gain knowledge in new areas. - Builds and Maintains Relationships: Maintains regular contact with key colleagues and stakeholders using formal and informal opportunities to expand and strengthen relationships. - Communicates Effectively: Recognizes group interactions and modifies one's own communication style to suit different situations and audiences. Delivering Excellent Services: - Serves Others with Compassion: Seeks to understand current and future needs of relevant stakeholders and customizes services to better address them. - Solves Complex Problems: Approaches problems from different angles; Identifies new possibilities to interpret opportunities and develop concrete solutions. - Offers Meaningful Advice and Support: Provides ongoing support and coaching in a constructive manner to increase employees' effectiveness. Ensuring High Quality: - Performs Excellent Work: Engages regularly in formal and informal dialogue about quality; directly addresses quality issues promptly. - Ensures Continuous Improvement: Applies various learning experiences by looking beyond symptoms to uncover underlying causes of problems and identifies ways to resolve them. - Fulfills Safety and Regulatory Requirements: Understands all aspects of providing a safe environment and performs routine safety checks to prevent safety hazards from occurring. Managing Resources Effectively: - Demonstrates Accountability: Demonstrates a sense of ownership, focusing on and driving critical issues to closure. - Stewards Organizational Resources: Applies understanding of the departmental work to effectively manage resources for a department/area. - Makes Data Driven Decisions: Demonstrates strong understanding of the information or data to identify and elevate opportunities. Fostering Innovation: - Generates New Ideas: Proactively identifies new ideas/opportunities from multiple sources or methods to improve processes beyond conventional approaches. - Applies Technology: Demonstrates an enthusiasm for learning new technologies, tools, and procedures to address short-term challenges. - Adapts to Change: Views difficult situations and/or problems as opportunities for improvement; actively embraces change instead of emphasizing negative elements.

Position Qualifications:

Responsibilities:

Certifications:

Work Experience:

Relevant Work Experience

Experience Level:

5 years

Education:

Bachelor's (Required)

Vanderbilt Health recognizes that diversity is essential for excellence and innovation. We are committed to an inclusive environment where everyone has the chance to thrive and to the principles of equal opportunity and affirmative action. EOE/AA/Women/Minority/Vets/Disabled