Analytics Engineer - Regulatory Data & Risk Analytics

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

Job summary

RSM US LLP seeks a temporary Analytics Engineer to build data pipelines and analytics for regulatory reporting in financial services. You will design data stores, support audit-ready artifacts, and collaborate with risk, compliance, and technology stakeholders.

The role emphasizes scalable data acquisition, historical data management, and Power BI reporting to support management dashboards and regulatory submissions.

Qualifications

• Minimum 6+ years in Analytics/Data Engineering or related field.
• Strong SQL skills with complex transformations and optimizations.
• Experience ETL/ELT across multiple source systems.
• Knowledge of dimensional and canonical data models.
• Experience in Financial Services, banking or regulatory reporting.

Responsibilities

• Build and maintain data acquisition, ingestion, and staging for regulatory reporting.
• Develop immutable historical data repositories for accurate reporting.
• Design canonical data models and reference data structures.
• Maintain data lineage and audit-ready documentation.
• Collaborate with risk, compliance, audit, and tech stakeholders.
• Support SIT, UAT, implementation, and production support.
• Partner with reporting teams to enable Power BI datasets.

Skills

Advanced SQL

Data modeling

Regulatory reporting knowledge

Stakeholder management

Analytical problem solving

Tools

Power BI

Azure

Databricks

Snowflake

Synapse

Collibra

Job description

RSM US LLP seeks a temporary Analytics Engineer to build data pipelines and analytics for regulatory reporting in financial services. You will design data stores, support audit-ready artifacts, and collaborate with risk, compliance, and technology stakeholders.

The role emphasizes scalable data acquisition, historical data management, and Power BI reporting to support management dashboards and regulatory submissions.