Python & VBA Developer

ThoughtLabs Belgium; Den Haag; On-site; EUR 70,000 - 110,000; Full time

Job summary

ThoughtLabs Belgium is seeking a seasoned software engineer to design and optimize data-driven web solutions, ETL pipelines, and scalable BI reporting.

In the role you will use Python, Microsoft SQL Server, SSIS, and Power BI, while automating tasks with VBA and building secure, well-documented code.

You'll collaborate with cross-functional teams, ensure robust data governance, and contribute to multi-language, international projects in English.

Qualifications

• University degree in IT or related field with strong software development background.
• At least 5 years of professional software development experience.
• Extensive experience with Microsoft SQL Server (T-SQL, SSIS, performance tuning).
• Proficiency in Python for web development, data manipulation, automation, and ETL tasks.
• Proficiency with VBA (Excel/Access) for automation and data handling.
• Strong knowledge of full-stack development, data modeling, and reporting.
• Hands-on experience with Power BI for data visualization and analytics.
• Familiarity with version control (Git) and CI/CD pipelines.
• Experience with Docker; Kubernetes is a plus.
• Knowledge of .NET (C#) and ASP.NET Core is an asset.
• Experience with Linux shell and basic Linux concepts is a plus.
• Experience with Elasticsearch for indexing and querying large datasets.
• Excellent command of English.

Skills

Python

SQL Server

Power BI

ETL

VBA

Azure DevOps

Git

Docker

Kubernetes

C#

ASP.NET Core

Data modeling

Security

Documentation

English proficiency

Education

University Degree in IT

University degree in Computer Science or related field

Tools

Microsoft SQL Server

SSIS

Power Query

Neo4j

Linux

Elasticsearch

OpenID Connect

Azure DevOps

Git

Docker

Kubernetes

VS Code

Excel/VBA

Job description

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