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

📌 Snowflake Data Engineer (Mississauga)
🏢 Billennium
📍 Mississauga