Data Engineer Lead
Must Have Technical/Functional Skills
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.
Experience in TSQL programming along with Azure Data Factory framework and Python scripting;
A minimum of 10 years experience with large SQL data marts with at least 3 years of experience as Tech Lead
Strong analytical skills multi-tasking working against tight deadlines and active hands-on management of work
Challenge mindset and attention to detail to complex issues
Expert relational database experience.
Candidate should demonstrate ability to navigate through massive volumes of data to deliver effective and efficient data extraction design load and reporting solutions to business partners
Minimum 8 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
Financial institution data mart experience is an asset.
Experience 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