Regulatory Reporting Automation & Data Quality Engineer

RGP; New York (NY); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

401(k) Savings Plan

Employee Stock Purchase Plan

Professional Development

Job summary

RGP is seeking a hands-on data/automation professional for the Finance Regulatory Reporting team in New York. The role focuses on building scalable data pipelines, ensuring data quality, and delivering high-quality regulatory reporting outputs across FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009.

You will work with data and technology teams to translate regulatory requirements into robust data solutions and perform QA/UAT testing to validate outputs.

Qualifications

• Bachelor’s degree or equivalent experience in a finance/data field.
• Strong SQL skills to query and transform large data sets.
• Experience with data analysis, reconciliations, and QA/testing in finance or data-heavy environment.
• Analytical thinker with attention to detail and cross-functional collaboration skills.
• Familiarity with bank regulatory reporting (FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009).
• Knowledge of data lineage, governance, and reporting controls.

Responsibilities

• Design, develop, and enhance automated data pipelines and reporting processes for regulatory reports.
• Perform data analysis, reconciliations, and variance investigations to ensure accuracy.
• Translate regulatory requirements into data/system solutions with SMEs; support QA/UAT testing.
• Support integration and post-conversion data cleanup and remediation activities.
• Collaborate with technology, data, and regulatory teams to resolve data issues.

Skills

Strong SQL querying

Data analysis

Regulatory reporting knowledge

Cross-functional collaboration

Problem solving

Education

Bachelor’s degree in Finance/Accounting/IS/Data Analytics

Tools

Python

Axiom or similar regulatory platform

Data warehousing concepts

Job description

RGP is seeking a hands-on data/automation professional for the Finance Regulatory Reporting team in New York. The role focuses on building scalable data pipelines, ensuring data quality, and delivering high-quality regulatory reporting outputs across FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009.

You will work with data and technology teams to translate regulatory requirements into robust data solutions and perform QA/UAT testing to validate outputs.