Business Intelligence Specialist

Overview

Provides consultation and ad hoc analyses to clinical and operational leaders and teams. Dives deep into their data in order to support local objectives and Dartmouth Health priorities using programming, analysis, data visualization and communication skills. Develops subject matter expertise and strong relationships. Collaborates with people across the organization and fosters a culture of data-driven decision making and data literacy. This is the most senior position in the Healthcare Data Programmer Analyst track.

 

This position supports the Dartmouth Cancer Center.

Responsibilities

Creates, manages, manipulates and analyzes large health data using SAS or other relevant software to create analytic files by merging multiple large databases, formatting, recoding, and sub-setting data as needed.

Analyzes data, provides visualization and explanations to customers to support data-driven decision making. Collaborates with colleagues for advanced analysis as needed.

Develops metrics, key performance indicators, and identifies opportunities for improvement and further understanding.

Acts as a liaison to all levels of the organization, providing analytical support as well as committee representation.

Accurately discerns the needs and objectives of clinical and administrative partners and provides appropriate analytical support.

Provides education to partners to develop and promote data literacy across the organization.

Codes queries in SAS and/or SQL against the EPIC Clarity environment.

Writes and executes SAS and/or SQL joins and stored procedures. Extracts, manipulates, and validates data. Summarizes, visualizes and works with complex data structures (e.g. descriptive statistics, graphs in SAS; works with various time stamps; macro and DATA steps in SAS)

Creates data visualization in Tableau and other business intelligence tools (e.g. Excel, Web Intelligence, etc.)

Applies guiding principles of scientific measurement and reporting in all displays of data. Continually researches and applies new statistical and analytical techniques.

Independently manages multiple projects with time-sensitive deadlines.

Engages with customers to help them understand and use self-service tools.

Mentors colleagues and partners on content and technical knowledge.

Adheres to all DH policies and procedures for safe data handling practices.

Scans the external environment for new methods, skills and techniques. Engages in, models, and supports continuous learning and development through online sources, reading materials, conferences, and other learning opportunities.

Performs other duties as required or assigned.

Qualifications

• Master’s degree with 8 years of experience in clinical quality data analytics and reporting or the equivalent in education and experience required
• Advanced understanding of healthcare data
• Excellent written and verbal communication skills. Demonstrates assertive and appropriate communication style with senior leaders and clinicians and the ability to communicate effectively with technical and business/non-technical audiences
• Able to work independently and within a team environment
• Demonstrated experience with quantitative data, analytical techniques, relational databases, data visualization, and project management
• Proficient in MS Excel and advanced knowledge of BI tools, such as Tableau
• Strong coding skills in at least one programming language (e.g. SAS, SQL)
• Completes EPIC Clarity Clinical Model certification within one year
• Completes Value Institute Yellow Belt training within one year

Required Licensure/Certifications

• None