Business Intelligence Analyst-PV

Business Intelligence Analyst-PV Location 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-5pm Top 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 analytics Able to maintain data integrity, support validation documentation, and deliver clear insights to stakeholders Comfortable working across multiple reporting tools and adapting to evolving platforms Summary: 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 & Reporting Build and continuously improve analytics models and dashboards to provide insights into efficiency, quality, KPIs, and stakeholder feedback Develop, 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 processes Aggregate, query, and analyze data to generate actionable insights and answer key business questions Run recurring and ad hoc reports and present findings to leadership and stakeholders Support monthly reporting and quarterly business reviews (activities, outcomes, trends) Analyze stakeholder feedback/complaints and collaborate with functional leads to propose solutions Ensure data integrity, traceability, and accuracy throughout the data lifecycle Support validation activities including creation of validation plans, test scripts, and summary reports Contribute to process improvement, innovation initiatives, and reporting enhancements Provide metric reporting and analytics support for GBDS/Patient Safety initiatives Required 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 layer Power 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 datasets Additional Tools (Preferred) Spotfire (preferred, not required) Familiarity with Tableau (nice to have, not required if Power BI expertise is strong) Domain Experience Pharmacovigilance / Drug Safety experience highly preferred Understanding of PV data structures, compliance reporting, KPIs, and trends Experience working with safety data and stakeholder-driven reporting Additional Qualifications: Bachelor's Degree required Strong analytical and strategic thinking skills Ability to synthesize complex data into clear insights Knowledge of data structures, taxonomies, and data governance concepts Experience with validation processes and documentation Advanced Client Office skills (Excel, PowerPoint, Word) Strong communication and presentation skills Ability to manage multiple priorities and projects simultaneously Proven ability to collaborate across cross-functional teams Strong problem-solving skills and ability to handle complex stakeholder situations Self-starter with a hands-on, execution-focused mindset (not a purely managerial role) High level of integrity and confidentiality Ideal 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 independently Troubleshoot data and reporting issues Deliver actionable insights to stakeholders Experience supporting Pharmacovigilance/Drug Safety analytics Comfortable working in evolving reporting environments and tools Key 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: Artech