Azure Data Analyst

About this role

This role is hybrid and requires you to be at our downtown Toronto and/or Client office at a minimum 2 days per week - subject to change at any time.

The Azure Data Analyst will play a critical role in designing, analyzing, and delivering enterprise‑scale data solutions within an Azure cloud ecosystem. This role requires a strong combination of data design expertise, business analysis skills, and domain knowledge in personal banking products. The candidate will collaborate closely with business stakeholders, data engineers, and agile delivery teams to translate business needs into high‑quality, scalable data models and solutions.

Your future duties and responsibilities

Data Design & Architecture

• Design and maintain logical and physical data models aligned with business requirements and enterprise standards.
• Define end to end data mappings from source systems to target data platforms, ensuring accuracy and completeness.
• Perform data profiling to assess data quality, structure, and anomalies, and recommend remediation strategies.
• Support the definition of data standards, naming conventions, and reference data.

Azure & Databricks Development Support

• Collaborate with engineering teams to design data solutions using Azure services (e.g., Azure Data Lake, Synapse, Databricks).
• Work closely with Databricks developers to ensure data transformations align with approved data models.
• Review and validate data pipelines to ensure compliance with business rules and architectural guidelines.

Business Analysis & Banking Domain Engagement

• Partner with business stakeholders to gather, analyze, and document data and reporting requirements.
• Apply strong understanding of personal banking products (such as accounts, customers, transactions, lending, and payments) to data design decisions.
• Translate business processes and regulatory requirements into structured data representations.

SQL & Data Validation

• Write advanced SQL queries for data e...