RBC · 1 month ago
Senior Financial Reporting Analyst in Jersey City, NJ
RBC Capital Markets LLC is seeking a Senior Financial Reporting Analyst to enhance and automate workflows using Alteryx Designer. The role involves developing SQL code for data analysis, collaborating with the Regulatory Reporting team, and optimizing regulatory reporting processes.
BankingFinancial ServicesWealth Management
Responsibilities
Build, optimize and automate complex workflows with Macro and Interface tools in Alteryx Designer that ensure reusability and scalability
Identify opportunities to streamline data processes and operations that would benefit with the usage of Alteryx
Develop SQL code in Teradata/Dremio for data querying and analyzing that requested by Regulatory Reporting team
Develop R Markdown file for data quality checking process and data sourcing
Work closely with Regulatory Reporting team to troubleshoot data issues in FRY9C/FFIEC002 report and define reporting/solution requirements
Raise data issues or enhancement tickets in Jira and collaborate with technical stakeholders to translate requirement into strategic solution
Work on the optimization, generation and pre-submission reviews of weekly and quarterly regulatory reporting schedules
Qualification
Required
Bachelor's degree in information systems, data science or a related field
2 years of experience with Alteryx
Coding experience
Experience with R
Experience with SQL
Experience with JIRA Board Management
Experience with Tableau / Power BI
Alteryx Designer Core Certification
Tableau Analyst Certification
Benefits
A discretionary bonus
401(k) program with company-matching contributions
Health, dental, vision, life and disability insurance
Paid time-off plan
Company
RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance.
H1B Sponsorship
RBC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (29)
2024 (17)
2023 (3)
2022 (4)
2021 (1)
2020 (2)
Funding
Current Stage
Public CompanyTotal Funding
$16.3B2025-10-30Post Ipo Debt· $5B
2025-09-15Post Ipo Debt· $1.35B
2025-07-10Post Ipo Debt· $177.74M
Recent News
2026-01-22
Qatar Tribune
2026-01-21
Company data provided by crunchbase