Data Engineer

NetSuite Customer Success is seeking a highly skilled Data Engineer specializing in ERP data migration. The role involves designing and executing secure, accurate, and efficient migrations from legacy systems to NetSuite while ensuring data integrity and compliance.

Responsibilities:

• Analyze and Design: Analyze source systems (QuickBooks, Sage, and other legacy ERP platforms) and target NetSuite data models to design comprehensive, end-to-end data migration strategies, ensuring accurate field mapping and seamless integration
• Data Extraction & Transformation: Execute complex data extraction from source systems and perform sophisticated data transformations to align with NetSuite data models. Develop custom scripts and processes to handle diverse data formats and structures
• Develop and Maintain ETL Processes: Build, test, and maintain robust ETL (Extract, Transform, Load) pipelines to support large-scale data sets, ensuring performance, scalability, and reliability
• Data Cleansing, Transformation & Validation: Assess, Measure, and execute data cleansing, transformation, and validation activities to ensure data quality and integrity. Identify and remediate data quality issues including duplicates, inconsistencies, and structural problems. Data Mapping & Transformation: Collaborate with clients and business analysts to develop detailed data mappings from legacy systems, providing expert guidance on data structure and optimization. Design and implement transformation logic to meet business requirements
• Monitor & Troubleshoot Migration Issues: Perform data reconciliation, proactively identify migration issues, and resolve discrepancies through root-cause analysis and effective collaboration with technical teams
• Documentation & Compliance: Document all migration processes, mappings, and scripts while ensuring strict adherence to data security and privacy standards
• Cutover & Post-Migration Activities: Support cutover planning, data validation, and user acceptance testing (UAT) to ensure a successful transition and accurate migrated data
• Data Hygiene Assessment: Conduct comprehensive data quality assessments of client source systems, identifying data cleansing requirements, duplicate records, incomplete data, and structural issues that could impact migration success
• Migration Strategy Development: Develop tailored data migration strategies and roadmaps, including phased migration approaches, risk mitigation plans, and data archival recommendations
• Data Governance Consulting: Advise clients on data governance best practices, master data management strategies, and ongoing data maintenance protocols to ensure long-term ERP success
• Data Profiling & Analysis: Perform detailed data profiling on source systems to understand data patterns, volumes, relationships, and quality metrics. Use findings to inform migration approach and transformation requirements
• Pre-Migration Planning: Work with clients during the discovery phase to scope migration complexity, assess data readiness, and establish clear success criteria and acceptance standards
• Client Onboarding & Support: Guide clients through the data migration journey, setting expectations, explaining processes, and addressing questions or concerns
• Project Management: Coordinate with stakeholders to ensure projects stay within scope, budget, and timelines, delivering high-quality outcomes
• User Training & Enablement: Train clients on NetSuite data management best practices to build confidence and autonomy post-migration
• Post-Migration Support: Provide ongoing post-migration assistance, troubleshoot issues, and help clients fully leverage their NetSuite environment
• Cross-Functional Collaboration: Partner with business analysts, functional consultants, technical teams, and application owners to align on requirements and ensure smooth migration execution
• Effective Communication: Act as a liaison between technical and non-technical stakeholders, translating complex data migration concepts into clear, actionable information
• Customer Education: Develop and deliver documentation, FAQs, and presentations to help customers understand NetSuite data models and migration best practices
• Collaborative Problem Solving: Engage with internal teams to create innovative solutions for complex migration and data integrity challenges
• Process Improvement: Identify areas for efficiency gains within migration methodologies and contribute to continuous process optimization
• Knowledge Sharing: Maintain detailed documentation of migration frameworks, tools, and lessons learned to enhance future projects and team knowledge
• Customer Feedback Loop: Gather feedback from clients post-migration to refine processes and improve service delivery

Requirements:

• 3 to 5+ years of experience in data engineering and ERP data migration
• Proven hands-on experience (5+ years) executing complex data migrations for ERP systems (e.g., NetSuite, Oracle, SAP, Sage, QuickBooks), including data extraction, transformation, and loading (ETL)
• Strong technical execution capabilities in building and running data migration processes
• Deep understanding of NetSuite data structures, SuiteAnalytics, SuiteCloud, and third-party migration tools
• Advanced SQL, analytics, and data transformation skills, including experience with PL/SQL and scripting languages such as Python for data manipulation and automation
• Ability to write complex transformation logic, data cleansing scripts, and validation queries
• Practical experience with industry-standard ETL tools (e.g., Oracle Data Integrator, Informatica, Talend, Celigo, Dell Boomi) and strong understanding of data pipelines and workflow design
• Solid knowledge of data governance principles, data quality assurance, master data management, and best practices in enterprise data management
• Ability to assess data quality and develop remediation strategies
• Familiarity with key data security and compliance standards (e.g., GDPR, SOX, CCPA) and proven ability to apply them during migration and integration activities
• Skilled in interpreting, mapping, and reconciling data between source and target systems to ensure accuracy and consistency
• Strong ability to design complex field-level mappings and transformation specifications
• Expert in data profiling techniques, data pattern recognition, and statistical analysis of data quality
• Ability to extract insights from source data to inform migration strategy