Business Intelligence Analyst-PV

Business Intelligence Analyst-PVOnsite/Hybrid: 50% onsite Site Locations: Lawrenceville, NJ (50% onsite) or Madison, NJ (50% onsite) or New Brunswick (NBR), NJ (50% Onsite) or Princeton Pike (PPK), NJ (50% Onsite) Work Schedule: Mon–Fri | 8:00 AM – 5:00 PMSummary: Business Intelligence Analyst-PV, part of the PV Analytics Center of Excellence within Patient Safety (PS), is responsible for the hands-on execution of data analytics, reporting, and visualization activities supporting Pharmacovigilance/Drug Safety operations. This role is highly execution-focused and requires deep, practical experience working directly with reporting tools and data systems. The candidate will support scientific, operational, and regulatory reporting needs by developing actionable insights, maintaining reporting environments, and enabling informed decision-making across Patient Safety (PS).

The role reports to the Associate Director, PV Analytics Center of Excellence and requires strong technical expertise combined with the ability to work cross-functionally and independently deliver high-quality analytics.Key ResponsibilitiesData Analytics & ReportingBuild and continuously improve analytics models and dashboards to provide insights into efficiency, quality, KPIs, and stakeholder feedbackDevelop, maintain, and enhance reporting databases and analytics applications (SAP Business Objects, Power BI, SQL environments, and others)Independently build, modify, and troubleshoot reports and dashboards (hands-on execution required)Utilize internal systems and tools to streamline data retrieval and reduce manual processesAggregate, query, and analyze data to generate actionable insights and answer key business questionsRun recurring and ad hoc reports and present findings to leadership and stakeholdersSupport monthly reporting and quarterly business reviews (activities, outcomes, trends)Analyze stakeholder feedback/complaints and collaborate with functional leads to propose solutionsEnsure data integrity, traceability, and accuracy throughout the data lifecycleSupport validation activities including creation of validation plans, test scripts, and summary reportsContribute to process improvement, innovation initiatives, and reporting enhancementsProvide metric reporting and analytics support for GBDS/Patient Safety initiativesRequired Skills & ExperienceCore Technical Expertise (Must-Have)SAP Business Objects (BO)Strong experience required (Version 4.3 preferred)Version 4.1 acceptable only if paired with strong overall experience and advanced Power BI skillsMust be able to actively develop navigate reportsCreate and update semantic layerPower BIAdvanced level required (3–4+ years hands-on experience)Expertise in building interactive dashboards and data modelsPrimary reporting tool (Tableau has been phased out)SQLAdvanced proficiency requiredAbility to independently query, manipulate, and analyze complex datasetsAdditional Tools (Preferred)Spotfire (preferred, not required)Familiarity with Tableau (nice to have, not required if Power BI expertise is strong)Domain ExperiencePharmacovigilance / Drug Safety experience highly preferredUnderstanding of PV data structures, compliance reporting, KPIs, and trendsExperience working with safety data and stakeholder-driven reportingAdditional QualificationsBachelor's Degree requiredStrong analytical and strategic thinking skillsAbility to synthesize complex data into clear insightsKnowledge of data structures, taxonomies, and data governance conceptsExperience with validation processes and documentationAdvanced Microsoft Office skills (Excel, PowerPoint, Word)Strong communication and presentation skillsAbility to manage multiple priorities and projects simultaneouslyProven ability to collaborate across cross-functional teamsStrong problem-solving skills and ability to handle complex stakeholder situationsSelf-starter with a hands-on, execution-focused mindset (not a purely managerial role)High level of integrity and confidentialityIdeal Candidate ProfileStrong hands-on experience with:SAP Business Objects (preferably 4.3)Power BI (advanced, 3–4+ years)SQL (advanced querying and data manipulation)Demonstrated ability to:Build and maintain reports independentlyTroubleshoot data and reporting issuesDeliver actionable insights to stakeholdersExperience supporting Pharmacovigilance/Drug Safety analyticsComfortable working in evolving reporting environments and toolsKey DifferentiatorThis is a hands-on analytics role — candidates must demonstrate the ability to execute, build, and problem-solve within reporting tools, not just oversee or manage reporting processes.