Apply on Employer Site

Avalon Healthcare Solutions · 2 months ago

Business Intelligence Analyst II

Full-time

Hybrid

Entry, Mid Level

2+ years exp

Avalon Healthcare Solutions is the world's first Lab Insights company, focused on improving clinical outcomes and reducing costs in healthcare. The Business Intelligence Analyst II will drive data-driven reporting, create dashboards, and support internal and external stakeholders in making actionable decisions through data analysis and visualization.

AnalyticsHealth CareHospitalMedical

Culture & Values

Responsibilities

Develop SQL queries, views, and stored procedures for ad-hoc reporting needs

Review and validate client data to ensure accuracy and compliance with quality standards

Leverage SQL querying in Snowflake to perform deep dive analytics to identify relationships and driving factors associated with key outcomes

Collaborate with Data Engineering to define the data model, data aggregation, and performance needs for the underlying data that will be used in the dashboards (Tableau and PowerBI)

Create and document dashboards for the Account Management, Product, and other internal teams that allow them to make data-driven decisions and proposals using a common view of the data and clear, consistently defined metrics

Ensure that Account Management has the metrics, drill-down, and reporting capabilities they need to provide contractual reports and respond to client questions and investigations

Adhere to company and industry compliance, regulatory, and best practice standards

Self-starter; identify and leverage relevant data to diagnose situations, identify potential solutions and drive results

Successfully manage multiple projects at a time

Act as subject matter expert and create training materials on self-service dashboards

Qualification

SQL queriesTableauPowerBISnowflakeHealthcare industry experienceSSRS/PowerBI Report ServerAnalytical skillsTraining material creationPythonDocumentation skillsProject management