Business Intelligence Analyst

Business Intelligence Analyst-PVLocation Options: Lawrenceville, NJ (50% onsite), Madison, NJ (50% onsite), New Brunswick (NBR), NJ (50% Onsite), Princeton Pike (PPK), NJ (50% Onsite) Duration: 12+ Months Pay Range: $54/hr. - $59/hr. Work Schedule: Mon-Fri 8am-5pmTop Skills:Strong hands-on experience with:SAP Business Objects (preferably 4.3)Power BI (advanced; 3–4+ years)SQL (advanced)Experience supporting Pharmacovigilance / Drug Safety analyticsAble to maintain data integrity, support validation documentation, and deliver clear insights to stakeholdersComfortable working across multiple reporting tools and adapting to evolving platformsSummary: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 Responsibilities:Data 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 & Experience:Core Technical Expertise (Must-Have)SAP Business Objects (BO) o Strong experience required (Version 4.3 preferred) o Version 4.1 acceptable only if paired with strong overall experience and advanced Power BI skills o Must be able to actively develop navigate reports o Create and update semantic layerPower BI o Advanced level required (3–4+ years hands-on experience) o Expertise in building interactive dashboards and data models o Primary reporting tool (Tableau has been phased out)SQL o Advanced proficiency required o Ability 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 Qualifications:Bachelor'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 Client 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 Profile:Strong 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 Differentiator:This 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.Working Conditions:Exposure to hazards or disagreeable conditions: