Data Conversion Lead

Title: Data Conversion Lead

Location: Louisville, KY (Remote)

Type: Contract

Job Description: Data Conversion Lead

• Strong leadership, project management, and technical skills, blending expertise in ETL processes, SQL, , and with crucial soft skills like communication, problem-solving, and team motivation, to guide teams in migrating complex data accurately and efficiently, overseeing risk mitigation and stakeholder communication throughout projects

Role Overview:

• Data Conversion Lead for the Data Conversion task. This role will focus on data conversion and testing activities for migrating Employer and Producer user accounts from Secured Logons (SL) to ForgeRock and PlainID across 24 applications. The resource will ensure data integrity, manage test data, and coordinate with business and technical teams to enable a smooth migration.

Key Responsibilities:

• Define and execute the data strategy for SL data conversion and migration.
• Manage and centralize user testing data for Non-PROD and PROD PPV environments by partnering with business SMEs, test leads, and development teams. This ensures all testing data is consolidated, provides a single point of contact for inquiries, and improves confidence in test execution.
• Analyze, clean, and convert user data for migration into ForgeRock and related systems. Perform detailed data analysis and conversion activities for Employer and Producer user accounts (including primary, secondary, and delegate accounts) to assign correct attributes required for ForgeRock migration to ensure data integrity and meets business requirements for secure logon sunset
• Identify and consolidate duplicate user accounts by mining existing SL data to achieve a single identity per user type, in alignment with XIAM standards that involves deep analysis of login patterns and account relationships.
• Extract and filter SL data for business outreach and account consolidation.
• Coordinate updates to Salesforce and other downstream systems.
• Maintain ownership and tracking of all data used for testing and production.
• Collaborate with business SMEs, test leads, and development teams to ensure alignment.
• Provide clear documentation and status reporting on data activities.

Required Skills & Qualifications:

• Strong experience in data analysis, data migration, and ETL processes.
• Proficiency in SQL and data manipulation tools.
• Ability to interpret complex data sets and identify patterns or anomalies.
• Familiarity with identity management systems and secure authentication concepts.
• Ability to work across multiple teams and manage competing priorities.
• Detail-oriented with a focus on data accuracy and integrity.

• Experience with ForgeRock, PlainID, or similar IAM platforms.
• Knowledge of Salesforce data structures and integration.
• Background in large-scale application migration projects.

Activities:

• Change Management & Sign-Off process
• Implement a formal change control workflow:
• Initiation: Any ForgeRock/XIAM change request logged in a central system (e.g., ADO, ServiceNow).
• Impact Analysis: Identify affected apps (eBilling, eCerts, Group apps, etc.).
• Stakeholder Review: Each app owner signs off after testing in a shared UAT environment.
• Approval Gate: No production deployment without cross-team sign-off.
• Centralized Testing & Configuration
• Create a shared integration test environment and manage test data for all downstream apps and all environments
• Automate regression testing for ForgeRock payload changes.
• Perform data mining, clean up and attribute mapping to ForgeRock
• Drive account consolidation and support outreach planning enterprise-wide
• Communication Framework
• Define standardized requirement templates for ForgeRock/XIAM changes.
• Use weekly/monthly syncs + real-time dashboards for visibility.
• Publish impact matrices showing which user types and apps are affected.
• Compliance & SLA Alignment
• Document legal ramifications per app and ensure SLA adherence.
• Maintain audit trails for all sign-offs and configuration changes.