Regulatory Analytics Engineer Lead – Risk Data (Temp)

RSM US LLP; City of Rochester (NY); On-site; USD 74,000 - 110,000; Full time

Benefits offered by this job

Flexible schedule

Competitive benefits

Job summary

RSM US LLP seeks a Temporary Supervisor - Analytics Engineer to support regulatory reporting and risk data initiatives. The role focuses on building data acquisition, validation, and analytics pipelines in regulated banking environments, working with stakeholders across risk, compliance, audit, and technology.

You’ll design and maintain canonical data models, metadata, and data lineage while enabling Power BI reporting and executive dashboards.

Qualifications

• Advanced SQL skills including complex transformations and performance tuning.
• Experience designing ETL/ELT solutions across multiple source systems.
• Dimensional data modeling and canonical data models exposure.

Responsibilities

• Build and maintain data acquisition, ingestion, and staging processes for regulatory reporting and analytics programs.
• Develop immutable historical data repositories for recreating prior reporting periods.
• Design canonical data models, reference data structures, and classification schemas.
• Maintain exception management repositories for issue tracking and regulatory transparency.
• Implement data quality controls, validation routines, reconciliations, and audit-ready docs.
• Perform complex data analysis, root cause investigations, and remediation across source systems.
• Create data lineage documentation to support audits and regulatory reviews.
• Collaborate with business, risk, compliance, audit, and technology stakeholders.
• Support SIT/UAT, implementation activities, and production support.
• Partner with reporting/visualization teams to develop datasets for Power BI and management reports.

Skills

SQL

ETL/ELT

Dimensional modeling

Regulatory reporting

Stakeholder mgmt

Tools

Power BI

Azure

Databricks

Snowflake

Job description

RSM US LLP seeks a Temporary Supervisor - Analytics Engineer to support regulatory reporting and risk data initiatives. The role focuses on building data acquisition, validation, and analytics pipelines in regulated banking environments, working with stakeholders across risk, compliance, audit, and technology.

You’ll design and maintain canonical data models, metadata, and data lineage while enabling Power BI reporting and executive dashboards.