Primary Responsibilities
Support the maintenance, enhancement and daily operation of the site's internally developed application
through SQL queries, database programming and scripting.
Understand requirements and deliver data extraction, processing and reporting solutions.
Contribute to Computer System Validation (CSV) activities, ensuring the application and its data remain
compliant with GxP and data integrity requirements.
Specific Responsibilities
Write, test and optimize SQL queries, views, stored procedures and functions supporting application features,
data requests and reports.
Develop and maintain Perl (or similar) scripts for data processing, automation of recurring tasks and data
imports/exports from flat files and Excel.
Investigate and resolve application and data issues reported by users; document root cause and corrective
actions.
Perform data quality checks and reconciliations; support data corrections and migrations under change control.
Support CSV activities across the system lifecycle: draft and execute test scripts (IQ/OQ/PQ, UAT), record test
evidence, log deviations and maintain traceability matrices.
Apply data integrity principles (ALCOA+) and 21 CFR Part 11 / EU GMP Annex 11 requirements for audit trails,
electronic records and access controls.
Follow change and version control practices; prepare and maintain technical documentation (data models,
specifications, change records, user guides, SOP inputs).
At all times, complies with SGS Code of Integrity and Professional Conduct. Remains familiar with SGS quality
assurance procedures. Complies to all SGS QHSE and HR policies and procedures.
Performs other related duties as may be assigned either in support of departmental goals or for his/her personal
or professional training, education or development as programmed by his/her immediate superior.
Profile
Bachelor’s degree in computer science, Bioinformatics or related discipline, or equivalent experience.
2+ years of experience in SQL development and/or scripting and programming.
Experience with or strong interest in Computer System Validation (CSV) is an advantage.
Affinity with regulated environments (GxP, quality systems) is considered an asset.
Skills
Required:
Good verbal and written communication skills in English.
SQL (Microsoft SQL Server or equivalent RDBMS): joins, aggregations, views, stored procedures.
Perl or similar language (e.g., Python Delphi, VBS, C#, Java).
Microsoft Excel (advanced) and Office tools.
Strong problem-solving and analytical skills, critical thinking.
Well organized, stress-resistant, and able to work autonomously.