Senior Data Engineer

The Information Technology (IT) group at KLA is involved in every aspect of the global business. IT s mission is to enable business growth and productivity by connecting people, process, and technology. It focuses not only on enhancing the technology that enables our business to thrive but also on how employees use and are empowered by technology. This integrated approach to customer service, creativity and technological excellence enables employee productivity, business analytics, and process excellence.

• Design and implement robust ingestion patterns from SAP source systems (S/4HANA/ECC/BW/HANA) and other cloud source systems into Snowflake using enterprise-approved integration tools.
• Build and maintain incremental loads (CDC) , batch pipelines, and near-real-time ingestion where needed.
• Understand SAP functional domains and data structures (e.g., FI/CO, MM, SD, PP ) to map business requirements to data models.

• Develop and optimize ELT/ETL pipelines leveraging Snowflake capabilities (e.g., Snowpipe, Streams & Tasks, Dynamic Tables where applicable).
• Create and maintain curated dimensional and/or data vault models , conformed dimensions, and reusable fact tables for cross-functional analytics.
• Implement data quality checks , reconciliation controls (source-to-target), and exception handling for SAP extracts.

• Tune queries and pipelines for performance using clustering strategies, caching awareness, pruning, warehouse sizing, and workload separation.
• Monitor and manage Snowflake consumption and performance; recommend cost controls (warehouse scheduling, auto-suspend/auto-resume, resource monitors).

• Apply security best practices: RBAC , masking policies, row access policies, and secure data sharing patterns as needed.
• Partner with governance teams to maintain metadata, lineage, glossary alignment, and compliance standards.

• Collaborate with BI developers, analysts, and business stakeholders to translate requirements into scalable datasets.
• Contribute to Agile ceremonies and deliver iterative improvements with high engineering standards.
• Document pipelines, models, SLAs, and operational runbooks; participate in on-call/production support rotations as required.

• 5 7 years of experience in data engineering, with hands-on development in Snowflake .
• Strong experience integrating SAP data into analytics platforms or data warehouses.
• Strong SQL skills (advanced joins, window functions, query optimization); experience with performance tuning in cloud warehouses.
• Experience building production-grade pipelines using one or more of:
  • Orchestration: Informatica , ADF, dbt orchestration, or similar
  • Transformation: dbt , stored procedures, Snowflake SQL scripting, or equivalent
• Proficiency in Python (or comparable language) for automation, data processing, and pipeline utilities.
• Understanding of data modeling concepts (dimensional modeling, normalization, data vault basics).
• Experience with CI/CD practices (Git, code reviews, deployment pipelines) and environment management (dev/test/prod).

• Palantir Foundry experience (pipeline development, curated datasets, permissions/lineage) and Ontology experience (Objects/relationships).
• Familiarity with SAP S/4HANA data models and performance concepts (e.g., CDS views, HANA calculation views).
• Experience with BI/visualization tools ( Power BI, Tableau, Looker ) and building datasets optimized for reporting/semantic layers.