Software Developer (VBA developer with Python skills)

Job description

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 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) Arηs Group, Part of Accenture, specializes in the management of complex public sector IT projects, including systems integration, informatics and analytics, solution implementation and program management. Our team helps lead clients through digital and information systems design, bringing expertise in a variety of areas ranging from software development, data science and security management to machine learning, cloud, and mobile development. Arηs Group was acquired by Accenture in July 2024.