Senior Analytics Engineer: Regulatory Reporting & Risk Data

RSM US LLP; New York (NY); On-site; USD 74,000 - 110,000; Full time

Job summary

RSM US LLP seeks a hands-on Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk analytics programs. The role emphasizes building data pipelines, immutable data stores, and regulatory-ready data models in a regulated financial services environment.

You will collaborate with business, risk, audit, and technology teams, driving data quality and governance while enabling robust reporting and visualization capabilities using Power BI.

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

Advanced SQL

ETL/ELT

Dimensional data modeling

Data quality controls

Regulatory reporting

Communication

Tools

Azure

Databricks

Snowflake

Synapse

Fabric

Informatica

Talend

Alteryx

Teradata

Collibra

Power BI

Job description

RSM US LLP seeks a hands-on Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and risk analytics programs. The role emphasizes building data pipelines, immutable data stores, and regulatory-ready data models in a regulated financial services environment.

You will collaborate with business, risk, audit, and technology teams, driving data quality and governance while enabling robust reporting and visualization capabilities using Power BI.