ConsultNet Technology Services and Solutions is seeking a Business Systems Analyst II to support a high-priority data migration initiative. The role focuses on data validation, comparison, and reconciliation activities to ensure the accuracy and integrity of migrated data, requiring strong SQL and analytical skills.
Responsibilities:
- Execute SQL queries against source and target databases
- Validate data migration results between legacy data environments and Snowflake
- Perform data comparisons and reconciliation testing to ensure data accuracy and completeness
- Analyze source-to-target data mappings and verify expected outcomes
- Export query results into Excel for further analysis and comparison
- Identify, investigate, and document data discrepancies and quality issues
- Support Agile user stories related to data validation and migration activities
- Collaborate with Product Owners, developers, and project team members to resolve data-related issues
- Document validation findings and provide status updates on assigned work
Requirements:
- Minimum 3 years of hands-on experience in a Data Analyst, Data Validation Analyst, Data Quality Analyst, Technical Analyst, or similar role
- Strong SQL skills with the ability to write and execute complex queries
- Experience performing data validation, data reconciliation, and data comparison activities
- Strong analytical and problem-solving abilities
- Proficiency with Microsoft Excel for data analysis and reporting
- Experience working with large datasets and relational databases
- Strong attention to detail and commitment to data accuracy
- Experience working within Agile teams