Data Engineering-PostgreSQL

Analyst activities

• Functional experience and expertise in Pharmacovigilance
• Develop, maintain, and optimize data workflows within LSMV and LSLI systems.
• Design and manage SQL queries, stored procedures, and database models to support analytics and reporting needs.
• Collaborate with business, IT, and QA stakeholders to ensure data quality, integrity, and regulatory compliance.
• Support integration between LSMV, LSLI, and related platforms to enhance system performance and reporting.
• Analyze large-scale datasets to identify trends, anomalies, and improvement opportunities.

Testing activities

• Testing of scenarios in LSMV and LSLI based on the functionalities in all the environments.
• Using SQL to confirm that all cases, codes, and configurations migrated correctly and that key workflows still function (UAT plus backend validation).
• New reports or dashboards: validat...