Python & VBA Developer

We currently have a vacancy for a Python & VBA Developer fluent in English,to offer his/her services as an expert who will be based in The Hague, Netherlands. In the context of the first assignment, the successful candidate will be integrated in the team of the company that will closely cooperate with a major client’s IT team on site.

Your Tasks

• Use Python for the development of web solutions and scripting;
• Write and debug complex VBA solutions in Microsoft Access;
• Contribute to the migration of Access based solutions to SQL Server and other technologies;
• Perform ETL (enhance, transform, load) on complex datasets;
• Use Power BI to provide visualization and insights;
• Liaise with other technical Teams in order to push new features / changes to production;
• Write and maintain technical documentation of the solution implemented;
• Account for secure coding practices, as well as logging and auditing features.

Requirements

• 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;