Business Insights and Analytics Advisor at Johnson &… · Pittsburgh

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.

Job Function:

Technology Product & Platform Management

Job Sub Function:

Business Systems Analysis

Job Category:

Scientific/Technology

All Job Posting Locations:

Charlotte, North Carolina, United States, Horsham, Pennsylvania, United States of America, Orlando, Florida, United States of America, Phoenix, Arizona, United States, Pittsburgh, Pennsylvania, United States of America, Raleigh, North Carolina, United States

Job Description:

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.   

 

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

 Required Qualifications:

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

 

Preferred Qualifications:

• Python programming experience

• Familiarity with healthcare, specialty pharmacy, and/or HUB services

• Pharmacy experience including reporting on Pharmacy dispensing system data

• Data visualization

#Li-Remote

Johnson & Johnson is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, protected veteran status or other characteristics protected by federal, state or local law. We actively seek qualified candidates who are protected veterans and individuals with disabilities as defined under VEVRAA and Section 503 of the Rehabilitation Act. 

Johnson & Johnson is committed to providing an interview process that is inclusive of our applicants’ needs. If you are an individual with a disability and would like to request an accommodation, external applicants please contact us via https://www.jnj.com/contact-us/careers, internal employees contact AskGS to be directed to your accommodation resource.

 

 

Required Skills:

 

 

Preferred Skills:

Analytical Reasoning, Critical Thinking, Cross-Functional Collaboration, Data Savvy, Execution Focus, Human-Computer Interaction (HCI), Network Configuration Management, Operating Systems (OS), Problem Solving, Scripting Languages, Software Development Management, Systems Analysis, Systems Development, Systems Management, Technical Writing, Technologically Savvy