Senior Analytics Engineer (Financial Services)

RSM•McLean, VA

1d•Hybrid

About The Position

RSM is seeking a Temporary Supervisor - Analytics Engineer to support large-scale Risk Consulting engagements in Financial Services and Global Banking. This hands-on data engineering role focuses on building data acquisition, regulatory reporting, and analytics solutions in highly regulated environments. Working with senior analytics and technology leaders, the employee will help develop foundational data structures for regulatory reporting, risk analytics, reconciliation, and executive reporting.

Requirements

At least 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 in Financial Services, Banking, Risk Management, Regulatory Reporting, Compliance, or Audit environments.
Strong understanding of data quality controls, reconciliations, and regulatory reporting requirements.
Ability to analyze complex data issues and develop sustainable technical solutions.
Excellent communication and stakeholder management skills.

Nice To Haves

Experience supporting BCBS 239, enterprise risk programs, risk data aggregation, or regulatory reporting initiatives.
Experience building historical, immutable, or append-only data repositories.
Familiarity with data lineage, metadata management, and governance platforms such as Collibra.
Experience supporting Power BI reporting and analytics solutions.
Experience with cloud and modern data platforms including Azure, Databricks, Snowflake, Synapse, Fabric, Informatica, Talend, Alteryx, or Teradata.

Responsibilities

Build and maintain data acquisition, ingestion, and staging processes for regulatory reporting and analytics programs.
Develop and support an immutable historical data repository to recreate 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 for 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.
Maintain data lineage documentation and control evidence for 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 for Power BI and management reporting.