Remote Data Quality Analyst, Capital Markets

BIP US; New York (NY); On-site; USD 130,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401k with company match

Discretionary performance bonus

PTO and holidays

Job summary

BIP US, a leading digital consulting firm, is seeking a Data Quality Analyst for Capital Markets in New York. You will design, implement, and run data quality controls and reconciliation across the SFRC platform to ensure accurate reporting.

You will collaborate with Business, Technology, Data Engineering, and Production Support to resolve defects, validate fixes, and support regulatory reporting. The role requires 7+ years in data quality analysis, advanced SQL, and strong communication.

Qualifications

• 7+ years’ experience as a Data Quality Analyst with strong data analysis and investigative skills.
• Strong written and verbal communication skills.
• Advanced SQL skills.
• Experience performing data reconciliation and data quality analysis.
• Experience within Market Risk, Global Markets, FRTB, VaR, SVaR, CCR, or P&L reporting environments.
• Strong Excel skills, including pivot tables, lookups, and complex data analysis.
• Ability to interpret large datasets and identify anomalies.
• Experience producing operational or management reports.

Responsibilities

• Execute data quality validation checks for daily batch-processing cycles.
• Run reporting scripts and generate operational, control, and management reports.
• Perform reconciliations between upstream, downstream, and reporting systems.
• Investigate data quality exceptions, reconciliation breaks, and unexplained variances.
• Analyze trends and identify recurring data issues requiring remediation.
• Partner with Business, Technology, Data Engineering, and Production Support teams to resolve defects.
• Validate fixes and support UAT and production implementation activities.
• Build and maintain manual and automated data quality reporting processes.
• Document findings, root causes, and remediation recommendations.
• Support regulatory, risk, and audit-related reporting requirements.

Skills

SQL

Data analysis

Communication

Excel

Data quality

Reporting

Problem solving

Tools

Python

Splunk

ETL concepts

Data warehousing

Job description

BIP US, a leading digital consulting firm, is seeking a Data Quality Analyst for Capital Markets in New York. You will design, implement, and run data quality controls and reconciliation across the SFRC platform to ensure accurate reporting.

You will collaborate with Business, Technology, Data Engineering, and Production Support to resolve defects, validate fixes, and support regulatory reporting. The role requires 7+ years in data quality analysis, advanced SQL, and strong communication.