Regulatory Analytics Engineer Lead (Temporary)

RSM US LLP; McLean (VA); Hybrid; USD 58,000 - 85,000; Full time

Job summary

RSM US LLP seeks a hands-on Temporary Supervisor - Analytics Engineer to build data pipelines for regulatory reporting and risk analytics within financial services. You will design scalable data models and immutable repositories, ensuring audit-ready processes.

You will collaborate with risk, compliance, and reporting teams to deliver accurate executive dashboards using Power BI, spanning SIT/UAT and production support activities.

Qualifications

• 6+ years of Analytics Engineering, Data Engineering, or related discipline.
• Advanced SQL skills with complex transformations and performance tuning.
• Experience designing and developing ETL/ELT across multiple source systems.
• Experience with dimensional data modeling and historical snapshot architectures.
• Experience in Financial Services, Banking, Regulatory Reporting, or Audit environments.
• Strong data quality controls, reconciliations, and regulatory reporting knowledge.

Responsibilities

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

Skills

Advanced SQL

ETL/ELT design

Data modeling

Regulatory reporting

Data quality and reconciliations

Stakeholder management

Tools

Azure

Databricks

Snowflake

Synapse

Power BI

Collibra

Job description

RSM US LLP seeks a hands-on Temporary Supervisor - Analytics Engineer to build data pipelines for regulatory reporting and risk analytics within financial services. You will design scalable data models and immutable repositories, ensuring audit-ready processes.

You will collaborate with risk, compliance, and reporting teams to deliver accurate executive dashboards using Power BI, spanning SIT/UAT and production support activities.