Undergraduate Degree or Technical Certificate
A minimum of 5 years' experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners
Strong knowledge of Extraction Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks; establishing the cloud connectivity between different system like ADLS ,ADF, Synapse, Databricks etc
Minimum 5 years oftroubleshooting and Supporting large databases and testing activities; Identifying reporting, and managing database security issues, user access/management; Designing database backup, archiving and storage, performance tunning, ETL importinglarge volume of data extracted from multiple systems, capacity planning
Experience in TSQL programming along with Azure Data Factory framework and Python scripting
Financial institution data mart experience is an asset
Experience in .net application is an asset
Experience and expertise in Tableau driven dashboard design is an asset
Work well independently as well as within a team
Proactive, organized, excellent analytical and problem-solving skills
Flexible and willing to learn, can-do attitude is key
Bachelor's degree