Business Intelligence Analyst - Snowflake, Databricks, SSRS

Elsevier; Chicago (IL); On-site; USD 79,000 - 131,000; Full time

Benefits offered by this job

Annual incentive bonus

Job summary

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.

Qualifications

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

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.

Skills

SQL & BI tooling

Dashboard development

Data validation

Requirements gathering

AI tools familiarity

Tools

Snowflake

Databricks

SSRS

Tableau

Power BI

Looker

Job description

Are you a dedicated Business Intelligent Analyst (Snowflake, Databricks, SSRS) looking to build complex reports for our core Healthcare Education Team? About the role: 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. About the team- 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.

Elsevier employs 10,000 people worldwide, including over 2,500 technologists.

We have supported the work of our research and health partners for more than 140 years.

Growing from our roots in publishing, we offer knowledge and valuable analytics that help our users make breakthroughs and drive societal progress.

U.S. National Base Pay Range: $71,600 - $119,400.

Geographic differentials may apply in some locations to better reflect local market rates.

If performed in Illinois, the base pay range is $75,200 - $125,500.If performed in Chicago, IL, the base pay range is $78,700 - $131,400.

This job is eligible for an annual incentive bonus.

We know your well-being and happiness are key to a long and successful career.

We are delighted to offer country specific benefits.

We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120.

We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law. USA Job Seekers: EEO Know Your Rights.

Elsevier is a global leader in advanced information and decision support for science and healthcare.

We believe that by working together with the communities we serve, we can shape human progress to go further, happen faster, and benefit all.

We support continuous discovery and uphold the highest standards of content integrity, reliability, and reproducibility so the communities we serve can advance their field of science, healthcare or innovation with confidence.

By combining high-quality content with powerful analytics, we transform complexity into clarity and deliver mission-critical insights that help professionals make better decisions when it matters most.

We deliver insights that help research institutions, governments, and funders achieve their goals.

We help researchers discover and share knowledge, collaborate, and accelerate innovation.

We help librarians provide verified, quality information to universities.

We help innovators turn knowledge into new products.

We help health professionals improve patient care and educators train the next generation of doctors and nurses.

Connecting quality content and innovative technologies, we make progress go further and happen faster.

And by championing inclusion and sustainability, we ensure progress benefits all.

With 9,500 employees, over 2,300 technologists in 5 major tech hubs, and more than 60 locations across the globe, we are committed to supporting the scientific and healthcare communities around the world.

We offer a diverse range of opportunities across technology, commercial, business, and early career jobs.

If you are looking for a career that inspires progress in science, innovation and health, and allows you to grow every day, find your team at Elsevier.

Elsevier is part of RELX Group.

Let’s shape progress together.

Join us.

elsevier.com/about/careers