IT & Software

Snowflake Data Engineer

Billennium

Mississauga · Peel Region · Canada

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

  • Strong 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

Reference: WJ-3875_13858302

Apply now

Continue on the employer's official application - the same link they use for every candidate.

More jobs

Find more on GigBlows

This role is listed on GigBlows for discovery and search. Hiring decisions and applications are handled by the employer or their chosen application system.