Principal Platform Data Engineer, SAP

Alnylam Pharmaceuticals

2d • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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.

Benefits

• Alnylam’s robust Total Rewards package is designed to support your overall health and well-being. We offer comprehensive benefits including medical, dental, and vision coverage, life and disability insurance, a lifestyle reimbursement program, flexible spending and health savings accounts and a 401(k)with a generous company match. Eligible employees enjoy paid time off, wellness days, holidays, and two company-wide recharge breaks. We also offer generous family resources and leave. Our commitment to your well-being reflects our belief that caring for our people fuels the impact we create together.
• Learn more about these and additional benefits offered by Alnylam by visiting the Benefits section of the Careers website: https://www.alnylam.com/careers

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed
• Number of Employees: 501-1,000 employees