ARHS

Software Developer (VBA developer with Python skills)

Show
  • 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.
  • Bachelor’s 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 Microsoft .NET (C#) and ASP.NET 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)