Principal Platform Data Engineer, SAP

Overview

Alnylam’s 2030 transformation — serving 10x patients with 30x manufacturing capacity — depends on SAP as the backbone for finance, supply chain, manufacturing, and procurement. As Principal Platform Data Engineer, SAP, you will own the end-to-end architecture from SAP S/4HANA and BW/4HANA source systems through Fivetran-based extraction, Snowflake lakehouse storage, dbt transformation, and downstream consumption by analytics, AI/ML, and Snowflake Cortex AI workloads. This is a highly autonomous, technically senior individual contributor role with direct influence on how SAP data powers the entire enterprise. Reports to the Sr. Director/Director of Data, AI & Enterprise Architecture. Hybrid role based in Cambridge, MA with 2 days/week onsite.

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

Required

• 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).

Preferred

• 5+ years in biotech, pharma, healthcare, or life sciences.
• Experience with SAP Datasphere, SAP BTP, and Snowflake Native App capabilities.
• History of building reusable SAP data frameworks and dbt packages adopted across engineering teams.
• Occasional travel required (10–15%) for vendor conferences including Snowflake Summit, SAP TechEd, and Coalesce.

#LI-Hybrid

#LI-LN1 

U.S. Pay Range

$174,800.00 - $236,600.00

The pay range reflects the full-time base salary range we expect to pay for this role at the time of posting. Base pay will be determined based on a number of factors including, but not limited to, relevant experience, skills, and education. This role is eligible for an annual short-term incentive award (e.g., bonus or sales incentive) and an annual long-term incentive award (e.g., equity).

Alnylam’