Snowflake Data Engineer

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.

Core Technical Skills

1. Strong experience with Snowflake (data modeling, ELT pipelines, performance tuning)
2. Experience integrating data from SAP S/4HANA or similar ERP systems
3. Solid SQL expertise and data warehousing concepts (star schema, dimensional modeling)
4. Hands-on experience with ETL/ELT tools (e.g., ADF, Informatica, Talend, DBT, or similar)
5. Data Quality & Governance
6. Experience working with Ataccama (preferred) OR similar data quality tools (Informatica DQ, Collibra, etc.)
7. Understanding of data governance, validation frameworks, and metadata management
8. Programming & Cloud
9. Proficiency in Python / PySpark (preferred)
10. Experience with cloud platforms (Azure, AWS, or GCP)
11. Exposure to orchestration tools (Airflow, ADF pipelines, etc.)

Nice to Have

1. Prior experience in SAP data models (FI, SD, MM, etc.)
2. Knowledge of real-time ingestion frameworks
3. Experience in data migration or transformation programs
4. Snowflake certifications (e.g., SnowPro Data Engineer)

Soft Skills

1. Strong analytical and problem-solving skills
2. Ability to work in cross-functional environments
3. Clear communication with both technical and business stakeholders

Data Engineering & Integration

1. 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)
2. Snowflake Platform Development
3. Develop and optimize data models, schemas, and pipelines within Snowflake
   Manage performance tuning including:
4. Query optimization
   Warehouse sizing

Data partitioning and clustering

1. Implement best practices for cost and performance optimization
2. Data Quality & Governance (Ataccama)
3. Integrate and support Ataccama for:
4. Data quality rules
5. Data validation framework

Data profiling and monitoring

1. Ensure data consistency between source (S/4HANA) and target layers
   Collaborate on data governance, metadata, and lineage initiatives
2. Collaboration & Stakeholder Engagement
3. 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
4. Operational Excellence
5. Monitor data pipelines and resolve production issues
   Implement logging, alerting, and data validation mechanisms
   Support CI/CD and DevOps practices for data pipeline deployment