Regulatory Reporting

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

This position sits within the Finance Regulatory Reporting organization and plays a key role in advancing regulatory reporting automation and data quality initiatives. While there will be some continued focus on post-conversion cleanup activities related to prior acquisitions, the primary emphasis of the role is on enhancing data processes, improving reporting efficiency, and supporting strategic regulatory reporting objectives.The role requires a hands-on, technically strong individual who can work across data, systems, and regulatory requirements to deliver scalable automation and high-quality reporting outcomes.

What you will work on

• Regulatory Reporting Automation & Data Management (Primary Focus)


• Design, develop, and enhance automated data pipelines and reporting processes supporting key regulatory reports (e.g., FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009).


• Perform data analysis, reconciliations, and variance investigations to ensure accuracy, completeness, and consistency of regulatory reporting data.


• Translate regulatory reporting requirements into data and system solutions in partnership with subject matter experts.


• Support development and enhancement of reporting logic within Axiom or similar regulatory reporting platforms.


• Identify and implement process improvements to strengthen data quality, controls, and reporting efficiency.


• Contribute to documentation of data lineage, business rules, and control frameworks to support audit and regulatory expectations.


• Post-Conversion / Integration Support (Secondary Focus)


• Support targeted data cleanup and remediation activities following prior acquisition integrations.


• Validate and reconcile legacy and integrated data to ensure alignment with regulatory reporting requirements.


• Partner with technology and data teams to resolve outstanding integration-related issues impacting reporting.


• General Support & Collaboration


• Collaborate cross-functionally with technology, data, and regulatory reporting teams to support system enhancements and issue resolution.


• Execute and document testing (QA/UAT) to validate changes impacting regulatory reporting outputs.


• Support broader regulatory reporting initiatives, including remediation efforts, control enhancements, and strategic projects.

What you will bring

• Bachelor’s degree in Finance, Accounting, Information Systems, Data Analytics, or related field (or equivalent experience).


• Strong SQL skills with the ability to query, transform, and analyze large datasets.


• Experience in data analysis, reconciliations, and QA/testing in a financial or data-intensive environment.


• Strong analytical and problem-solving skills with attention to detail.


• Ability to work effectively across business, data, and technology teams.


• Experience with bank regulatory reporting (e.g., FFIEC 031, FR Y-9C, FR Y-15, TIC, FR 009 or similar).


• Familiarity with Axiom or other regulatory reporting platforms.


• Working knowledge of Python for data automation, analysis, or testing.


• Experience with data warehousing concepts, data lineage, and source-to-target mapping.


• Understanding of regulatory reporting controls, governance, and data quality frameworks.


• Experience supporting data cleanup, remediation, or post-integration activities

What you can expect

• An inspirational place for you to do your best work, be engaged in meaningful ways, and continually develop the skills, competencies and qualities that set our team apart.

• Compensation commensurate with your qualifications, experience, and other factors, including geographic location, market and operational factors.

• Total Rewards based on eligibility include: Medical, Dental, Vision, Life Insurance, Disability Insurance, 401(k) Savings Plan, Employee Stock Purchase Plan, Professional Development Program, Paid Time Off, Paid Holidays and Paid Sick Time (in geographies where legally required).

What we do

At RGP, we're creating a future where businesses produce their best work without constraints. We've built a global network of over 2,600 experts across four regions, providing a comprehensive suite of solutions across on-demand talent, next-generation consulting, and outsourced services to support organizations at every stage of their growth journey. Trusted by Fortune 100 companies and emerging disruptors alike, we challenge conventional ways of working, drive growth, and pave the way for long-term success through bold innovation and fearless collaboration.

Our values guide everything we do and strengthen our commitment to people. By combining smart processes, human-centered design, and advanced technology, we celebrate our team's excellence and ensure we grow together. We believe in the power of continuous learning and development to drive both individual and organizational success. It’s time to rethink how work gets done. Dare to Work Differently with RGP.

RGP is proud to be an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We do not discriminate on the basis of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information, veteran status, or any other legally protected trait and encourage all applicants to apply.