Experience (Years): 6-8
Essential Skills:
- 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
- Minumum 5 years of troubleshooting 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 importing large 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
- Strong verbal and written communication skills
Job Types: Full-time, Fixed term contract
Schedule:
- 8 hour shift
- Monday to Friday
Ability to commute/relocate:
- Toronto, ON: reliably commute or plan to relocate before starting work (preferred)
Work Location: Hybrid remote in Toronto, ON
