Business Insights and Analytics Advisor

Johnson & Johnson Innovative Medicine•Horsham, PA

3d•Remote

About The Position

At Johnson & Johnson, we believe health is everything. Our strength in healthcare innovation empowers us to build a world where complex diseases are prevented, treated, and cured, where treatments are smarter and less invasive, and solutions are personal. Through our expertise in Innovative Medicine and MedTech, we are uniquely positioned to innovate across the full spectrum of healthcare solutions today to deliver the breakthroughs of tomorrow, and profoundly impact health for humanity. Learn more at jnj.com. As guided by Our Credo, Johnson & Johnson is responsible to our employees who work with us throughout the world. We provide an inclusive work environment where each person is considered as an individual. At Johnson & Johnson, we respect the diversity and dignity of our employees and recognize their merit. Our expertise in Innovative Medicine is informed and inspired by patients, whose insights fuel our science-based advancements. Visionaries like you work on teams that save lives by developing the medicines of tomorrow. Our Immunology team leads in the development of transformational medicines for immunological disorders and illnesses. You can influence where medicine is going by restoring health to millions of people living with immune diseases. Join us in developing treatments, finding cures, and pioneering the path from lab to life while championing patients every step of the way. Learn more at https://www.jnj.com/innovative-medicine We are searching for the best talent for a Business Insights & Analytics Advisor to be located in Pittsburgh, PA, Horsham, PA, Raleigh, NC, Charlotte, NC, Orlando, FL, or Phoenix, AZ. Purpose: The Business Analytics and Insights Advisor will develop and interpret operational insights from reports and dashboards across multiple systems and workflows. This role will work closely with business, IT and operational stakeholders to fully understand the workflow and data structures. The advisor will analyze the data, develop insights, and present reporting options for leadership to enhance operational excellence. A strong understanding of workflows stakeholder engagement will be critical to this role's success. An ideal candidate will possess both operational and analytics experience, demonstrating enthusiasm for integrating data and process improvements. Candidates should be skilled in retrieving data from CRMs and pharmacy dispensing systems and interested in championing technical solutions that streamline workflows.

Requirements

Bachelor’s degree in information technology or related education.
A minimum of 2 years’ experience with SQL reporting.
Knowledge of Excel (e.g., macros, pivot tables, advanced charts/graphs, conditional formatting, data tables, basic programming)
Experience building CRM reports and dashboards, preferably in SalesForce.
Prior experience with diverse analysis tools and report generating technologies such as PowerBI, Tableau, SSMS, and Snowflake
Ability to develop strong working relationships with internal and external stakeholders
Demonstrated ability to build and utilize broad datasets to find commonalities and extract operational insights
Strong analytical skills with attention to detail
Ability to manage multiple deliverables within a fast-paced environment.

Nice To Haves

Python programming experience
Familiarity with healthcare, specialty pharmacy, and/or HUB services
Pharmacy experience including reporting on Pharmacy dispensing system data
Data visualization

Responsibilities

Collect, analyze and present data to stakeholders via reports, dashboards, and in meetings with technical and non-technical stakeholders.
Develop performance analytics in support of key business initiatives.
Defining and delivering KPI reporting to meet operational objectives.
Generate impactful insights into workflow and performance through report creation and analysis.
Produce monthly and quarterly KPI reports.
Manage ad hoc projects to align reporting with business needs.
Enhance reporting capabilities and collaborate on future state reporting solutions.
Ensure data integrity from various sources prior to distribution.
Work with management to define data needed for operational objectives.
Support leadership in analyzing trends shown in data sets.
Identify reporting opportunities for new operational workflows.
Collaborate with cross-functional teams for effective reporting solutions.
Serve as a subject matter expert on automation and analytics initiatives.
Up to 10% travel
Other duties as assigned