Junior Application and SQL Developer

About SGS

We are SGS – the world’s leading testing, inspection and certification company. We are recognized as the global benchmark for quality and integrity. Our 93,000 employees operate a network of 2,600 offices and laboratories, working together to enable a better, safer and more interconnected world.

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.

Requirements

•  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.
•  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.