Apply data analysis, data modeling, and quality assurance techniques based upon a detailed understanding of business processes.
Develop and maintain specialist knowledge of database concepts, object and data modeling techniques and design principles.
Design, code, test, correct and document complex programs and scripts from agreed specifications.
Design and develop ETL mappings and workflows using Qlik or Informatica.
Mentor and provide technical guidance for Software Engineers.
Support technical consulting activities to clients in the pharmaceutical industry.
Provide application support for existing products.

Proven relevant experience in systems integration and implementation, or software development, or a related discipline.
Demonstrated ability to liaise with multiple stakeholders.
Experience with Microsoft Azure components in particular, Azure SQL, Azure Analysis Services, Synapse.
Experience implementing ETL solutions, particularly utilizing Qlik Replicate and Compose.
Strong Database Development Skills, particularly implementing SQL solutions in Azure SQL, Synapse or Databricks environments.
Good experience with large datasets.
Experience improving Data Quality in Data Warehouses, particularly utilizing Informatica Data Quality.
Experience testing ETL solutions, particularly utilizing Informatica DVO product.
Experience using Enterprise Architecture modeling tools, frameworks and methodologies such as TOGAF, SPARX EA, UML, BPMN, ArchiMate etc.
Experience Designing Data Warehouses, applying Kimball’s Dimensional Modeling Techniques, Architecting ETL systems.
Experience working in Agile development software methodology, authoring technical documents/specifications.
Experience debugging complex software systems.
Significant experience implementing data-driven systems with large-scale relational or object-oriented databases.
Ability to work in a high pressure, result/deadline-oriented environment.

Senior Software Engineer

Key skills