Junior Application and SQL Developer at Société Générale de Surveillance (SGS)

Job Description

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.

Qualifications

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.