Intermediate Data Analyst

HRbrain Inc.; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology consulting firm in Toronto is seeking a skilled Data Analyst to focus on data discovery and collaboration with Subject Matter Experts. The candidate will analyze complex datasets to provide actionable insights and ensure alignment with business needs. Required skills include proficiency in SQL and experience with BI tools such as Tableau or Power BI. A bachelor’s degree in a relevant field is necessary, and Spanish-speaking applicants are mandatory. This role offers the opportunity to significantly impact data-driven decision-making processes.

Qualifications

• 5 years of experience in data analysis, focusing on data discovery.
• Proven ability to deliver data-driven solutions.
• Strong proficiency in SQL for large datasets.

Responsibilities

• Identify and assess relevant datasets for business needs.
• Develop dashboards and visualizations.
• Present findings in clear, non-technical language.

Skills

Data analysis

Stakeholder engagement

SQL

Python

R

Tableau

Power BI

Data warehousing

ETL processes

Spanish-speaking

Education

Bachelor’s degree in Business Administration, Data Analytics, or Computer Science

Master’s degree

Tools

Tableau

Power BI

Job description

Story Behind the Need

Business group: Technology Program Management & Transformation – team that manages cloud data integration and governance for IB, providing efficient and standardised solutions that enable different business areas to access and use data securely and effectively. Project: International Banking – Data Migration and Transformation to Cloud. Mission: To develop and maintain a cloud platform that integrates data from various sources, standardises processes, and facilitates data publication for consumers and producers, ensuring quality, security and accessibility. Scope: The primary objective of this project is to design and implement a unified cloud data platform for IB across different countries. Impact: Efficient ingestion of data from multiple on‑premises sources to the cloud, data transformation and standardisation into organised layers (landing and standardisation zones), rapid data delivery for bank teams requiring reports, indicators or advanced analysis, and incorporation of reusable data products for transversal consumption across the organisation. The project prioritises agility in delivery, enabling tactical solutions (quick, connected to local sources) when necessary, while promoting progressive advancement toward fully cloud‑based strategic solutions.

Purpose

We are seeking a skilled Data Analyst with a strong focus on data discovery and collaboration with Subject Matter Experts (SMEs) to join our dynamic team. The ideal candidate will excel at identifying, exploring and analysing complex datasets to uncover actionable insights while working closely with SMEs to ensure data solutions align with business needs. This role requires strong analytical skills, effective communication and the ability to translate technical findings into business‑relevant recommendations.

Candidate Value Proposition

• Data Discovery & Exploration:
  • Identify, collect and assess relevant datasets from internal and external sources to support business objectives.
  • Perform exploratory data analysis (EDA) to uncover patterns, trends and anomalies.
  • Validate data quality, integrity and consistency, addressing issues through cleansing and preprocessing.
• SME Collaboration:
  • Partner with SMEs across departments (e.g., finance, marketing, operations) to understand business requirements and domain‑specific challenges.
  • Facilitate workshops, interviews and discussions to gather insights and refine data‑driven solutions.
  • Translate SME feedback into actionable data requirements and ensure alignment with analytical outputs.
• Data Analysis & Reporting:
  • Develop and maintain dashboards, visualisations and reports using tools such as Tableau, Power BI or similar.
  • Conduct statistical analysis and modelling to derive insights that inform strategic decisions.
  • Present findings to stakeholders in clear, non‑technical language, tailoring insights to audience needs.
• Process Improvement:
  • Identify opportunities to streamline data discovery processes and enhance data accessibility for SMEs.
  • Document data sources, methodologies and findings to support reproducibility and knowledge sharing.
  • Contribute to the development of data governance and best practices for data handling.

Required Skills

• 5 years of experience in data analysis, with a focus on data discovery and stakeholder engagement.
• Proven track record of working with SMEs to deliver data‑driven solutions.
• Proficiency in SQL for querying and manipulating large datasets.
• Experience with Python, R or similar for data analysis and visualisation, and with BI tools (e.g., Tableau, Power BI) for reporting and dashboard creation.
• Knowledge of data‑warehousing concepts and ETL processes.
• Spanish‑speaking candidates mandatory.

Nice‑to‑Have Skills

• Experience with cloud‑based data platforms (e.g., AWS, Azure, Google Cloud).
• Knowledge of advanced statistical techniques or machine‑learning fundamentals.
• Familiarity with Agile or Scrum methodologies.

Soft Skills

• Exceptional communication and interpersonal skills to engage with non‑technical SMEs.
• Strong problem‑solving skills and attention to detail.
• Ability to manage multiple priorities and deliver results in a fast‑paced environment.

Education

• Bachelor’s degree in Business Administration, Data Analytics, Computer Science or related field.
• Master’s degree is considered an asset.