Jobs and Careers
AR
Technical Data Analyst
Ariel PartnersNew York City, United Statesfull_timeVerifiedPosted 3 Nov 2025
About the role
The Technical Data Analyst will play a key role in supporting the data migration, validation, and reconciliation processes associated with the transition from the legacy pension administration system to the COPS 2.0 platform, an on-premises system built on Oracle 19C.
This position is responsible for conducting data profiling, transformation analysis, and quality assurance to ensure that data migrated into COPS 2.0 is accurate, complete, and aligned with business and regulatory requirements. The Technical Data Analyst will work closely with data engineers, business analysts, and the Data Manager to identify data anomalies, define validation rules, and document findings that ensure a smooth and compliant migration process.
KEY RESPONSIBILITIES
1. Data Analysis and Validation
REQUIRED SKILLS & QUALIFICATIONS
This position is responsible for conducting data profiling, transformation analysis, and quality assurance to ensure that data migrated into COPS 2.0 is accurate, complete, and aligned with business and regulatory requirements. The Technical Data Analyst will work closely with data engineers, business analysts, and the Data Manager to identify data anomalies, define validation rules, and document findings that ensure a smooth and compliant migration process.
KEY RESPONSIBILITIES
1. Data Analysis and Validation
- Analyze source and target data structures to validate accuracy, completeness, and consistency of migrated data.
- Perform data mapping, profiling, and transformation analysis to ensure alignment with Oracle 19C schema design and business rules.
- Create and execute validation scripts and SQL queries to identify discrepancies, duplicates, or missing records during migration cycles.
- Develop and maintain data quality metrics and validation reports to ensure data integrity throughout all migration phases.
- Support reconciliation activities by comparing legacy and COPS 2.0 data sets to verify migration accuracy and completeness.
- Collaborate with the Business Data Lead and development teams to address data quality issues and implement corrective actions.
- Create and maintain detailed documentation including data mapping specifications, data dictionaries, and test validation reports.
- Produce dashboards and audit-ready reports summarizing data validation outcomes, error trends, and data readiness status.
- Maintain an organized repository of all analysis artifacts, scripts, and test results for transparency and traceability.
- Work closely with database administrators, ETL developers, and system integrators to validate data transformation logic and loading processes.
- Participate in business and technical review sessions to provide insights on data anomalies, dependencies, and improvement opportunities.
- Support knowledge transfer and cross-training efforts by preparing process documentation and mentoring junior analysts when necessary.
- Adhere to data privacy and security protocols, ensuring compliance with HIPAA, Confidentiality/Data Security Agreements, and agency data standards.
- Ensure all data handling, validation, and reporting activities meet audit and compliance requirements.
REQUIRED SKILLS & QUALIFICATIONS
- Bachelor’s degree in Computer Science, Data Analytics, Information Systems, or related field.
- 5+ years of experience in data analysis, data validation, or ETL testing for enterprise data systems.
- Strong proficiency in SQL, PL/SQL, and query optimization for data validation and reconciliation.
- Hands-on experience with Oracle 19C, data migration, and data warehouse environments.
- Familiarity with ETL processes, data profiling tools, and reporting environments.
- Strong analytical and problem-solving skills with attention to detail.
- Demonstrated experience preparing data quality dashboards, validation reports, and test scripts.
- Ability to collaborate effectively in cross-functional teams and communicate complex findings clearly to non-technical stakeholders.
- Must hold Oracle Data Migration related certification
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s