Senior Data Engineer – ERP Data Harmonization & Enterprise Data Platform
New
San Jose, CA or New York City Remote: Considered; travel requiredFull-TimeSenior
Salary180,000 - 250,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 5–8+ years of experience in Data Engineering, Data Integration, or Data Platform development
- Required Skills
- PythonSQLOracle ERPData engineeringData modelingFinanceNetSuite
Requirements
- 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 Finance (General Ledger, Accounts Payable / Receivable, Financial transactions), Supply Chain (Materials and product data, Procurement and vendor management, Inventory and logistics), and Enterprise Master Data (Customers, Vendors, Products, Organizational structures)
- Ability to understand complex enterprise systems and business processes, and design data solutions that work across multiple platforms
- Capability to work with functional teams and convert business rules into scalable data transformation logic
- Strong analytical skills to diagnose and resolve enterprise data challenges
- Comfortable working with cross-functional teams including engineers, ERP functional consultants, and business stakeholders
- Ability to take ownership of complex data problems and deliver production-grade solutions that scale across enterprise environments
Responsibilities
- Design and develop scalable ETL/ELT pipelines to ingest and transform data from enterprise systems including Sage ERP, Baan / Infor LN, Oracle ERP / Oracle Fusion, NetSuite, and Legacy ERP.
- Implement transformation pipelines using SQL and Python.
- Design and maintain data harmonization frameworks that standardize enterprise datasets across systems, defining and implementing cross-system mapping rules.
- Develop canonical enterprise data models that normalize ERP data across heterogeneous systems, implementing logical and physical models.
- Work closely with ERP functional teams and Functional Data Experts (FDEs) to translate business rules into technical implementations.
- 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, and configuration-driven inconsistencies.
View Full Description & ApplyYou'll be redirected to the employer's site