Front-Office Risk Data Quality Analyst

BIP US; Chicago (IL); On-site; 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

Title - Data Quality Analyst, Capital Markets

Company Overview

Business Integration Partners (BIP) is Europe’s fastest growing digital consulting company and are on track to reach the Top 20 by 2030, with an expanding global footprint in the US (New York, Charlotte, Chicago, and Houston). Operating at the intersection of business and technology we design, develop, and deliver sustainable solutions at pace and scale creating greater value for our customers, employees, shareholders, and society.

BIP specializes in high-impact consulting services across multiple industries with 6,000 employees worldwide. Our domains include Life Sciences, Energy, Retail, and Financial Service businesses including Capital Markets, Insurance and Payments verticals, supplemented with Data & AI, Cybersecurity, Risk & Compliance, Change Management and Digital Transformation practices. We integrate deep industry expertise with business, technology, and quantitative disciplines to deliver high-impact results for our clients.

Position Summar

yResponsible for the design, implementation, and execution of data quality controls, reconciliation activities, operational reporting, and the investigation of data issues impacting batch runs on the Strategic Full Revaluation Capability (SFRC) platform. This role ensures the completeness, accuracy, and integrity of reporting data across batch runs

.Responsibilitie

• sExecute 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

.Required Qualificatio

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

s.
Desired Qualificati

• onsExperience with Python and the automation of reporting process
• es.Experience with data warehousing and ETL concep
• ts.Familiarity with Splunk and production-support too
• ls.Knowledge of regulatory and risk-reporting process

es
Compensa

tion**Base salary range for this role is $130,000 - $170,0

00**Be

• nefitsChoice of medical, dental, vision insu
• rance.Voluntary ben
• efits.Short- and long-term disab
• ility.HSA and
• FSAs.Matching
• 401k.Discretionary performance
• bonus.Employee referral
• bonus.Employee assistance pr
• ogram.11 public hol
• idays.20 day
• s PTO.7 Sick
• Days.PTO buy and sell pr
• days.Paid parental
• leave.Remote/hybrid work environment su

pport.For more information about BIP US, visit https://www.bip-group.com/e

n-us/.Equal Employment Opport

unity:It is BIP US Consulting policy to provide equal employment opportunities to all individuals based on job-related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship, or marital status, and to maintain a non-discriminatory environment free from intimidation, harassment or bias based upon these gr

grounds.BIP US provides a reasonable range of compensation for our roles. Actual compensation is influenced by a wide array of factors including but not limited to skill set, education, level of experience, and know