Technical Analyst

New York City, NY - USA

Monthly Salary: Not Disclosed

Posted on: 9 days ago

Vacancies: 1 Vacancy

Job Summary

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

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

Bachelors 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 Rozenbergat 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.

Required Experience:

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.