Negotiable
Undetermined
Remote
Remote or Birmingham, Alabama
Summary: The Business Systems Analyst II role focuses on supporting a critical data migration initiative to Snowflake, requiring strong SQL skills and experience in data validation and quality assurance. The analyst will work closely with project teams to ensure data accuracy and successful migration outcomes. This position is ideal for detail-oriented individuals with a background in data analysis and reconciliation. The role is available remotely or in Birmingham, AL.
Key Responsibilities:
- Perform data validation and reconciliation activities during a data migration to Snowflake
- Compare existing data structures and datasets against newly created Snowflake tables
- Execute SQL queries to analyze, compare, and validate source-to-target data
- Identify, investigate, and document data discrepancies and anomalies
- Validate data quality, completeness, and accuracy throughout the migration process
- Partner with project stakeholders to resolve data issues and ensure successful delivery
- Document findings, validation results, and recommendations
- Participate in Agile team ceremonies and collaborate with cross-functional project teams
Key Skills:
- SQL
- Data Validation
- Data Reconciliation
- Data Analysis
- Data Quality Assurance
- Data Migration
- Agile Methodologies
- Source-to-Target Validation
Salary (Rate): £32.00 hourly
City: Birmingham
Country: United States
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
RESPONSIBILITIES:
Kforce has a client that is seeking a Business Systems Analyst II (SQL & Data Validation) in Birmingham, AL.
Overview:
Our client is seeking a Business/Data Analyst to support a critical data migration initiative as they transition their enterprise data lake environment to Snowflake. This role is ideal for a detail-oriented analyst with strong SQL skills and experience performing data validation, reconciliation, and quality assurance activities during large-scale data transformation projects.
The selected consultant will work closely with the project team to compare source and target data structures, validate data accuracy, and ensure successful migration outcomes.
Responsibilities:
* Perform data validation and reconciliation activities during a data migration to Snowflake
* Compare existing data structures and datasets against newly created Snowflake tables
* Execute SQL queries to analyze, compare, and validate source-to-target data
* Identify, investigate, and document data discrepancies and anomalies
* Validate data quality, completeness, and accuracy throughout the migration process
* Partner with project stakeholders to resolve data issues and ensure successful delivery
* Document findings, validation results, and recommendations
* Participate in Agile team ceremonies and collaborate with cross-functional project teams
REQUIREMENTS:
* 2-3+ years of experience as a Data Analyst, Business Analyst, or similar analytical role
* Strong SQL querying and data analysis skills
* Experience performing data validation, reconciliation, and data quality checks
* Ability to compare large datasets and identify inconsistencies between source and target systems
* Experience working with relational databases and data warehouse environments
* Strong attention to detail and analytical problem-solving skills
* Excellent communication and documentation abilities
* Experience working in Agile environments
Key Skills:
* SQL
* Data Validation
* Data Reconciliation
* Data Analysis
* Data Quality Assurance
* Data Migration
* Agile Methodologies
* Source-to-Target Validation
Preferred Qualifications:
* Experience supporting data migration or data warehouse modernization initiatives
* Exposure to Snowflake or cloud-based data platforms
* Experience working within enterprise data lake environments
* Familiarity with source-to-target mapping and data transformation validation
The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.