21-050 – Data Analyst Automation

  • Type: Full-time
  • Job #177949
Job ID:

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


Job Overview:

  • 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.