Principal Platform Data Engineer, SAP

Responsibilities

• Own the SAP-to-Snowflake integration architecture using Alnylam’s common integration pattern — Fivetran for extraction, Snowflake as the enterprise lakehouse, and dbt for transformation and semantic modeling — ensuring reliable, governed, AI-ready data pipelines across all SAP domains.
• Design and optimize change data capture strategies across SLT replication, ODP extraction, ABAP CDS views, and Fivetran delta modes, balancing extraction latency, SAP system performance, and data completeness.
• Build canonical SAP data models in dbt that translate complex ERP table structures into intuitive, well-governed datasets in the Snowflake medallion architecture, including reusable macros for currency conversion, UOM handling, hierarchy flattening, and SAP-specific semantic layer definitions.
• Implement data quality monitoring, security architecture (RBAC, column masking, row-level security), and CI/CD pipelines for SAP data infrastructure, ensuring compliance with GxP, 21 CFR Part 11, and SOX requirements.
• Serve as the enterprise SAP data SME — leading architecture reviews, mentoring domain engineers, partnering with SAP Basis and functional teams, and representing Alnylam in vendor discussions with Fivetran, Snowflake, and SAP.
• Define the SAP data product roadmap and future-state integration architecture strategy, evaluating emerging capabilities including SAP Datasphere, SAP BTP, and Snowflake Native Apps as the ERP landscape evolves.

Qualifications

• 10+ years in data engineering with 5+ years focused on SAP data extraction, integration, and analytics.
• Deep SAP module knowledge across at least three of FI/CO, MM, SD, PP, QM, or WM/EWM — able to navigate table structures, transaction codes, and data relationships without documentation.
• Expert understanding of SAP extraction methods: SLT, ODP, ABAP CDS views, OData services, BAPIs/RFCs, and IDocs; strong SAP BW/4HANA and S/4HANA Universal Journal (ACDOCA) experience.
• Expert-level Snowflake including Snowpark, Streams/Tasks, and Snowflake Cortex AI (LLM functions, Cortex Search, Document AI).
• Hands-on Fivetran experience: SAP connector configuration, sync strategies, schema drift handling, and API automation.
• Deep dbt expertise (3+ years): advanced Jinja, custom macro/package development, Semantic Layer/MetricFlow, and CI/CD integration.
• Expert SQL and Python with production-quality standards; strong Terraform, GitHub Actions, and AWS skills.
• Experience with data observability platforms (Monte Carlo preferred) and regulated environments (GxP, SOX, HIPAA).