ALETHA is a dynamic, Toronto-based IT consulting boutique which strives for excellence in customer service and delivery in financial services and fintech industry. We focus on technology advisory, cloud computing, integration solutions, and enterprise big data and analytics. With a team of highly knowledgeable business and technical experts, we provide strategic, mission critical solutions to our clients.
ALETHA team has many years of business technology consulting experience and has delivered many successful projects in the financial and fintech industry. Our proven process and methodology together ensure quality service in a results-oriented environment. We attract and retain the best talent. Come and join us to explore new growth areas while building a solid career.
ALETHA 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.
Responsibilities
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 approaches).
Knowledge in data integration, REST-oriented API, Continuous Integration and Delivery (CI/CD) principles.
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 fintech).
Ability to work independently and excel in a team environment.