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