Business Intelligence Analyst - (Snowflake, Databricks, SSRS)

Elsevier; United States; On-site; USD 80,000 - 120,000; Full time

Job summary

Elsevier Healthcare Education is seeking a BI Analyst to support Trade and Commercial Reporting within the BI Team. This role partners with commercial, analytics, technology, and senior stakeholders to modernize reporting workflows, improve reporting quality, and deliver scalable BI solutions that support business decision-making.

The role focuses on owning the development and enhancement of reporting across Snowflake, Tableau, and related BI environments, applying AI tools to improve analysis

Qualifications

• 3+ years of SQL experience on Snowflake, Databricks, SSRS or similar platforms.
• 3+ years developing dashboards/reports in BI tools (Tableau/Power BI/Looker or equivalent).
• Experience converting manual/legacy reporting into automated BI solutions.
• Ability to translate queries and business rules across systems.
• Experience gathering requirements from business stakeholders for reporting solutions.
• Familiarity with AI tools (ChatGPT, Claude, Copilot) and their applications.

Responsibilities

• Own development and enhancement of Trade & Commercial Reporting across Snowflake, Tableau and BI environments.
• Apply AI tools to improve analysis, documentation, workflow efficiency, and reporting development.
• Transform legacy Excel-based processes into scalable dashboards and automated reporting.
• Support reporting migrations by translating legacy queries and rules into new data warehouses.
• Validate outputs across legacy and new environments ensuring accuracy and consistency.
• Collaborate with commercial stakeholders, including senior leadership, to gather requirements and deliver actionable outputs.
• Investigate data discrepancies, perform quality checks, and coordinate issue resolution with partners.
• Maintain documentation for reporting processes, data definitions, and migration mappings.
• Manage multiple reporting priorities with attention to detail and minimal oversight.

Skills

SQL development

Dashboard & reports

Requirements gathering

Data validation

AI tools familiarity

Cross-functional collaboration

Tools

Snowflake

Databricks

SSRS

Tableau

Power BI

Looker

Job description

As a BI Analyst you will be entrusted to support Trade and Commercial Reporting within Elsevier Healthcare Education’s (EHE) Business Intelligence Team. This role will partner with commercial, analytics, technology, and senior stakeholders to modernize reporting workflows, improve reporting quality, and deliver scalable BI solutions that support business decision-making.

Elsevier’s Healthcare Education team develops digital learning, assessment, and simulation products—including Sherpath AI, ClinicalKey Student, Shadow Health, HESI, Complete Anatomy, and Osmosis—to support medical and nursing students, educators, and future healthcare professionals worldwide. From an AI Software Engineering perspective, the team’s work spans generative AI, RAG, intelligent search, personalized learning, data analytics, cloud-based applications, and virtual patient simulations to improve educational experiences and learning outcomes.

Key Responsibilities

• 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.

Required Qualifications

• 3+ years of hands-on SQL experience using Snowflake, Databricks, SSRS, or similar data platforms.
• 3+ years of experience developing dashboards and reports in BI visualization tools such as Tableau, Power BI, Looker, or similar platforms.
• Demonstrated experience converting manual or legacy reporting workflows into automated BI, dashboard, or reporting solutions.
• Demonstrated experience translating reporting logic, SQL queries, or business rules across systems, data warehouses, or reporting platforms.
• Experience gathering requirements from business stakeholders and converting them into technical specifications, reporting logic, or dashboard solutions.
• Proven ability to validate data, investigate discrepancies, and ensure reporting accuracy.
• Familiarity with AI tools such as ChatGPT, Claude, Copilot and their applications.