Senior Data Validation Analyst
-
Accounting
Job Description & How to Apply Below
Avanciers Incorporated is hiring a Senior Data Validation Analyst for one of our clients.
Role:Senior Data Validation Analyst
Location:
Fremont, CA (onsite)
Experience:
4 to 6 years Job Role Summary
Client is moving its finance platform from Net Suite to Oracle. You will lead the design, mapping and validation of the new Chart of Accounts (CoA) and sub-accounts, write the accounting policies that govern it, and take the new structure through audit. You will also guide the Data Validation Analyst day to day.
Key Responsibilities Chart of Accounts design and mapping- Analyze the existing Net Suite CoA, subsidiaries, departments, classes, locations and custom segments.
- Design the Oracle CoA and sub-chart of accounts (segments, value sets, hierarchies, account rollups) with Finance and the implementation partner.
- Build and own the Net Suite-to-Oracle account mapping (one-to-one, one-to-many, many-to-one), with rationale for each change.
- Define naming conventions, numbering logic and governance for adding or retiring accounts.
- Draft the CoA policy and accounting manual explaining each segment, its purpose and usage rules.
- Document legacy linkages: how each Net Suite account, segment and report line maps to the new Oracle structure.
- Prepare crosswalks for financial statements, management reports and tax reporting.
- Plan and lead validation for each migration cycle (mock loads, SIT, UAT, cutover).
- Reconcile trial balances, GL balances, open AR/AP and subledgers between Net Suite and Oracle; investigate and resolve variances.
- Define validation rules, control totals and sign-off checklists; maintain the issue and defect log.
- Prepare the audit pack for the new CoA and migrated balances; act as main contact for internal and external auditors.
- Make sure the new structure supports SOX controls, segregation of duties and US GAAP reporting.
- Respond to audit queries and close findings within agreed timelines.
- Work with Controllership, FP&A, Tax, IT and the system integrator; present progress and risks to the program lead.
- Review the Data Validation Analyst's work and train finance users on the new CoA.
- Bachelor's degree in Accounting, Finance or a related field; CPA, CA, CMA or ACCA preferred.
- 4 to 6 years in accounting, finance systems, ERP implementation or audit, including at least one ERP migration or CoA redesign.
- Hands-on Net Suite experience;
Oracle Fusion Cloud ERP (or Oracle EBS) General Ledger experience strongly preferred. - Strong grasp of US GAAP, GL structure, consolidation and intercompany accounting.
- Advanced Excel (lookups, pivots, Power Query); SQL or a BI tool is a plus.
- Experience supporting audits;
Big 4 audit or advisory background is a plus. - Clear written communication for policy documents and audit responses.
- Multi-entity, multi-currency environments; manufacturing or energy/solar industry exposure.
- Familiarity with data migration tools (FBDI, ADFdi) and SOX documentation.
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
Position Requirements
10+ Years work experience(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction