Database Analyst

Remote

12+ months

The Systems / Data Analyst will support the Global Technical Services (GTS) team within the Pharma & Lens Care Solutions business by designing, developing, and maintaining systems, databases, and reporting tools that enable operational excellence and informed decision-making. This role will translate complex business requirements into scalable technical solutions, building the infrastructure that enables GTS leadership to monitor performance, manage risks, and execute strategic priorities.

As the primary Planisware System Administrator for GTS, this individual will own the platform's configuration, governance, user access, and overall user experience. The role will also work across multiple business systems, including Planisware, SharePoint, Microsoft Power BI, Copilot, and the broader Microsoft Office Suite. The ideal candidate will bring a combination of technical expertise, analytical capabilities, systems thinking, and stakeholder management skills, with the ability to drive automation, process improvements, and data-driven decision-making in a global business environment.

• Serve as the Subject Matter Expert (SME) and primary system administrator for Planisware within GTS.
• Own platform configuration, user access management, system governance, and ongoing enhancements.
• Partner with IT and global stakeholders to ensure optimal platform performance and user experience.

• Design, deploy, and continuously improve GTS systems and data platforms.
• Develop and maintain SharePoint sites, project tracking tools, and enterprise reporting infrastructure.
• Collaborate with IT to troubleshoot system issues, manage routine updates, and ensure seamless data integration across multiple sites.

• Develop, maintain, and optimize KPI dashboards, scorecards, and performance reports using Power BI and other reporting tools.
• Collect, consolidate, and analyze data from multiple sources.
• Translate complex data into actionable insights and evidence-based recommendations for leadership.

• Build and manage systems supporting annual planning cycles, milestone tracking, and portfolio-level reporting.
• Develop reporting solutions that help leadership monitor operational performance and strategic priorities.
• Support performance monitoring, accountability, and management decision-making.

• Gather and analyze business requirements and translate them into technical and functional specifications.
• Identify opportunities to automate, streamline, and simplify business processes.
• Drive continuous improvement initiatives by identifying operational gaps, bottlenecks, and process inefficiencies.

• Establish and maintain efficient data archiving and records management systems.
• Ensure data integrity and compliance with internal SOPs and applicable regulatory standards.
• Maintain system documentation, work instructions, and training materials.

• Leverage Microsoft Power BI, Copilot, and other AI tools to develop self-service reporting solutions.
• Identify opportunities to use technology and automation to improve team efficiency.
• Enable data-driven insights and executive decision-making.

• Collaborate with cross-functional stakeholders across GTS, R&D, Supply Chain, Regulatory Affairs, Quality, and Finance.
• Ensure systems and reporting solutions are aligned with business requirements and effectively adopted.
• Communicate system updates and analytical findings clearly to technical and non-technical stakeholders across global teams.

• Perform other duties and responsibilities as assigned in support of evolving GTS business priorities.

• Bachelor's degree in Information Systems, Data Analytics, Computer Science, Life Sciences, Engineering, or a related field.
• 5-8 years of experience in Systems Analysis, Data Analysis, Business Analysis, or a similar role.
• Experience working in the pharmaceutical, biotechnology, or other regulated industries is strongly preferred.
• Hands-on experience with Planisware or another enterprise Project Portfolio Management (PPM) system as a system administrator or power user is required.
• Prior experience configuring, administering, and maintaining Planisware in a pharmaceutical or…