Data Conversion Specialist

Overview

• Develop and manage the overall data conversion strategy aligned to tax schedule release timelines.
• In conjunction with Functional Owners, Functional SMEs, and Tax Schedule SMEs, validate converted data in the COTS system to ensure completeness, accuracy, and usability.
• Coordinate with System Architects to align conversion activities with the overall technical architecture and data design.
• Work with Database Administrators to stage, load, and monitor data migration activities.
• Track, triage, and resolve data conversion defects and issues across all testing and production environments.
• Support data readiness for training and UAT environments, ensuring that converted data is suitable for scenario execution.
• Contribute to cutover planning and execution of production data conversion during each release go-live.
• Maintain documentation of data mapping, conversion rules, trial results, and final outcomes for audit and knowledge transfer.
• Provide status reporting and updates to program leadership, identifying risks, blockers, and mitigation plans related to data conversion.
• Ensure compliance with agency data standards, security policies, and retention requirements throughout the conversion process.
• Direct teams of business users and technical staff, ensuring alignment with program milestones and deliverables.
• Adjust strategies to accommodate evolving program needs, new data discoveries, and vendor requirements over a multi-year program.
• Lead the review, validation, and cataloging of all operational data sources, including shadow systems and spreadsheets.
• Lead analysis of legacy system data to identify quality issues, inconsistencies, and transformation requirements.
• Lead cross-functional working sessions with SMEs, technical staff, vendors, and stakeholders to define remediation approaches and resolve legacy system data-related issues.
• Prioritize and lead data cleanup efforts of legacy system data.
• Produce and maintain Data Dictionaries, quality review reports, remediation plans, and status reports for the TMO.
• Collaborate with Functional Owners, Functional SMEs, Tax Schedule SMEs, and Vendor staff to define data mapping and transformation rules that reflect business and system requirements.
• Oversee the design and execution of extract-transform-load (ETL) processes in coordination with DBAs and technical teams.
• In conjunction with the Vendor Data Conversional Lead, coordinate and lead trial conversions and mock loads to identify issues and validate conversion logic.
• Work with testing teams to ensure converted data supports test case execution and meets expected outcomes.
• This role is involved in the modernization program on a full-time basis.

• Thorough understanding of the principles and practices of establishing governance models, data ownership frameworks, and alignment with PMO structures.
• Thorough understanding of strategies, methodologies, and tools for large-scale legacy-to-modern system conversions, including mainframe migrations, with the ability to translate program-wide modernization objectives into a data conversion roadmap that supports business continuity.
• Techniques for identifying invalid, inconsistent, orphaned, and incomplete data, along with remediation methods and root cause analysis.
• Expertise in Oracle, SQL Server, and Erwin Data Modeler, including Erwin Data Modeler implementation and use of the tool for generating documentation and conducting data analysis.
• Knowledge of government tax/revenue operations and the specific challenges in modernizing these systems.
• Standards for cataloging enterprise data sources and maintaining metadata at database, table, and field levels.
• Methods for data reconciliation, validation, and iterative conversion testing within staging environments.
• Ability to resolve data ambiguities and conflicts across multiple legacy sources with accuracy and efficiency.
• Ability to motivate and guide diverse teams, balancing business and technical perspectives.
• Ability to anticipate data-related risks and implement proactive controls to ensure high-quality conversions.
• Ability to clearly articulate data strategies, risks, and outcomes to executive…