Data Engineer Lead

Requirements

• 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 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
• Qualifications : BACHELOR OF COMPUTER SCIENCE

Responsibilities

• Data extraction, design, load, and reporting solutions
• Troubleshooting and supporting large databases
• Database security issues, user access/management
• Designing database backup, archiving and storage, performance tuning

Benefits

Skills