Senior Data Engineer – ERP Data Harmonization & Enterprise Data Platform

Location: San Jose, CA or New York CityRemote: Considered; travel requiredAbout Tessera LabsTessera Labs is redefining how enterprises adopt and operationalize Artificial Intelligence. Backed by Foundation Capital and led by a world-class founding team, we build multi-agent AI systems that automate complex business workflows across platforms such as SAP, Salesforce, Workday, Snowflake, MuleSoft, and more.Our mission is to bring real AI automation to the enterprise—delivering speed, precision, and measurable impact. We operate with extreme ownership, move quickly, and build at the frontier of applied AI.Role SummaryWe are seeking a Senior Data Engineer to design and build scalable data solutions that harmonize enterprise data across multiple ERP ecosystems. This role focuses on integrating and standardizing data from Sage ERP, Baan / Infor LN, Oracle ERP, SaaS ERP platforms (such as NetSuite), and other enterprise systems into unified data models.The engineer will collaborate closely with ERP functional teams, Functional Data Experts (FDEs), and product engineers to translate complex business logic into robust data transformation pipelines and canonical enterprise data models.This role requires strong experience in SQL, Python, enterprise data modeling, and ERP data structures, combined with the ability to solve complex cross-system data inconsistencies and harmonization challenges.Why This Role MattersEnterprise organizations often operate across multiple ERP systems and business platforms, each with different schemas, definitions, and data semantics. Without proper harmonization, data becomes fragmented and unreliable for operations, analytics, and decision-making.This role is critical in building the data foundation that enables organizations to operate with consistent, trusted enterprise data across systems.The Data Engineer in this role will:Enable cross-system interoperability between ERP platformsStandardize enterprise master and transactional dataSupport ERP modernization and migration initiativesProvide the data backbone for enterprise analytics, AI, and automationKey ResponsibilitiesBuild ERP Data Integration PipelinesDesign and develop scalable ETL/ELT pipelines to ingest and transform data from enterprise systems including:Sage ERP (e.g., Sage X3, Sage Intacct, Sage 300)Baan / Infor LNOracle ERP / Oracle FusionSaaS ERP platforms such as NetSuiteLegacy ERP and adjacent enterprise systemsImplement transformation pipelines using SQL and Python.Implement Data Harmonization LogicDesign and maintain data harmonization frameworks that standardize enterprise datasets across systems.Define and implement cross-system mapping rules for enterprise data domains including:Customers / Business PartnersVendors / SuppliersMaterials / ProductsChart of AccountsCost Centers and organizational structuresFinancial and operational transactionsDesign Enterprise Data ModelsDevelop canonical enterprise data models that normalize ERP data across heterogeneous systems.Implement logical and physical models supporting:Relational data platformsDimensional analytics modelsEnterprise semantic layersTranslate Functional Requirements Into Data LogicWork closely with ERP functional teams and Functional Data Experts (FDEs) to translate business rules into technical implementations.Convert functional requirements into:SQL transformation logicPython-based processing pipelinesValidation and reconciliation frameworksImprove Data Quality and GovernanceImplement data validation, reconciliation, and monitoring frameworks.Identify and resolve enterprise data issues such as:Duplicate master dataInconsistent definitions across ERP systemsIncomplete or legacy datasetsConfiguration-driven inconsistenciesProfessional ExperienceRequired Skills & Experience5–8+ years of experience in Data Engineering, Data Integration, or Data Platform developmentExperience working with enterprise ERP systems, such as:Sage ERP platformsBaan / Infor LNOracle ERP / Oracle FusionNetSuite or other SaaS ERPsExperience supporting ERP transformation, migration, or multi-system integration initiativesTechnical SkillsProgrammingAdvanced SQLStrong Python for data engineering workflows and pipeline developmentData EngineeringExperience building ETL/ELT pipelinesExperience processing large-scale enterprise datasetsFamiliarity with modern data architectures and distributed processingData ModelingStrong understanding of:Relational data modelsDimensional modelsCanonical enterprise data modelsERP Data KnowledgeUnderstanding of ERP business domains including:FinanceGeneral LedgerAccounts Payable / ReceivableFinancial transactionsSupply ChainMaterials and product dataProcurement and vendor managementInventory and logisticsEnterprise Master DataCustomersVendorsProductsOrganizational structuresBehavioral & Problem-Solving ExpectationsSystems ThinkingAbility to understand complex enterprise systems and business processes, and design data solutions that work across multiple platforms.Translating Business Logic into Technical SolutionsCapability to work with functional teams and convert business rules into scalable data transformation logic.Data Problem SolvingStrong analytical skills to diagnose and resolve enterprise data challenges.CollaborationComfortable working with cross-functional teams including engineers, ERP functional consultants, and business stakeholders.Ownership and ExecutionAbility to take ownership of complex data problems and deliver production-grade solutions that scale across enterprise environments.No third party may recruit, solicit candidates, publish job opportunities, use Tessera Labs’ name or branding, or represent that they are acting on behalf of Tessera Labs without prior written authorization. Any such activity conducted without explicit written consent is strictly prohibited.Compensation Range: $180K - $250K