Senior Analytics Engineer (Financial Services)

RSM US LLP; City of Rochester (NY); On-site; USD 74,000 - 110,000; Full time

Benefits offered by this job

Flexible schedule

Competitive benefits

Job summary

RSM US LLP seeks a Temporary Supervisor - Analytics Engineer to support regulatory reporting and risk data initiatives. The role focuses on building data acquisition, validation, and analytics pipelines in regulated banking environments, working with stakeholders across risk, compliance, audit, and technology.

You’ll design and maintain canonical data models, metadata, and data lineage while enabling Power BI reporting and executive dashboards.

Qualifications

• Advanced SQL skills including complex transformations and performance tuning.
• Experience designing ETL/ELT solutions across multiple source systems.
• Dimensional data modeling and canonical data models exposure.

Responsibilities

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

Skills

SQL

ETL/ELT

Dimensional modeling

Regulatory reporting

Stakeholder mgmt

Tools

Power BI

Azure

Databricks

Snowflake

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

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.

Compensation

We offer a competitive benefits and compensation package for all our people.We offer flexibility in your schedule, empowering you to balance life’s demands, while also maintaining your ability to serve clients.Learn more about our total rewards at https://rsmus.com/careers/working-at-rsm/benefits.

Compensation Range: $54 - $80 per hour

Equal Opportunity, Diversity, and Inclusion

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

Visa & Sponsorship

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.

Additional Considerations

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.

Working at RSM

At RSM, we accomplish meaningful work and make an impact on the world around us. We work hard to fully understand our clients and work even harder to understand and identify your unique skills. We celebrate the differences among us and empower our talented professionals to grow forward, both personally and professionally. Our clients benefit from fresh insights and energy as we collaborate to support them, and our teams enjoy a work environment that inspires and empowers them to thrive.