Software Developer (VBA developer with Python skills)
Summary
Develops and maintains VBA solutions for Microsoft Access/Excel, migrates legacy systems to SQL Server, and uses Python for web development, ETL, and scripting while ensuring secure coding and documentation.
- 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.