Senior Analytics Engineer, Regulatory Risk & Reporting

rsm; New York (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

RSM in New York seeks a Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk data projects. You will design data models, implement ETL/ELT pipelines, and help build immutable data repositories for audit-ready submissions.

The role involves collaborating with risk, compliance, audit, and technology teams, delivering Power BI datasets, and ensuring data quality and lineage 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.
• Proven ability to analyze complex data issues and develop sustainable technical solutions.
• Excellent communication and stakeholder management skills.

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

SQL

Data Modeling

ETL/ELT

Data Quality

Regulatory Reporting

Stakeholder Management

Tools

Power BI

Azure

Databricks

Snowflake

Job description

RSM in New York seeks a Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk data projects. You will design data models, implement ETL/ELT pipelines, and help build immutable data repositories for audit-ready submissions.

The role involves collaborating with risk, compliance, audit, and technology teams, delivering Power BI datasets, and ensuring data quality and lineage across multiple source systems.