21-050 - Data Analyst Automation

Number of Vacancies: 1

Level: MP4

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.

Qualifications:

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