We are seeking a skilled Snowflake Data Engineer to support enterprise data transformation initiatives involving SAP S/4 HANA 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.RequirementsCore Technical SkillsStrong experience with Snowflake (data modeling, ELT pipelines, performance tuning)Experience integrating data from SAP S/4 HANA or similar ERP systemsSolid 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 & GovernanceExperience working with Ataccama (preferred) OR similar data quality tools (Informatica DQ, Collibra, etc.)Understanding of data governance, validation frameworks, and metadata managementProgramming & CloudProficiency in Python / Py Spark (preferred)Experience with cloud platforms (Azure, AWS, or GCP)Exposure to orchestration tools (Airflow, ADF pipelines, etc.)Nice to HavePrior experience in SAP data models (FI, SD, MM, etc.)Knowledge of real-time ingestion frameworksExperience in data migration or transformation programsSnowflake certifications (e.G.,



Snow Pro Data Engineer)Soft SkillsStrong analytical and problem-solving skillsAbility to work in cross-functional environmentsClear communication with both technical and business stakeholdersResponsibilitiesDesign, develop, and maintain end-to-end ETL/ELT pipelines for data extraction from SAP S/4 HANA into SnowflakeBuild scalable data ingestion frameworks (batch and/or real-time) for structured and semi-structured dataImplement transformation logic using SQL, Snowflake features (Streams, Tasks), or supporting tools (e.G., Spark/ADF/DBT if applicable)Snowflake Platform DevelopmentDevelop and optimize data models, schemas, and pipelines within SnowflakeManage performance tuning including:Query optimizationWarehouse sizingData partitioning and clusteringImplement best practices for cost and performance optimizationData Quality & Governance (Ataccama)Integrate and support Ataccama for:Data quality rulesData validation frameworkData profiling and monitoringEnsure data consistency between source (S/4 HANA) and target layersCollaborate on data governance, metadata, and lineage initiativesCollaboration & Stakeholder EngagementWork closely with business analysts, SAP teams, and data architectsTranslate functional requirements into technical pipeline designProvide support during testing, validation, and production deploymentOperational ExcellenceMonitor data pipelines and resolve production issuesImplement logging, alerting, and data validation mechanismsSupport CI/CD and Dev Ops practices for data pipeline deployment#J-18808-Ljbffr

📌 Snowflake Data Engineer (Mississauga)
🏢 Billennium
📍 Mississauga