Business Intelligence Analyst

Job Summary:

Works as a business intelligence / data analyst with strong user-facing communication skills, leveraging prior healthcare experience to develop and deliver semantic model solutions under occasional guidance. Collaborates with stakeholders to gather requirements, translate business needs into actionable insights, and deliver clear, concise data assets and data marts. Key responsibilities include analyzing data sources, designing, and developing the semantic layer to connect business language with technical data, ensuring data consistency, and documenting metadata, lineage, and business definitions. The role also requires collaboration with technical teams, data governance, and business stakeholders to ensure the semantic model meets business needs for self-service analytics. Implements small projects or components of large projects. Ability to solve medium to complex problems.

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.

Technical Capabilities:

Communication & Stakeholder Engagement (Proficient): Excellent communication skills with the ability to translate complex data into actionable information. Effectively communicates complex data concepts to both technical and non-technical users. Gathers requirements, presents findings, and provides support to end users.
Healthcare Data & Compliance (Proficient): Demonstrates strong understanding of healthcare data standards and regulatory requirements (e.g., HIPAA). Applies healthcare domain knowledge to ensure data solutions meet regulatory requirements.
SQL Writing (Proficient): Writes complex SQL queries for data extraction, transformation, and analysis. Optimizes queries for performance and accuracy.
Data Warehousing Concepts (Proficient): Demonstrates a strong understanding of data warehousing concepts such as ODS, enterprise data warehouse, data marts, and semantic modeling. Applies best practices in data organization and integration. Demonstrates an understanding of design concepts, data organization, capabilities and limitations. Worked with corporate, as well as local, data warehouse models. Has used at least one of the state-of-the-art data warehouse packages available in practical application of moderate difficulty.
Dimensional and Semantic Modeling (Intermediate): Demonstrates a strong understanding of modeling concepts like Start and snowflake models. Builds and optimizes the semantic layer for intuitive, self-service data access and analysis by end-users.
Data Marts (Intermediate): Has successfully applied the skill in situations of medium complexity. Occasionally needs assistance from internal technical support in its application, operation or practice. May have successfully completed in-depth training in core components of the skill.
Cloud Technologies (Novice): Experience working with cloud platforms such as Azure Databricks for data analysis and processing.
Python for Data Analysis (Novice): Uses basic Python coding skills for data analysis, data manipulation, and automation tasks.

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.

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: Executes job responsibilities with the understanding of how output would affect and impact other areas related to own job area/team with occasional guidance. Problem Solving/ Complexity of work: Analyzes moderately complex problems using technical experience and judgment. Breadth of Knowledge: Has expanded knowledge gained through experience within a professional area. Team Interaction: Provides informal guidance and support to team members.

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:
Less than 1 year

Education:
Bachelor's

Vanderbilt Health is committed to fostering an environment where everyone has the chance to thrive and is committed to the principles of equal opportunity. EOE/Vets/Disabled.