Lead Business Intelligence 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 Criteria

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.

• Bachelor’s degree required; Information Systems or related field preferred

• At least 2 years of experience working with pharmaceutical data in a collaborative environment

• Advanced proficiency in Microsoft Excel (pivot tables, charts, formulas, etc.)

• Strong experience with Power BI, including dashboard development and drill-through reporting

• Demonstrated ability to own and resolve data investigations, preferably using SQL Server Management Studio

• Client-facing experience with strong verbal and written communication skills

• Excellent presentation and teamwork abilities

• Hands-on experience with Microsoft SQL, including tables, views, stored procedures, and ad hoc queries, All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.

Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.