Summary
RGP provides on-demand talent, consulting, and outsourced services to organizations across multiple regions. This role supports the Finance Regulatory Reporting organization by automating regulatory reporting processes, improving data quality, conducting reconciliations and testing, and supporting data remediation and integration activities.
Responsibilities
- 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
- 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
- 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
Skills
- 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
Qualifications
Must Haves
- 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
Benefits
- Fully Remote
- Medical
- Dental
- Vision
- Life Insurance
- Disability Insurance
- 401(k) Savings Plan
- Employee Stock Purchase Plan
- Professional Development Program
- Paid Time Off
- Paid Holidays
- Paid Sick Time (in geographies where legally required)