We are currently requesting resumes for the following position: Data Analyst
Resume Due Date: Friday, July 23nd, 2021 (5:00PM EST)
Number of Vacancies: 1
Duration: 12 months
Location: 800 Kipling, Toronto
- Support Report Automation across OPG by implementing VBA macros Power Automate flows.
- Support developing Robotic Process Automation tools to automate repetitive manual tasks using various Microsoft tools.
- Support data query creation from various databases in OPG.
- Develop front-end User Interfaces in Azure environment using tools such as Visual Studio.
- Support process automation by creating process maps across various OPG databases.
- Maintain the current automation flows by working with various business lines.
- Identifies opportunities for automation within processes using latest Robotic Process Automation (RPA) tools (i.e. UiPath, Blue Prism etc.).
- Excellent VBA programming skills.
- Ability to create and maintain quality solutions using VBA code and understand code written using VBA.
- Excellent skills with C# and .NET.
- Advanced user level MS Excel skill (i.e. VLOOKUP, Pivot table).
- Strong understanding of databases, including SQL/Oracle, database designing, querying and data manipulation.
- Experience writing store procedures in SQL/Oracle.
- Advanced understanding of Azure services and ability to suggest and deploy services.
- Ability to create linkage documents for various complex source systems.
- Excellent testing skills.
- Good understanding of data management and presentation skill.
- Excellent analytical and customer service skills required.
- Past experience of development and maintenance of the software product.