Data Migration & Technical Business Analyst

Abacus Service Corporation is seeking a Data Migration & Technical Business Analyst to support the Arizona Department of Revenue in converting its legacy tax accounting system to a new platform. The role involves conducting design sessions, defining data cleansing rules, and collaborating with development teams to ensure a smooth migration process.

Responsibilities:

• Conduct design sessions with business stakeholders and data owners to capture and document requirements related to data migration and system modernization activities
• Perform data profiling and anomaly identification to assess legacy TAS data quality and readiness for migration
• Define data cleansing rules, transformation logic, and mapping requirements for migrating tax data into the STARS platform
• Develop and maintain data conversion mapping documentation and business rule definitions supporting the migration process
• Collaborate with development teams to translate business requirements into technical requirements for database scripts, interfaces, and reporting processes
• Create validation queries and reconciliation metrics to ensure data accuracy, completeness, and integrity throughout migration and testing phases
• Support data extraction and conversion processes by documenting transformation rules and validating migrated data
• Maintain requirement traceability and track project tasks and deliverables using Azure DevOps (ADO) or similar project management tools
• Assist with milestone documentation, reporting, and acceptance validation activities to ensure deliverables meet project requirements
• Support testing cycles by validating migrated data, identifying discrepancies, and assisting with defect analysis and resolution
• Participate in release planning and communication activities supporting implementation of tax types into the new STARS system

Requirements:

• 6+ years Data Analysis and Data Migration Support
• Advanced SQL and Data Profiling
• Data Cleansing and Transformation Logic
• Data Mapping and Conversion Documentation
• Data Reconciliation and Validation Techniques
• Business Requirements Analysis and Documentation
• Azure DevOps (ADO) or Similar Requirement Tracking Tools
• US Citizen & GC
• Financial or Tax Data Systems Experience