LiveHire users cookies on this website. Cookies are small pieces of data stored by your browser on your computer or device to help run this site, improve security, and improve your experience.

Click Accept to continue, or for more information please see our Cookies Policy.

‹ Back to all jobs

21-050 - Data Analyst Automation

  • Work TypeContract/Temp
  • Positions1 Position
  • Published At:9 days ago
  • Job no: P6YNG
  • Category: Engineering

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.
  • Published on 20 Jul 2021, 3:59 PM