Technical Analyst

The Technical Analyst will support the implementation and data migration activities for the COPS 2.0 pension administration system, ensuring a smooth and accurate transition from the legacy platform to the new Oracle 19C-based environment. This role bridges business and technical domains, focusing on requirements analysis, system mapping, validation, and data quality assurance.

The Technical Analyst will collaborate with business users, data engineers, and developers to document technical specifications, support data validation, and ensure system functionality aligns with migration goals and business processes. This position requires strong technical problem-solving, analytical thinking, and documentation skills, along with experience in health or pension-related data systems.

KEY RESPONSIBILITIES
 

1. Technical and Data Analysis

• Analyze legacy and target system data models to identify data dependencies, transformation logic, and integration requirements.
• Collaborate with technical teams to design, test, and validate ETL processes for data migration to the Oracle 19C platform.
• Perform root-cause analysis and troubleshooting of data mismatches, anomalies, or validation errors identified during migration cycles.

2. Requirements Gathering and Documentation

• Work with business and IT stakeholders to capture technical and functional requirements for data migration and validation.
• Develop detailed technical documentation including interface specifications, mapping documents, data flow diagrams, and migration traceability matrices.
• Maintain up-to-date records of migration scripts, validation reports, and test results for audit readiness.

3. Data Quality and Validation

• Execute SQL queries and scripts to validate migrated data for completeness, consistency, and accuracy.
• Support data profiling, reconciliation, and data quality checks to ensure clean and reliable datasets in the COPS 2.0 environment.
• Collaborate with the Data Manager and QA teams to define and apply data validation rules and business logic.

4. Systems Integration and Support

• Assist with integration of the COPS 2.0 platform with upstream and downstream systems, ensuring data integrity and synchronization.
• Participate in technical review sessions and assist developers in clarifying system requirements and resolving issues.
• Support end-to-end system testing, including functional, integration, and user acceptance testing (UAT).

5. Compliance and Confidentiality

• Ensure all activities adhere to data confidentiality and security standards in alignment with Confidentiality/Data Security Agreements and applicable data protection policies.
• Support secure data handling, encryption, and audit practices throughout the migration lifecycle.

REQUIRED SKILLS & QUALIFICATIONS

• Bachelor’s degree in Computer Science, Information Systems, or related field.
• 6 years of experience as a Technical or Systems Analyst supporting enterprise-level software or data migration projects.
• Strong knowledge of SQL, PL/SQL, and relational databases such as Oracle 19C.
• Proven experience with data migration, data mapping, and ETL workflows.
• Ability to interpret business requirements and translate them into technical specifications.
• Experience analyzing, troubleshooting, and optimizing data validation and migration processes.
• Familiarity with data security, compliance, and audit documentation standards.
• Strong analytical, problem-solving, and communication skills.
• Must hold Oracle Data Migration related certification

PREFERRED QUALIFICATIONS

• Experience working with pension administration or financial
• Exposure to COPS, Vitech V3locity, or similar Oracle-based platforms.
• Knowledge of data governance frameworks, metadata management, and data lineage tools.
• Experience with ETL tools (Informatica, SSIS, or Oracle Data Integrator).
• Understanding of Agile or Waterfall methodologies for data projects.

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.