Data Analyst

Data AnalystAmpcus is seeking a Data Conversion & Reconciliation Lead to oversee data validation, financial reconciliation, and conversion testing for ERP implementations (CGI Advantage or similar).This role is responsible for ensuring that data migration from legacy systems to the new ERP is accurate, complete, and financially sound, with a strong focus on balances, tie-outs, and audit readiness.Key Responsibilities1. Data Conversion Strategy Validation Review and validate: data conversion approach, mapping logic from legacy to target systemEnsure: completeness, accuracy, and referential integrity of dataIdentify: data gaps, inconsistencies, and risks2. Conversion Testing & Execution Support Lead validation across: mock conversions (Mock 1, Mock 2, Dress Rehearsal)Coordinate with: functional leads, data teams, UAT teamEnsure readiness for each conversion cycle3. Financial Reconciliation & Tie-Outs (Critical Responsibility) Perform and oversee: trial balance validation, sub-ledger to GL reconciliation, fund-level and cross-fund balancingValidate: beginning balances, roll-forward data, transaction continuityDefine and enforce: reconciliation rules and tolerance thresholds4. Data Validation & Analysis Validate migrated data using: system reports, data extracts, query tools (SQL or equivalent where available)Perform: record count validation, data sampling and comparison, exception analysisInvestigate and categorize: data issues (mapping, data quality, configuration, integration)5. Reconciliation Reporting & Documentation Develop and maintain: reconciliation workbooks, exception logs, conversion validation reportsTrack: issues, defects, and retesting resultsProvide: clear documentation for audit and sign-off6. Defect Management & Resolution Support Log and track: data-related defects and discrepanciesSupport: root cause analysis, retesting after fixesCoordinate with: implementation team and functional leads7. Go-Live Readiness Support Provide: data readiness assessment, financial validation statusSupport: go/no-go decision with reconciliation resultsEnsure: no material financial discrepancies remainRequired Qualifications10–15+ years in data validation, testing, or financial systemsStrong experience with: data conversion and migration validation, financial reconciliation (trial balance, sub-ledgers)Deep understanding of: accounting principles and financial data structuresExperience with: ERP systems (CGI Advantage preferred, Oracle, SAP, PeopleSoft)Strong analytical skills with ability to: validate data using reports, extracts, and query tools (SQL where applicable)Preferred QualificationsPublic sector / fund accounting experienceExperience with: large-scale ERP transformations, multi-phase data conversion effortsFamiliarity with: data profiling and mapping techniquesWork ModelOnsite-heavy during conversion cycles and UAT execution