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.
Business Insights and Analytics Advisor
Location
United States
Posted
7 days ago
Salary
Not specified
Seniority
Mid Level
No structured requirement data.
Job Description
Role 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.
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.
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.
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.
Required 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
Job 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.
- 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.
- Required 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
Related Guides
Related Categories
Related Job Pages
More Business Intelligence Analyst Jobs
This senior individual contributor role focuses on designing AI-augmented business processes to enable rapid scaling, handling increased volume and complexity while maintaining customer and employee experience. Responsibilities include leading current and future-state process design for priority functions and defining AI-owned versus AI-assisted workflows with necessary controls and metrics.
CDI Business Operations Analyst
Piedmont HealthcarePiedmont Healthcare delivers compassionate, quality care for the communities surrounding Atlanta, Georgia, and northern Georgia. The independent nonprofit healt
This position is responsible for implementing analytic goals and capturing data to measure, interpret, and report on business and clinical performance. Key responsibilities include: Designing and maintaining standard reports and dashboards. Developing analytics solutions that sup...
BI Data Analyst III
CredibleBringing simplicity, choice and unbiased support to life’s important financial decisions.
The analyst will partner with business functions within the Insurance team to understand their needs and produce dashboards and analytics solutions for effective execution. This includes defining key metrics, building performance monitoring reports, identifying data gaps, and developing requirements for data models.
Broker Reporting Analyst
Cambia Health SolutionsCambia Health Solutions is a nonprofit organization dedicated to changing healthcare through a “person-focused and economically sustainable system.” As an e
Broker Reporting Analyst providing analytical support for Cambia's health care operations
