Regulatory Analytics Engineer: Risk Data & Reporting

RSM US LLP; Boston (MA); On-site; USD 74,000 - 110,000; Full time

Job summary

RSM US LLP in the United States is seeking a Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk data projects in financial services. You will design data structures and lead data integration efforts with governance in mind.

The role emphasizes SQL, ETL/ELT, data modeling, and collaboration with risk, compliance, and reporting teams. You'll contribute to Power BI reporting and audit-ready documentation, ensuring accuracy across multiple source systems.

Qualifications

• 6+ years of experience in Analytics Engineering, Data Engineering, Data Warehousing, or a related discipline.
• Advanced SQL skills, including complex transformations, reconciliations, optimization, and performance tuning.
• Experience designing and developing ETL/ELT solutions across multiple source systems.
• Experience with dimensional data modeling, canonical data models, and historical snapshot architectures.
• Experience working within Financial Services, Banking, Risk Management, Regulatory Reporting, Compliance, or Audit environments.
• Strong understanding of data quality controls, reconciliations, and regulatory reporting requirements.

Responsibilities

• Build and maintain data acquisition, ingestion, and staging processes for large-scale regulatory reporting and analytics programs.
• Develop and support an immutable historical data repository that enables accurate recreation of prior reporting periods and regulatory submissions.
• Design and enhance canonical data models, reference data structures, and business classification frameworks.
• Build and maintain exception management repositories to support issue tracking, remediation, and regulatory reporting transparency.
• Implement data quality controls, validation routines, reconciliations, and audit-ready documentation.
• Perform complex data analysis, root cause investigations, and issue remediation across multiple source systems.
• Design and maintain data lineage documentation and control evidence to support audit and regulatory reviews.
• Collaborate with business, risk, compliance, audit, and technology stakeholders throughout the project lifecycle.
• Support system integration testing (SIT), user acceptance testing (UAT), implementation activities, and production support.
• Partner with reporting and visualization teams to develop datasets supporting Power BI and management reporting.

Skills

Advanced SQL

ETL/ELT design

Dimensional data modeling

Regulatory reporting

Data quality controls

Stakeholder communication

Tools

Power BI

Collibra

Azure

Databricks

Snowflake

Job description

RSM US LLP in the United States is seeking a Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk data projects in financial services. You will design data structures and lead data integration efforts with governance in mind.

The role emphasizes SQL, ETL/ELT, data modeling, and collaboration with risk, compliance, and reporting teams. You'll contribute to Power BI reporting and audit-ready documentation, ensuring accuracy across multiple source systems.