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: validating that front-end metrics (e.g., on-time expedited reporting, open cases, follow-up rates) match SQL-driven counts in the database.

Other Competencies

• Strong technical expertise, analytical thinking, and the ability to translate complex data workflows into actionable insights for business and regulatory decision-making.
• Create and maintain technical documentation for SQL processes, data pipelines, and system interactions.
• Perform data validation and reconciliation across multiple systems or modules.
• Provide support during audits and inspections by supplying accurate data exports and process evidence.
• Excellent problem-solving and communication skills with attention to detail.
• Experience with Argus, Oracle, or PV data systems.
• Knowledge of ETL tools and data warehouse concepts.
• Understanding of regulatory data compliance (e.g., GxP, 21 CFR Part 11).
• Strong expertise in SQL (queries, joins, optimization, troubleshooting).
• Experience working in pharmaceutical, life sciences, or regulatory data environments preferred.