We are seeking a skilled Snowflake Data Engineer to support enterprise data transformation initiatives involving SAP S/4HANA source systems, Snowflake cloud data platform, and Ataccama for data quality and governance. The role focuses on building scalable data pipelines, enabling seamless data movement, and ensuring high-quality, governed data delivery for downstream analytics and business consumption.

Requirements Core Technical Skills

Solid experience with Snowflake (data modeling, ELT pipelines, performance tuning)

Experience integrating data from SAP S/4HANA or similar ERP systems

Solid SQL expertise and data warehousing concepts (star schema, dimensional modeling)

Hands-on experience with ETL/ELT tools (e.g., ADF, Informatica, Talend, DBT, or similar)

Data Quality & Governance

Experience working with Ataccama (preferred) OR similar data quality tools (Informatica DQ, Collibra, etc.)

Understanding of data governance, validation frameworks, and metadata management

Programming & Cloud

Proficiency in Python / PySpark (preferred)

Experience with cloud platforms (Azure, AWS, or GCP)

Exposure to orchestration tools (Airflow, ADF pipelines, etc.)

Nice to Have

Prior experience in SAP data models (FI, SD, MM, etc.)

Knowledge of real-time ingestion frameworks

Experience in data migration or transformation programs

Snowflake certifications (e.g., SnowPro Data Engineer)

Soft Skills

Strong analytical and problem-solving skills

Ability to work in cross-functional environments





Clear communication with both technical and business stakeholders

Responsibilities

Design, develop, and maintain end-to-end ETL/ELT pipelines for data extraction from SAP S/4HANA into Snowflake Build scalable data ingestion frameworks (batch and/or real-time) for structured and semi-structured data Implement transformation logic using SQL, Snowflake features (Streams, Tasks), or supporting tools (e.g., Spark/ADF/DBT if applicable)

Snowflake Platform Development

Develop and optimize data models, schemas, and pipelines within Snowflake Manage performance tuning including:

Query optimization Warehouse sizing

Data partitioning and clustering

Implement best practices for cost and performance optimization

Data Quality & Governance (Ataccama)

Integrate and support Ataccama for:

Data quality rules

Data validation framework

Data profiling and monitoring

Ensure data consistency between source (S/4HANA) and target layers Collaborate on data governance, metadata, and lineage initiatives

Collaboration & Stakeholder Engagement Work closely with business analysts, SAP teams, and data architects Translate functional requirements into technical pipeline design Provide support during testing, validation, and production deployment

Operational Excellence Monitor data pipelines and resolve production issues Implement logging, alerting, and data validation mechanisms Support CI/CD and DevOps practices for data pipeline deployment

#J-18808-Ljbffr

📌 Snowflake Data Engineer (Mississauga)
🏢 Billennium
📍 Mississauga