Senior Data Quality Analyst — Capital Markets

BIP US; Chicago (IL); Hybrid; USD 130,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401k with company matching

Discretionary performance bonus

20 days PTO + holidays

Remote/hybrid work environment

Job summary

BIP US in Chicago is seeking a Data Quality Analyst for Capital Markets to design and execute data quality controls, reconciliation, and reporting for the SFRC platform, ensuring data completeness and accuracy across batch runs.

The role collaborates with Business, Technology, Data Engineering, and Production Support, requires 7+ years, advanced SQL, Excel, and experience in market risk domains; hybrid work environment with comprehensive benefits.

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 in Market Risk, Global Markets, FRTB, VaR, SVaR, CCR, or P&L reporting.
• Strong Excel skills including pivot tables and lookups.
• 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

Data quality analysis

SQL

Data reconciliation

Excel

Communication

Pivot tables

Data interpretation

Reporting

Python

Tools

Python

Splunk

ETL concepts

Data warehousing

Job description

BIP US in Chicago is seeking a Data Quality Analyst for Capital Markets to design and execute data quality controls, reconciliation, and reporting for the SFRC platform, ensuring data completeness and accuracy across batch runs.

The role collaborates with Business, Technology, Data Engineering, and Production Support, requires 7+ years, advanced SQL, Excel, and experience in market risk domains; hybrid work environment with comprehensive benefits.