Business Intelligence Analyst II

Avalon Administrative Services LLC•Tampa, FL

1d•Remote

About The Position

The Business Intelligence Analyst II drives data-driven reporting to support Avalon’s client, product, and operational data needs. The role collects and organizes reporting and business requirements and creates dashboards that help internal and external stakeholders make actionable, data-driven decisions. Work includes mining, cleaning, aggregating, and formatting data for stakeholder consumption. Thorough documentation and attention to detail are essential. The position is eligible for remote work, although travel to Avalon’s corporate office in Tampa, Florida may be requested during the assignment. The analyst works with teams including Data Engineering and Account Management to develop reliable, consistently defined reporting and dashboard capabilities.

Requirements

At least 2 years of employment experience in an analytical role.
Bachelor’s degree in data analytics, computer science, management information systems, mathematics, or statistics, or equivalent work experience.
Analytical and interpretation skills, including the ability to review data and gain insight.
Ability to apply knowledge gained from one project to subsequent projects.
Experience writing SQL queries.
Experience with Tableau and/or PowerBI.
Healthcare industry experience.
Experience with SSRS/PowerBI Report Server.
Experience with Snowflake.

Nice To Haves

Experience writing in Python.
Knowledge of healthcare claims data.

Responsibilities

Develop SQL queries, views, and stored procedures for ad-hoc reporting needs.
Review and validate client data for accuracy and compliance with quality standards.
Use SQL querying in Snowflake to conduct deep-dive analytics and identify relationships and factors associated with key outcomes.
Collaborate with Data Engineering to define the data model, data aggregation, and performance requirements for data used in Tableau and PowerBI dashboards.
Create and document dashboards for Account Management, Product, and other internal teams, enabling data-driven decisions and proposals using a common view of data and consistently defined metrics.
Ensure Account Management has the metrics, drill-downs, and reporting capabilities needed to provide contractual reports and respond to client questions and investigations.
Adhere to company and industry compliance, regulatory, and best-practice standards.
Identify and leverage relevant data to diagnose situations, identify potential solutions, and drive results.
Manage multiple projects simultaneously.
Act as a subject matter expert and create training materials for self-service dashboards.