Kloudhire
Login

Technical Analyst

new york, NY (Hybrid)

Job Description:

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 RESPONSIBILITIESTechnical and Data AnalysisAnalyze 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 DocumentationWork 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 ValidationExecute 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 SupportAssist 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 ConfidentialityEnsure 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 & QUALIFICATIONSBachelor’s degree6+ yearsStrong 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.

    Key Skills:

    • 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

    Share Profile

    Job Information

    • Date Posted
      11-05-2025
    • Location
      new york, NY (Hybrid)
    • Job Type
      Contract

    Job Skills

    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