Senior Analytics Engineer (Financial Services)

RSM US LLP; Boston (MA); Hybrid; USD 58,000 - 85,000; Part time

Job summary

RSM US LLP is seeking a Temporary Supervisor - Analytics Engineer to support large-scale regulatory reporting and analytics initiatives within financial services. You will build data pipelines, design data models, and enable audit-ready reporting in collaboration with risk, compliance and IT teams.

You will work in a role that blends data engineering, analytics, and governance, with a focus on accurate, timely regulatory submissions and executive reporting using Power BI.

Qualifications

• 6+ years in Analytics Engineering, Data Engineering, or similar.
• Advanced SQL with complex transformations and performance tuning.
• Experience ETL/ELT across multiple source systems.
• Dimensional data modeling and canonical data models experience.
• Experience in Financial Services, Banking, Risk or Regulatory reporting.
• Strong data quality controls, reconciliations, and regulatory reporting knowledge.
• Excellent communication and stakeholder management.

Responsibilities

• Build and maintain data acquisition, ingestion, and staging for regulatory reporting.
• Develop immutable historical data repository for prior periods and regulatory submissions.
• Design canonical data models and reference data structures.
• Maintain data lineage documentation and audit evidence.
• Collaborate with business, risk, compliance, audit and technology stakeholders.
• Support SIT, UAT, deployments, and production support.
• Partner with reporting teams to develop datasets for Power BI.

Skills

Advanced SQL

Data analysis

Stakeholder management

Regulatory reporting

Effective communication

Tools

Power BI

Collibra

Azure

Databricks

Snowflake

Synapse

Informatica

Talend

Alteryx

Teradata

Job description

We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, culture and talent experience and our ability to be compelling to our clients. You'll find an environment that inspires and empowers you to thrive both personally and professionally. There's no one like you and that's why there's nowhere like RSM.

Temporary Supervisor - Analytics Engineer (Regulatory Reporting & Risk Data)

Position Overview

RSM is seeking a Temporary Supervisor - Analytics Engineer to support large-scale Risk Consulting engagements within the Financial Services and Global Banking sectors. This role is ideal for a hands-on data engineering professional with experience building data acquisition, regulatory reporting, and analytics solutions in highly regulated environments.

Working alongside senior analytics and technology leaders, you will help design and build foundational data structures that support regulatory reporting, risk analytics, reconciliation, and executive reporting. The successful candidate will bring strong technical expertise, a passion for solving complex data challenges, and experience working within banking, risk, compliance, or regulatory reporting environments.

What You'll Do

• Build and maintain data acquisition, ingestion, and staging processes for large-scale regulatory reporting and analytics programs.
• Develop and support an immutable historical data repository that enables accurate recreation of 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 to support 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 to support 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.

Required Qualifications

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

Preferred Qualifications

• 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.

Technology Environment

Candidates may come from a variety of technical backgrounds. Experience with modern data and analytics platforms is valued; however, strong fundamentals in SQL, data modeling, reconciliation, and regulated data environments are the most critical qualifications.

At RSM, we offer a competitive benefits and compensation package for all our people. Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

We believe flexibility and in-person connection both play an important role in how we work and grow. Most roles at RSM follow a hybrid workstyle, which means team members are aligned to an RSM office and come together in person when it best supports clients, teams, development or relationship-building. Some roles may be virtual or primarily on-site based on role requirements, team priorities and client needs.

All applicants will receive consideration for employment as RSM does not tolerate discrimination and/or harassment based on race; color; creed; sincerely held religious beliefs, practices or observances; sex (including pregnancy or disabilities related to nursing); gender; sexual orientation; HIV Status; national origin; ancestry; familial or marital status; age; physical or mental disability; citizenship; political affiliation; medical condition (including family and medical leave); domestic violence victim status; past, current or prospective service in the US uniformed service; US Military/Veteran status; pre-disposing genetic characteristics or any other characteristic protected under applicable federal, state or local law.

Accommodation for applicants with disabilities is available upon request in connection with the recruitment process and/or employment/partnership.RSM is committed to providing equal opportunity and reasonable accommodation for people with disabilities. If you require a reasonable accommodation to complete an application, interview, or otherwise participate in the recruiting process, please call us at 800-274-3978 or send us an email at [e-mail].

RSM does not intend to hire entry level candidates who will require sponsorship now OR in the future (i.e. F-1 visa holders). If you are a recent U.S. college / university graduate possessing 1-2 years of progressive and relevant work experience in a same or similar role to the one for which you are applying, excluding internships, you may be eligible for hire as an experienced associate.

RSM will consider for employment qualified applicants with arrest or conviction records. For those living in California or applying to a position in California, please click here for additional information.

At RSM, an employee's pay at any point in their career is intended to reflect their experiences, performance, and skills for their current role. The salary range (or starting rate for interns and associates) for this role represents numerous factors considered in the hiring decisions including, but not limited to, education, skills, work experience, certifications, location, etc. As such, pay for the successful candidate(s) could fall anywhere within the stated range.

Compensation Range: $42 - $62 per hour