The Business Data Lead / Data Manager will serve as the primary point of accountability for data migration, quality assurance, and governance throughout the transition from the legacy pension administration system to the new COPS 2.0 platform, an on-premises solution built on Oracle 19C.
This individual will lead cross-functional efforts to ensure seamless, accurate, and secure data transfer while maintaining compliance with data integrity, confidentiality, and security requirements. The role combines technical acumen in data management with business domain expertise in pension or financial data systems, ensuring that all migration, validation, and reporting activities align with project goals, organizational policies, and regulatory standards.
KEY RESPONSIBILITIES
1. Data Migration Leadership
Lead and coordinate end-to-end data migration activities from legacy systems to the COPS 2.0 Oracle 19C platform.
Develop and execute detailed migration plans, mapping rules, validation scripts, and reconciliation reports to ensure accuracy and completeness.
Collaborate with database engineers and ETL developers to design and validate data extraction, transformation, and loading (ETL) processes.
2. Data Quality and Integrity Oversight
Establish and enforce data quality standards, governance frameworks, and validation checkpoints.
Identify and cleanse inaccurate, duplicate, or incomplete records to ensure consistency across data sources.
Develop automated scripts and reports to monitor ongoing data accuracy and reliability post-migration.
3. Business Data Analysis & Documentation
Act as the liaison between technical teams and business stakeholders to define data requirements, business rules, and mapping logic.
Produce comprehensive documentation including data dictionaries, lineage diagrams, validation reports, and migration status dashboards.
Support user acceptance testing (UAT) by validating migrated data against business processes and expected outcomes.
4. Security, Compliance, and Confidentiality
Ensure adherence to all data security, privacy, and confidentiality standards during migration and storage.
Implement and monitor compliance with the Confidentiality/Data Security Agreement and applicable regulations.
Oversee user access controls, encryption practices, and audit logs to safeguard sensitive pension and personal information.
5. Team Coordination and Knowledge Transfer
Provide training, mentoring, and guidance to data management staff to ensure consistent standards and best practices.
Develop knowledge transfer plans and maintain project continuity documentation to facilitate onboarding of new team members.
Collaborate with the PMO and leadership team to track progress, resolve issues, and ensure timely completion of all milestones.
REQUIRED SKILLS & QUALIFICATIONS
Bachelor’s degree in Information Systems, Computer Science, or related field (Master’s preferred).
8+ years of experience in data management, data migration, or data governance roles supporting enterprise systems.
Proven experience with Oracle 19C, SQL, PL/SQL, and data migration from legacy platforms.
Strong understanding of data architecture, data modeling, and ETL design principles.
Experience with data validation, reconciliation, and reporting tools.
Familiarity with data governance frameworks, metadata management, and data quality monitoring tools.
Experience in financial or pension data systems and compliance with data security/confidentiality agreements.
Must have Project Management (PMP) Certification
Excellent analytical, documentation, and stakeholder communication skills.
PREFERRED QUALIFICATIONS
Experience with COPS, Vitech V3locity, or similar pension administration systems.
Knowledge of data warehouse architecture and reporting environments.
Background in data migration automation, scripting (Python, Shell), or ETL platforms (Informatica, SSIS, or Oracle Data Integrator).
Experience leading data management teams in large-scale government or enterprise transformation projects.
Certification in Data Management (DAMA), Oracle Database Administration
If you are interested in getting more information about this opportunity, please contact Irina Rozenberg Recruiting@arielpartners.com at your earliest convenience. At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.