Agile Programming Methodologies, Analysis Skills, Business Analysis, Business Solutions, Consulting, Data Analysis, Data Lake, Data Mart, Data Migration, Data Quality, Data Sets, Detail Oriented, Documentation, Microsoft Excel, Problem Solving Skills, Reconciliation, Relational Databases (RDBMS), Requirements Management, SQL (Structured Query Language), Snowflake Schema, Systems Analysis, Technical Analysis, Testing, Validation Documentation, Writing Skills
Business Systems Analyst II (SQL Data Validation)
Remote (CST)
2-3- month contract
Pay Rate: $40.00 - $44.00per hr.
Our client needs a Business Systems Analyst to support a high-priority data migration initiative involving the movement of data from existing data lake and data mart environments into Snowflake. This role is focused almost entirely on data validation, data comparison, and reconciliation activities to ensure the accuracy and integrity of migrated data. The consultant will work as part of an Agile team and be responsible for running SQL queries, comparing source and target datasets, validating migration results, and documenting discrepancies. This is not a traditional Business Analyst role focused on requirements gathering or stakeholder management; it is a hands-on data analysis position 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.
Required Skills:
- 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.