Clinical BI Analyst: Data Dashboards & ETL

Virginia Commonwealth University; Richmond (VA); On-site; USD 51,000 - 85,000; Full time

Benefits offered by this job

Health benefits

Paid annual leave

Tuition benefits

Retirement planning

Cash match programs

Employee discounts

Well-being resources

Career development opportunities

Job summary

Virginia Commonwealth University, School of Dentistry, Information Technology seeks a Clinical Business Intelligence Analyst to bridge business and IT, build datasets, ETL processes and dashboards for academic, administrative, research and clinical needs. The role involves collaborating with leadership and clinical staff, modeling processes, and ensuring data integrity.

The position offers onsite work with responsibilities spanning data integration, warehouse design, EHR training support, and

Qualifications

• Bachelor’s degree required
• Working experience in Higher Education or a Healthcare Environment
• Hands-on experience with Oracle and Microsoft SQL Server
• Experience with Tableau or PowerBI dashboarding and visualization applications
• Experience and understanding of AWS, Snowflake, or Google Cloud Platform
• Excellent oral and written communication skills
• Superior interpersonal and decision-making skills
• Ability to manage multiple projects simultaneously
• Ability to document business processes and operational workflows
• Excellent customer service
• Demonstrated ability to work with diverse populations

Responsibilities

• Design, develop, and distribute database-driven reports and visualizations using SQL, Crystal Reports, Tableau, PowerBI, and Excel.
• Manage, combine, integrate, and analyze data from multiple data sources (Oracle, MS SQL Server, MySQL, APIs, cloud).
• Design and maintain data structures, dashboards, and data automation for critical decisions.
• Collaborate with senior leadership, clinicians and staff to evaluate requirements and build informative views.
• Act as an honest broker for the IRB and document data flows and sources for integration projects.
• Assist with selecting and maintaining a data warehouse and cloud data lake/warehouse.
• Assist with EHR training and clinical systems support tickets.

Skills

SQL

ETL processes

Dashboard development

Data visualization

Data modeling

Education

Bachelor's degree

Master’s degree in related field

Tools

Tableau

PowerBI

Excel

Crystal Reports

Oracle

Microsoft SQL Server

MySQL

APIs

Job description

Virginia Commonwealth University, School of Dentistry, Information Technology seeks a Clinical Business Intelligence Analyst to bridge business and IT, build datasets, ETL processes and dashboards for academic, administrative, research and clinical needs. The role involves collaborating with leadership and clinical staff, modeling processes, and ensuring data integrity.

The position offers onsite work with responsibilities spanning data integration, warehouse design, EHR training support, and