Front-Office Risk Data Quality Analyst

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

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Voluntary benefits

Short- and long-term disability

HSA and FSAs

Matching 401k

Discretionary performance bonus

Employee referral bonus

Employee assistance program

11 public holidays

20 days PTO

7 Sick Days

PTO buy and sell program

Paid parental leave

Remote/hybrid work environment support

Job summary

Business Integration Partners (BIP) US is hiring a data quality and risk reporting specialist in the Chicago area. You will design, implement, and run data quality checks, perform reconciliations across systems, and generate operational and management reports for batch runs on a Strategic Full Revaluation VaR platform.

You will partner with front-office, risk, data engineering, and production teams to resolve defects, validate fixes, and support UAT and production deployments.

Qualifications

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

Responsibilities

• Execute data quality validation checks for daily batch-processing cycles.
• Run risk reporting scripts and generate operational, control, and management reports.
• Perform reconciliations between upstream, downstream, and reporting systems.
• Investigate front-office valuation data quality exceptions, reconciliation breaks, and unexplained variances.
• Analyse trends and identify recurring data issues requiring remediation.
• Partner with front-office and risk 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 analysis

Investigative skills

Communication skills

Excel proficient

Tools

SQL

Python

Job description

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.

With a strong presence across Healthcare, Life Sciences, Pharmaceutical, and MedTech industries, we partner with some of the world’s most innovative organizations to solve mission-critical operational challenges through intelligent automation, AI-powered decision support, and scalable enterprise solutions.

Position Summary

Responsible for the design, implementation, and execution of data quality controls, reconciliation activities, operational reporting, and the investigation of data issues impacting batch runs on a Strategic Full Revaluation VaR platform. This role ensures the completeness, accuracy, and integrity of reporting risk data across batch runs.

Responsibilities

• Execute data quality validation checks for daily batch-processing cycles.
• Run risk reporting scripts and generate operational, control, and management reports.
• Perform reconciliations between upstream, downstream, and reporting systems.
• Investigate front-office valuation data quality exceptions, reconciliation breaks, and unexplained variances.
• Analyse trends and identify recurring data issues requiring remediation.
• Partner with front-office and risk 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 Qualifications

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

Desired Qualifications

• Experience with Python and the automation of reporting processes.
• Experience with data warehousing and ETL concepts.
• Familiarity with Splunk and production-support tools.
• Knowledge of regulatory and risk-reporting processes.
• Choice of medical, dental, vision insurance.
• Voluntary benefits.
• Short- and long-term disability.
• HSA and FSAs.
• Matching 401k.
• Discretionary performance bonus.
• Employee referral bonus.
• Employee assistance program.
• 11 public holidays.
• 20 days PTO.
• 7 Sick Days.
• PTO buy and sell program.
• Paid parental leave.
• Remote/hybrid work environment support.

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

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 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 knowledge.