Database / Data Analyst - Data Conversion & Validation (ERP Financial Systems)

Assess data quality, completeness, and structure

Identify anomalies, duplicates, and inconsistencies

Data discovery and profiling activities

Data quality assessments across modules (GL, AP, AR, Projects, etc.)

1. Data Validation & Conversion Testing | Validate converted data using: * System reports * Data extracts * SQL queries * Record count validation * Control total validation * Data comparison between legacy and target systems * Pre-load, load, and post-load phases

2. Financial Data Validation & Reconciliation | Support reconciliation of: * General Ledger balances * Sub-ledger data (AP, AR, Assets, Projects) * Beginning balances and roll-forwards * Transaction-level data where applicable * Trial balance validation * Fund-level and cross-fund reconciliation

3. Conversion Data Support | Support validation of: * Master data (vendors, customers, projects, grants) * Open transactions (AP, AR, POs, contracts) * Data mapping and transformation outputs * Crosswalk logic and data normalization * Mock conversion cycles and dress rehearsal validation

4. Data Querying & Analysis

   Develop and execute:

SQL queries (where available) for:

• Record counts
• Control totals
• Data integrity checks
• Data discrepancies and exceptions
• Support troubleshooting and root cause analysis

1. Reporting & Documentation * Validation reports * Exception logs * Data comparison summaries * Findings and discrepancies * Validation results for audit purposes

Do you have experience in SQL?, * 4-8+ years in data analysis, QA, or data validation

• Data validation and reconciliation
• Data comparison across systems
• Strong analytical skills with ability to:
• Interpret and validate financial data
• Experience with:
• SQL (data validation, querying, analysis)

Familiarity with:

• ERP systems (CGI Advantage, Oracle, SAP, PeopleSoft)
• Preferred Qualifications
• Data conversion / migration projects
• Understanding of:
• Financial processes (GL, AP, AR, budgeting)
• Public sector or fund accounting
• Data profiling and ETL validation