Python & VBA Developer

University Degree in IT, combined with 7 years of relevant IT professional experience;University degree in Computer Science, Information Systems, Engineering, or a related technical field, with practical knowledge in software development, databases, and small-scale system design. A solid foundation in software and database development is required to support data pre-processing and automation of business activities;At least 5 years of professional experience in software development;At least 5 years of professional experience with Microsoft SQL Server (T-SQL, SSIS, schema design, stored procedures, performance tuning);Proficiency with Python and frameworks for web development, data manipulation and automation;Proficiency with VBA applications (Excel, Access) including VBA scripting for developing automation scripts, data import/export utilities, and pre-processing tools;Good knowledge of the design, documentation and development of full stack solutions;Proficiency with Microsoft Power BI (data modelling, DAX, dashboards, reporting) for providing advanced visualization and reporting capabilities to support operational analysis;Proficiency in ETL processes and data-preparation technologies, including tools such as SQL Server Integration Services (SSIS), Power Query and Neo4j data-import or ETL utilities;Good working knowledge of version control systems (e.g., Git);Good working knowledge of relational database development, with a focus on Microsoft SQL Server, including data modelling, schema design, T-SQL, stored procedures, functions and query optimisation;Good working knowledge of application security, authentication, and authorisation concepts, including OAuth 2.0 and OpenID Connect;Good knowledge of agile software development methodologies with practical experience using Azure DevOps for backlog management, planning, source control, CI/CD pipelines and work tracking;Good knowledge and display of prerequisites of working in a flexible environment including participation in multi-lingual meetings, ease of communication, exposure to an international/multi-cultural environment, etc;Good knowledge of preparing and maintaining technical documentation for developed solutions;Good working knowledge of containerisation using Docker. Familiarity with container orchestration tools such as Kubernetes is an advantage;Knowledge of Microsoft .NET (C#) and ASP.NET Core will be an asset;Good knowledge of using Linux shell and basic Linux concepts (e.g., users, groups, rights) will be an asset;Good knowledge of Elasticsearch for indexing and querying complex, large or unstructured datasets; Excellent command of the English language