Data Engineer

Job Description

Net Suite Customer Success is seeking a highly skilled Data Engineer specializing in ERP data migration, with proven experience designing and executing secure, accurate, and efficient migrations from legacy systems such as Quick Books and Sage to Net Suite. Adept in SQL, ETL development, and data quality management, this professional ensures seamless transitions through strong technical execution and adherence to data governance and compliance standards.

This role requires deep expertise in data extraction, transformation, and loading processes, with a strong focus on data strategy development and data hygiene optimization. Known for collaboration and client-focused delivery, they work closely with stakeholders to resolve migration challenges, optimize data integrity, and support post-migration success. Combining technical precision and customer engagement, they help organizations modernize and maximize the value of their ERP platforms.

ERP Data Migration Expertise: Lead end-to-end data migration efforts, including hands-on data extraction, transformation, mapping, and validation between legacy and Net Suite systems.

Technical Proficiency: Apply deep technical knowledge of data structures, ETL processes, and data quality principles to maintain accuracy and integrity throughout migration. Strong capability in building and executing complex data transformations and data manipulation workflows.

Data Strategy & Hygiene Expertise:
Provide strategic guidance on data quality, data governance, and migration planning. Conduct data assessments, identify data cleansing requirements, and develop comprehensive data migration strategies.

Cross-Functional Collaboration: Partner with consultants, analysts, and business stakeholders to clarify requirements, resolve migration challenges, and deliver seamless integrations.

Client-Focused Delivery: Support customers throughout the entire migration lifecycle—communicating complex processes clearly, providing user training, and ensuring a positive post-migration experience.

Data Integrity & Security: Ensure all migration activities adhere to enterprise data governance, security, and compliance standards.

This position is ideal for a data-driven professional who thrives at the intersection of technical precision and customer success, helping organizations modernize and optimize their business operations through successful ERP data migrations.

• Analyze and Design: Analyze source systems (Quick Books, Sage, and other legacy ERP platforms) and target Net Suite 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 Net Suite 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…