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.