Front-Office Risk Data Quality Analyst

BIP US; New York (NY); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

Remote/hybrid work environment

Discretionary bonus

401k matching

Paid parental leave

Job summary

Business Integration Partners (BIP) is seeking a data quality and risk reporting specialist to design, implement, and run data quality controls across batch processes. You will investigate data issues impacting VaR-related reporting and collaborate with front-office, risk, and technology teams to ensure accuracy and completeness of risk data.

The role emphasizes automated and manual reporting processes, regulatory and audit support, and improving data quality across the reporting stack.

Qualifications

• Strong data analysis and investigative skills.
• Advanced SQL and data reconciliation experience.
• Experience in Market Risk, Global Markets, FRTB, VaR, SVaR, CCR, or P&L reporting environments.
• Excellent written and verbal communication.

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 variances.
• Partner with front-office and risk teams to resolve defects.
• Validate fixes and support UAT and production deployment.

Skills

Advanced SQL

Data quality analysis

Data reconciliation

Strong data analysis

Excel

Communication skills

Education

Bachelor's degree in a quantitative field

Tools

Python

Splunk

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.