Sr. Data Engineer/Lead Data Engineer

Role : Sr. Data Engineer/Lead Data Engineer

Location : Canada - remote

Exp: 15+ Years

Must-Have Skills:

🔹 Snowflake – RBAC, Streams, Time Travel, Virtual Warehouse

🔹 Advanced SQL – Complex Queries, Stored Procedures, Views

🔹 ETL/ELT & Data Pipelines

🔹 Airflow / Azure Data Factory / Informatica / Matillion / dbt

🔹 Python / Java / C#

🔹 AWS / Azure / GCP

🔹 Data Warehousing & Data Modeling

🔹 Data Integration, Data Quality & Governance

⭐ Strong hands-on experience building and optimizing production data pipelines is required.

Requirements:

• Bachelor's or Master's degree in Computer Science, Data Science, or a related field
• 14+ years of experience in Information Technology
• 10+ years of experience as a Data Engineer or related role
• Strong SQL development experience including SQL queries and stored procedures
• Experience with data orchestration tools such as Apache Airflow, Azure Data Factory, Informatica, Matillion, dbt, or equivalent technologies.
• Hands on experience with a modern cloud data platform such as Snowflake or comparable platform.
• Experience integrating data from platforms such as SAP, Salesforce, Shopify, or similar enterprise applications.
• Strong experience building, maintaining and documenting data pipelines
• Expertise in Snowflake concepts like RBAC management, virtual warehouse, file format, streams, zero copy clone, time travel and understand how to use these features is preferred.
• Well versed in data standardization, cleansing, enrichment, and modeling
• Proficiency in one or more programming languages such as Python, Java, or C#
• Experience with cloud computing platforms such as AWS, Azure, or GCP
• Knowledge of ELT/ETL processes, data warehousing, and data modeling
• Familiarity with data security and governance best practices
• Excellent hands-on experience in problem-solving and analytical skills and improving the performance of processes
• Strong communication and collaboration skills