Lead Business Intelligence Analyst Florham Park, NJ

Data Analyst

This role is responsible for data aggregation, data quality, reporting, and trend analysis to evaluate program and pharmacy performance. The individual must be skilled in querying and analyzing data, while also supporting end users in interpreting and visualizing insights. Success in this role requires translating business needs into technical solutions that drive accurate and actionable reporting.

• Translate business requirements into technical specifications to support data analysis and visualization
• Develop a strong understanding of stakeholder objectives to create clear, impactful dashboards and reports
• Write SQL queries and generate reports by extracting accurate data from multiple databases
• Design and build interactive dashboards and reports using Power BI
• Analyze data to identify trends, optimize processes, and deliver timely insights
• Evaluate datasets for accuracy, completeness, and scope; explain anomalies or inconsistencies
• Support pharmaceutical manufacturer clients with data requests, reporting, and insights
• Aggregate data from multiple sources to support reporting needs
• Investigate and resolve data discrepancies using SQL or statistical analysis tools
• Manage daily reporting and trend analysis for multiple programs
• Ensure reports meet program requirements and are delivered accurately and on time
• Collaborate effectively with cross-functional teams to achieve shared objectives
• Develop reporting solutions by assessing information needs, consulting with users, analyzing workflows, and following the software development lifecycle
• Maintain compliance with all applicable healthcare data privacy regulations, including HIPAA

Performance is measured by the accuracy, quality, and timeliness of reporting, as well as effective communication with internal teams and external stakeholders. Meeting performance targets across assigned programs is essential.