Senior Analytics Engineer (Financial Services)
About The Position
RSM is seeking a Temporary Supervisor - Analytics Engineer to support large-scale Risk Consulting engagements in the Financial Services and Global Banking sectors. The role involves building data acquisition, regulatory reporting, and analytics solutions in highly regulated environments. Working with senior analytics and technology leaders, the position helps design and build foundational data structures for regulatory reporting, risk analytics, reconciliation, and executive reporting. Strong technical expertise and experience in banking, risk, compliance, or regulatory reporting environments are important. The posting describes a hybrid workstyle for most roles, with team members aligned to an RSM office and meeting in person when it supports client work, teams, development, or relationship-building; some roles may be virtual or primarily on-site depending on role requirements and client needs.
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 working 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 for recreating 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.
- Design and 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 supporting Power BI and management reporting.
Benefits
- Competitive benefits and compensation package; details are available through RSM’s total rewards information.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
