Business Intelligence Analyst - Pharmacovigilance Specialist

Location: Lawrenceville, NJ

Onsite Flexibility: Hybrid (50% onsite)

• Position Type: Contract
• Contract Duration: 12 months (conversion to FTE possible)
• Pay Rate: $58.74 / Hour (USD)
• Shift / Schedule: Monday Friday, 8:00 AM 5:00 PM
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

The Pharmacovigilance (PV) Analytics and Reporting Specialist, PV Analytics Center of Excellence is responsible for successful execution, and close-out of activities aligned with the overall vision, strategy, and objectives of the Global Biostatistics & Data Sciences Function. The PV Analytics and Reporting Specialist, PV Analytics Center of Excellence contributes to the ongoing development, implementation, and successful execution of the scientific, operational, and regulatory reporting efforts in line with the overall PS needs.

The PV Analytics and Reporting Specialist reports to the Senior Manager, PV Analytics Center of Excellence, within Global Biostatistics & Data Sciences. The PV Analytics and Reporting Specialist, PV Analytics Center of Excellence applies a combination of life sciences strategy, leadership, and reporting/visualization experience to drive successful servicing of information needs across PS. Responsibilities include, but are not limited to the following:

Data Analytics and Reporting

• Build and continuously improve data analytics through supporting models that provide insights into efficiency, quality, stakeholder feedback, and key performance indicators to drive timely and informed decision making
• Maintain and develop reporting databases and analytics applications in environments such as Excel, Tableau, Power BI, SAP Business Objects and/or other client environments
• Leverage internal data systems and tools to efficiently maintain data and reporting processes to minimize manual data retrieving
• Liaison with validation team to create validation test script, validation plan, validation summary report and test scripts
• Utilize data analysis tools to aggregate and analyze data to make actionable recommendations and answer key business questions
• Run and maintain reports regarding activities, outcomes, and be prepared to deliver presentations to management team on a regular and ad-hoc basis
• Collect data for monthly reports and quarterly reviews regarding activities, outcomes, and trends of the Advisor team
• Analyze key stakeholder complaints, address rapidly, and discuss with applicable functional leads to collaborate and propose impactful and realistic solutions
• Maintain data integrity and traceability across the transformation lifecycle from the Source to Target
• Support program and project team activities required to implement innovation initiatives
• Contribute to the management and prioritization of process improvement and innovation initiatives
• Define and provide metric reporting and data analysis for GBDS/PS initiatives including relevant insights to facilitate decision-making process

SAP Business Objects (BO) Version 4.3

• Advanced, hands-on experience required
• Proven ability to design, develop, and maintain complex reports
• Strong understanding of data modeling and report optimization within SAP BO
• Advanced experience with creating reports in SAP Business Objects version 4.3

Tableau & Power BI

• Advanced expertise required in both platforms
• Extensive experience developing interactive, user-friendly dashboards
• Strong visualization and storytelling skills using large and complex datasets
• Advanced Tableau or Power BI experience in creating interactive dashboards

Power BI (Advanced Requirement)

• Deep expertise in DAX, data modeling, performance tuning, and report automation
• Experience supporting enterprise-level Power BI deployments is strongly preferred

SQL

• Advanced proficiency required
• Strong experience using SQL for data extraction, transformation, validation, and analysis
• Ability to write complex queries and optimize performance
• Advanced SQL experience for data querying

Additional Required Skills

• Ability to organize/curate data and see big picture from scattered pieces of information
• Knowledge of taxonomies, ontologies, and other knowledge management constructs
• Analytical and strategic thinking skills required
• Strong PowerPoint, Word, and Excel skills
• Knowledge of validation processes and associated documentation
• Excellent verbal, writing, presentation, and project management skills
• Strong strategic orientation with ability to translate into operational priorities and plans
• Ability to promote cooperation and commitment within a team to achieve goals and deliverables
• Ability to resolve complex problems and manage difficult stakeholder situations
• Ability to lead the development of critical path analyses and support scenario planning
• Promotes and practices effective pro-active decision-making, ensuring timely coordination and…