Data Validation Analyst

Avanciers Incorporated is hiring a Data Validation Analyst for one of our clients.

Role: Data Validation Analyst

Location: Fremont, CA (onsite)

Experience: 2 to 3 years

Job ID: AV30053

Role summary

You will support Client move from NetSuite to Oracle by building account mappings, validating migrated data and preparing the documentation needed for audit. This is a hands-on role working closely with the Senior Data Validation Analyst and the finance team.

Key responsibilities

Chart of Accounts support

• Extract and catalogue the current NetSuite CoA, segments and account attributes.
• Populate and maintain the NetSuite-to-Oracle mapping workbook; flag gaps, duplicates and unmapped accounts.
• Set up and check sub-account and segment values in Oracle test environments.

Data validation

• Run validation checks for each mock load, test cycle and cutover: record counts, control totals, balance tie-outs.
• Reconcile trial balances and subledger balances (AR, AP, fixed assets) between NetSuite and Oracle.
• Log variances, trace root causes and track fixes through to closure.

Documentation and audit support

• Draft sections of the CoA policy, including account descriptions and legacy-to-new linkage tables.
• Prepare audit schedules, evidence files and reconciliation support.
• Maintain version control and an audit trail for all mapping and validation files.

Reporting

• Prepare status reports on validation progress, open issues and sign-offs.
• Help test financial reports in Oracle against NetSuite outputs.

Qualifications

• Bachelor's degree in Accounting, Finance or a related field; CPA/CA progress is a plus.
• 2 to 3 years in general accounting, reconciliations, audit or finance systems support.
• Working knowledge of NetSuite or Oracle ERP; exposure to an ERP migration preferred.
• Solid understanding of GL, trial balance and month-end close.
• Strong Excel skills (VLOOKUP/XLOOKUP, pivots, data cleansing); SQL is a plus.
• High attention to detail and comfort working with large data sets.
• Clear written and verbal communication.

Our Commitment to Diversity and Inclusion

Avanciers Incorporated is an equal opportunity employer committed to creating an inclusive and accessible workplace. We welcome applications from all qualified individuals regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, or any other protected characteristic. We are committed to providing accessible employment practices that comply with the Accessibility for Ontarians with Disabilities Act (AODA).

Important Information for Applicants

• Only candidates selected for an interview will be contacted
• Proof of qualifications may be requested
• Background checks may be conducted as part of the hiring process

Avanciers Incorporated thanks all applicants for their interest; however, only those selected for an interview will be contacted.