BI Analyst: Snowflake & Databricks AI Reporting (Healthcare)

Elsevier; Chicago (IL); Presencial; USD 79.000 - 131.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Annual incentive bonus

Descripción de la vacante

Elsevier's Healthcare Education team seeks a BI Analyst to own Trade and Commercial Reporting across Snowflake, Tableau, and related BI environments. You will partner with commercial, analytics, technology, and senior stakeholders to modernize reporting workflows and deliver scalable BI solutions.

Key focus areas include converting legacy Excel processes to automated dashboards, validating outputs, and supporting migrations to new data warehouses.

Formación

• 3+ years of hands-on SQL experience on Snowflake/Databricks/SSRS or similar.
• 3+ years building dashboards in Tableau/Power BI/Looker or similar.
• Experience converting legacy reporting workflows into automated BI solutions.
• Experience translating reporting logic across systems and data warehouses.
• Experience gathering requirements from stakeholders and turning into specs.
• Proven data validation and discrepancy investigation experience.
• Familiarity with AI tools (e.g., ChatGPT, Claude, Copilot)

Responsabilidades

• Owning the development and enhancement of Trade and Commercial Reporting solutions across Snowflake, Tableau, and related BI environments.
• Applying AI tools, where appropriate, to improve analysis, documentation, workflow efficiency, and reporting development.
• Converting legacy manual reporting workflows, including Excel-based processes, into scalable dashboards, automated reporting, and repeatable analytical solutions.
• Supporting reporting migrations by translating legacy queries, business rules, and reporting logic into new data warehouse environments.
• Validating reporting outputs across legacy and new environments to ensure accuracy, consistency, and alignment with business definitions.
• Partnering with commercial stakeholders, including senior and VP-level audiences, to gather requirements, clarify business questions, and deliver actionable reporting outputs.
• Investigating data discrepancies, perform quality checks, document issues, and coordinating resolution with business and technical partners.
• Maintaining documentation for reporting processes, data definitions, query logic, migration mappings, and technical workflows.
• Managing multiple reporting priorities and stakeholder requests with strong attention to detail and limited oversight.

Conocimientos

SQL & BI tooling

Dashboard development

Data validation

Requirements gathering

AI tools familiarity

Herramientas

Snowflake

Databricks

SSRS

Tableau

Power BI

Looker

Descripción del empleo

Elsevier's Healthcare Education team seeks a BI Analyst to own Trade and Commercial Reporting across Snowflake, Tableau, and related BI environments. You will partner with commercial, analytics, technology, and senior stakeholders to modernize reporting workflows and deliver scalable BI solutions.

Key focus areas include converting legacy Excel processes to automated dashboards, validating outputs, and supporting migrations to new data warehouses.