Software Developer (VBA developer with Python skills)
The Hague - Netherlands
Job Summary
- Write and debug complex VBA solutions in Microsoft Access and Excel.
- Contribute to the migration of Access based solutions to SQL Server.
- Use Python for the development of web solutions and scripting.
- 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.
Qualifications :
- Bachelors degree in Computer Science Information Technology or a related field.
- Working knowledge of English: B2 level or higher
- At least 5 years of professional experience in software development
Mandatory:
- At least 5 years of professional experience with Microsoft SQL Server (T-SQL SSIS schema design stored procedures performance tuning).
- Good knowledge of SDLC best practices
- 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 with VBA applications (Excel Access) including VBA scripting for developing automation scripts data import/export utilities and pre-processing tools.
- Proficiency of ETL and data pre-processing frameworks (e.g. MS SQL Server SSIS T-SQL Power Query Neo4j ETL tools).
- Proficiency with Python for web development data manipulation and automation
- Knowledge of version control systems (e.g. Git TFS)
- Good knowledge of relational databases focusing on Microsoft SQL Server (schema design procedural scripting etc.)
- Good knowledge of Elasticsearch for indexing and querying complex large or unstructured datasets
- Good knowledge of agile software development methodologies
- 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.
Desirable:
- Knowledge of using containers (Docker) and container orchestrators (Kubernetes)
- Knowledge of (C#) and Core
- Good knowledge of using Linux shell and basic Linux concepts (e.g. users groups rights).
- Good Knowledge of graph databases design and queries (Neo4j)
- Good knowledge of CI / CD systems (e.g. Azure DevOps)
Remote Work :
No
Employment Type :
Full-time
About Company
Ar?s is a fully independent group of companies specialized in managing complex IT projects and systems for large organisations, focusing on state-of-the-art software development, business intelligence and infrastructure services. We are composed of 17 entities across 9 countries that ... View more