Tessera Labs
Senior Data Engineer – ERP Data Harmonization & Enterprise Data Platform
4mo ago
180000 –250000 USD / yearUSASeniorsqlpythonenterprise data modeling
Senior Data Engineer role focusing on designing scalable data solutions for harmonizing enterprise data across multiple ERP systems.
Requirements
- Work closely with ERP functional teams and Functional Data Experts (FDEs) to translate business rules into technical implementations.
- Convert functional requirements into:
- SQL transformation logic
- Python-based processing pipelines
- Validation and reconciliation frameworks
Other
- Location : San Jose, CA or New York City Remote : Considered; travel required
- Tessera 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.
- We 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.
- Enterprise 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 platforms
- Standardize enterprise master and transactional data
- Support ERP modernization and migration initiatives
- Provide the data backbone for enterprise analytics, AI, and automation
- Design 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 LN
- Oracle ERP / Oracle Fusion
- SaaS ERP platforms such as NetSuite
- Legacy ERP and adjacent enterprise systems
- Implement transformation pipelines using SQL and Python.
- Design 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 Partners
- Vendors / Suppliers
- Materials / Products
- Chart of Accounts
- Cost Centers and organizational structures
- Financial and operational transactions
- Develop canonical enterprise data models that normalize ERP data across heterogeneous systems.
- Implement logical and physical models supporting:
- Relational data platforms
- Dimensional analytics models
- Enterprise semantic layers
- Implement data validation, reconciliation, and monitoring frameworks.
- Identify and resolve enterprise data issues such as:
- Duplicate master data
- Inconsistent definitions across ERP systems
- Incomplete or legacy datasets
- Configuration-driven inconsistencies
- 5–8+ years of experience in Data Engineering, Data Integration, or Data Platform development
- Experience working with enterprise ERP systems, such as: Sage ERP platforms
- Baan / Infor LN
- Oracle ERP / Oracle Fusion
- NetSuite or other SaaS ERPs
- Experience supporting ERP transformation, migration, or multi-system integration initiatives
- Advanced SQL
- Strong Python for data engineering workflows and pipeline development
- Experience building ETL/ELT pipelines
- Experience processing large-scale enterprise datasets
- Familiarity with modern data architectures and distributed processing
- Strong understanding of: Relational data models
- Dimensional models
- Canonical enterprise data models
- Understanding of ERP business domains including:
- General Ledger
- Accounts Payable / Receivable
- Financial transactions
- Materials and product data
- Procurement and vendor management
- Inventory and logistics