Sr. Data Engineer/Lead Data Engineer

Job summary

Build and optimize production data pipelines while managing data integration and quality. Responsible for implementing Snowflake features and ensuring efficient data warehousing and modeling.

Job details

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

What you’ll do

Build and optimize production data pipelines while managing data integration and quality. Responsible for implementing Snowflake features and ensuring efficient data warehousing and modeling.

Requirements

Requires 14+ years of IT experience with a strong focus on SQL development and cloud data platforms like Snowflake. A Bachelor's or Master's degree in Computer Science or a related field is required.

Listed skills

• Microsoft Azure · Preferred
• Amazon Web Services · Preferred
• Java · Preferred
• Google Cloud · Preferred
• C++ · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• Advanced SQL
• ETL/ELT
• Data Pipelines
• Apache Airflow
• Azure Data Factory
• Informatica
• Matillion
• dbt
• Python
• Java
• C#
• AWS
• Azure
• GCP
• Data Modeling

Job areas

• Data & Analytics
• Technology
• Software
• Engineering
• Consulting