Login | Register

Intermediate Data/Business Analyst for medium to complex analytics projects involving 30+ application sources for our banking client - 27492

Job Type: Contract
Positions to fill: 1
Start Date: Oct 24, 2022
Job End Date: Sep 29, 2023
Pay Rate: Hourly: Negotiable
Job ID: 123570
Location: Toronto
Apply

Location Address: Hybrid - Downtown Toronto  
Contract Duration: ASAP to 09/29/2023
Extension: Possible – coverage for parental leave

Business group: GWRT Data and Analytics Technology
Project: Multiple projects, including: Trade 360 System, Caribbean CTMS, and Syndications Canada, etc

Typical Day in Role
• The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources within the distributed technical architecture to support client profitability and analytics for wholesale customers.
• The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources within the distributed technical architecture to support client profitability and analytics for wholesale customers.
• The incumbent supports technical peers in the team and collaborate with business partners, data engineers and cross functional IT teams to deliver complex, creative, cost-effective and robust operationally stable data solutions. This includes development of complex queries against big data that are required to ensure data are accessible for analytics and reporting by the data teams, as well as providing oversight of reporting solutions using Tableau, and/or other industry standard BI tools.
• Responsible for making recommendations and contribute within the development of medium to complex analytics projects in multiple environments/platforms (Linux/Python/Scala/Spark/Hadoop/mySQL/PostgresSQL/Hive/Unix/DevOps using Bitbucket/Jira/Jenkins) and supporting the sourcing and methodologies / ETL for 30+ application sources supporting Global Banking and Markets and Canadian Banking business lines in their client profitability and analytical processes.
• Supports a $8billion revenue business involving numerous business lines operating globally

Must Have Skills:
  • 5+ years of practical progressive IT Business Analyst experience in building and supporting complex systems using latest technologies/platforms
  • Must be able to understand, modify and develop SQL/database queries for data analysis and building of business requirements as well as technical specifications for JIRA tasks assigned to developers.
  • Experience with Python, Django programming
  • 3+ Years experience with Tableau for reporting
  • 3+ years working with Big Data databases (Postgres/mySQL/Hive) 
Nice-To-Have Skills:
  • Working knowledge of BI tools like Tableau and PowerBI would be an asset.
  • Working experience of development and deployment tools for DevOps (e.g. Pycharm/IntelliJ, Bitbucket/Github, Jenkins/Teamcity, JIRA, Confluence) would be an asset.
  • Cloud (GCP, Azure, AWS) exposure 
Degrees or certifications:
• Bachelor's degree in a related field required

Candidate Review & Selection
• Structure and Format: Two rounds of interview
o First round with HM and senior management
o Second round with developer