View all jobs
Technical Data Analyst
NYC, NY · Information TechnologyThe 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
PREFERRED QUALIFICATIONS
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.
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
PREFERRED QUALIFICATIONS
- Experience of working on pension administration or financial.
- Exposure to data governance frameworks and data quality monitoring tools.
- Familiarity with Python, R, or scripting for data validation automation.
- Experience with Informatica, SSIS, or Oracle Data Integrator (ODI).
- Understanding of data lineage, metadata management, and data compliance standards.
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.