Database Analyst

Database Analyst
Remote
12+ months
Position Summary
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.

Key Responsibilities
1. Planisware System Administration

• 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.

2. Systems Development & Management

• 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.

3. Reporting & Data Analytics

• 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.

4. Business Planning & Portfolio Management

• 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.

5. Business Analysis & Process Automation

• 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.

6. Data Governance & Compliance

• 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.

7. AI & Digital Enablement

• 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.

8. Stakeholder Management & Communication

• 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.

9. Additional Responsibilities

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

Required Qualifications & Experience

• 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 regulated environment is highly preferred.

Technical Skills

• Planisware: Hands-on experience in system administration, configuration, user management, and platform maintenance.
• Microsoft SharePoint: Site design, administration, and management.
• Microsoft Power BI: Proven experience developing, maintaining, and optimizing dashboards and reports.
• Microsoft Copilot & AI Tools: Experience leveraging AI capabilities for reporting, automation, and productivity enhancement.
• Microsoft Excel: Advanced Excel skills, including data analysis and reporting.
• SQL: Working knowledge of SQL for data querying and analysis.
• Microsoft Office Suite: Strong proficiency across Microsoft productivity and collaboration tools.

Additional Skills & Competencies

• Strong analytical and problem-solving skills with exceptional attention to detail and data accuracy.
• Ability to interpret complex datasets, identify trends, and provide actionable recommendations.
• Strong project management skills with the ability to manage multiple priorities from planning through execution.
• Excellent verbal and written communication skills.
• Ability to explain technical concepts to non-technical stakeholders.
• Strong stakeholder management and relationship-building capabilities.
• Ability to work effectively with global teams across different time zones.
• Continuous improvement and process optimization mindset.
• Ability to navigate ambiguity, take ownership, and drive initiatives independently.

Preferred Qualifications

• PMP or equivalent Project Management certification.
• Experience working in GxP-regulated environments.
• Knowledge of 21 CFR Part 11 compliance requirements.
• Experience administering enterprise systems within pharmaceutical or other highly regulated environments.