Business Intelligence Analyst (Hybrid- Lawrenceville, NJ/ Madison, NJ/ New Brunswick, NJ)

Responsibilities

• Build and continuously improve analytics models and dashboards to provide insights into efficiency, quality, KPIs, and stakeholder feedback
• Maintain 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
• Agregate, 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

Requirements

• Advanced Power BI expertise (3-4+ years of hands-on experience)
• Strong dashboard development and data modeling capabilities
• Advanced SQL skills (advanced querying and data manipulation)
• Experience building, maintaining, and troubleshooting reports independently
• 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
• Pharmacovigilance/Drug Safety analytics experience is highly preferred
• Strong PowerPoint, Word, and Excel Skills