The Data Conversion Lead is responsible for planning, coordinating, and executing data conversion activities in support of the Tax System Modernization Program.
This is a hybrid position. The candidate will be working up to four days a week in the Raleigh office.The Data Conversion Lead is responsible for planning, coordinating, and executing data conversion activities in support of the Tax System Modernization Program. This role ensures that accurate, complete, and usable data is migrated from legacy systems into the modern COTS platform for each release. The Data Conversion Lead works closely with the Vendor Data Conversion Lead, Functional Owners, Functional SMEs, Tax Schedule SMEs, Database Administrators, System Architects, other Vendor staff, and testing teams to define data mapping rules, oversee extract and transformation processes, and validate the quality and readiness of converted data. This individual plays a critical role in enabling the retirement of legacy systems by ensuring that historical and operational data are properly prepared and transitioned to the modern environment.
ResponsibilitiesDevelop 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.
ParticipationThis role is involved in the modernization program on a full-time basis.
Knowledge, Skills, and Abilities (KSAs)
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 stakeholders, SMEs, and vendors.
Adhere to defined project management processes, including risk and issue management, quality management, benefits realization management, and change control.
Required/Desired Skills| Skill Required /Desired Amount of Experience | |||
| Understanding of principles and practices of establishing governance models, data ownership frameworks, and alignment with PMO structures | Required | 5 | Years |
| Understanding of strategies, methodologies, and tools for large-scale legacy-to-modern system conversions, including mainframe migrations. | Required | 5 | Years |
| Ability to translate program-wide modernization objectives into a data conversion roadmap that supports business continuity | Required | 5 | Years |
| Techniques for identifying invalid, inconsistent, orphaned, and incomplete data, along with remediation methods and root cause analysis. | Required | 5 | Years |
| Expertise in Oracle, SQL Server, and Erwin Data Modeler, including Erwin Data Modeler implementation and use of the tool for generating documentation | Required | 5 | Years |
| Knowledge of government tax/revenue operations and the specific challenges in modernizing these systems. | Required | 3 | Years |
| Standards for cataloging enterprise data sources and maintaining metadata at database, table, and field levels. | Required | 5 | Years |
| Methods for data reconciliation, validation, and iterative conversion testing within staging environments. | Required | 5 | Years |
| Ability to resolve data ambiguities and conflicts across multiple legacy sources with accuracy and efficiency. | Required | 5 | Years |
| No. Question | |
| Question1 | This is a hybrid position working up to four days a week onsite. Do you agree to this requirement? |
| Question2 | Your candidate must be able to attend an in-person interview. Do you agree to this requirement? |
| Question3 | What is your candidate's email address? |
| Question4 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? |
| Question5 | Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. |
| Question6 | Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? |
| Question7 | Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirement? |
| Question8 | Candidates submitted above the rate of - will not be considered. Do you accept this requirement? |
| Question9 | Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement? |
| Question10 | Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm? |
...Job Description Synergy Medical Staffing is seeking a travel nurse RN Skilled Nursing Facility (SNF) Occupational Health for a travel nursing job in Bethel, Alaska. Job Description & Requirements ~ Specialty: Occupational Health ~ Discipline: RN ~ Start Date...
...Job Description As a Compensation Analyst at Ace Hardware, you will play a key role in implementing and administering our compensation philosophy and programs for a diverse workforce, including corporate, distribution, and field-based employees. This position will provide...
...Job Description Job Description Position Title: Personal Care Management Skills Trainer Location: Woods Hole, MA 02543, USA Hyannis, MA 02601, USA Orleans, MA 02653, USA Falmouth, MA 02540, USA Bourne, MA 02532, USA South Yarmouth, MA 02664, USA Requisition...
...NBCUniversal is one of the world's leading media and entertainment companies. We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our global theme park destinations, consumer products...
...Radiation Oncologist - MD "Minne" is an understatement The Community - Minneapolis, MN Meet the biggest underestimated place in the north. A dramatic riverfront skyline, three professional sports stadiums within 1.3 miles, so much art you're literally surrounded by it...