Azure Data Architect / Lead

IT - Systems Integration
Toronto, ON
Oct 20, 2021

Our client is a dynamic, Toronto-based IT consulting boutique which strives for excellence in customer service and delivery in financial services and fintech industry. They focus on technology advisory, cloud computing, integration solutions, and enterprise big data and analytics. With a team of highly knowledgeable business and technical experts, they provide strategic, mission critical solutions to our clients.

Their team has many years of business technology consulting experience and has delivered many successful projects in the financial and fintech industry. Their proven process and methodology together ensure quality service in a results-oriented environment. They attract and retain the best talent. 

Our client is looking for an Azure Data Architect/Lead, who has hands-on experience in data management, modeling, integration, tuning and database development on Azure and who will contribute to successfully deliver hybrid data integration or custom application development projects in the Greater Toronto Area.


  • ?  Understand business requirements for data and information especially in the financial services industry.

  • ?  Responsible for overall design and update of logical and physical data models (in Azure SQL) based on business requirements.

  • ?  Design partitioning strategy as well as indexing.

  • ?  Conduct performance tuning on Azure SQL.

  • ?  Design and implement archival strategy.

  • ?  Develop data mapping as needed.

  • ?  Develop database stored procedures based on Microsoft T-SQL as needed.

  • ?  Produce estimates for analysis, design, development, and testing.

  • ?  Lead, mentor, and coach other junior members on client engagements.

  • ?  Ensure compliance with business, data, and technical requirements.

  • ?  Ensure that client’s enterprise architecture standards, policies, and procedures are followed.


  • ?  Minimum Bachelors degree in Computer Science or Engineering.

  • ?  Minimum 8 years experience in Information Technology, participating in complex projects.

  • ?  Minimum 2 years with Azure SQL databases and Azure environment.

  • ?  Strong communication skills.

  • ?  Strong knowledge in T-SQL and management of Azure SQL databases.

  • ?  Strong knowledge in database monitoring and performance tuning in Azure SQL databases

    (standalone or Managed Instance).

  • ?  Experience with Change Data Capture (CDC) tools

  • ?  Experience with Data Migration tools like SQL Server Migration Assistant (SSMA)

  • ?  Experience in working with Change Data Capture (CDC) data

  • ?  Azure Event Hub experience is preferred

  • ?  Familiar with capabilities of Azure platform services related to data management (e.g. Compute,

    Storage, Integration, Data, Security, or Management).

  • ?  Knowledgeable in both relational and dimensional data modeling (with both Kimball and Inmon


  • ?  Knowledge in data integration, REST-oriented API, Continuous Integration and Delivery (CI/CD)


  • ?  Knowledge of SWIFT messages (MT Series 1, 2, 3, etc), ISO20022 based payments is preferred.

  • ?  Good overall business knowledge in financial industries (i.e. one or more in retail banking,

    commercial banking, capital markets, wealth management, insurance, pension fund, and


  • ?  Ability to work independently and excel in a team environment.

Send to Friend

Send to Friend