Technology Risk Manager

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. Youll find an environment that inspires and empowers you to thrive both personally and professionally. Theres no one like you and thats why theres nowhere like RSM.

Position Summary

RSM is seeking a Temporary Supervisor with 6 years of experience in analytics and data engineering to support Risk Consulting engagements in the Financial Services and Global Banking sectors. This is a build role. Working under the pods Senior Analytics Engineer this individual constructs the foundation layers of a regulatory reporting analytics platform: cycle-scoped data acquisition an immutable as-filed snapshot vault the canonical data model and the exception and data-gap findings store.

Key Responsibilities

• Build cycle-scoped acquisition and staging routines over client-provided extracts with no transformation in the landing layer.
• Build the as-filed snapshot vault - immutable and append-only keyed on reporting cycle and record identifier - so that a prior cycle can be reproduced exactly as filed.
• Build the canonical data model together with its reference and product-to-classification mapping tables.
• Build the exception and data-gap findings store including disposition state so that each exception carries its rule version its run and the source records behind it.
• Implement the rule-run instrumentation and run logs that make each analytics cycle reproducible.
• Implement data quality controls validation and reconciliation including reconciliation of loaded data back to filed regulatory totals.
• Perform data analysis validation reconciliation and issue remediation across complex data environments.
• Document data lineage and control evidence to the standard required for audit and regulatory review.
• Build supporting datasets for the Power BI reporting layer in partnership with the BI Engineer.
• Support risk compliance regulatory reporting and audit-related data initiatives and participate in SIT UAT documentation implementation and production support activities.

Required Qualifications

• 6 years of hands-on experience in analytics engineering data engineering or data warehouse development. This role builds and maintains data structures; it is not a governance or business analysis role.
• Strong SQL including complex transformation logic performance tuning and reconciliation queries.
• Experience with ETL/ELT tooling and data integration across multiple source systems.
• Experience with dimensional and canonical data modeling including slowly changing and point-in-time or snapshot patterns.
• Experience working within Financial Services Banking Risk Management Compliance or Regulatory Reporting environments.
• Experience implementing data quality controls and reconciliation in a regulated environment.
• Strong communication and stakeholder management skills.

Preferred Qualifications

• Knowledge of BCBS 239 regulatory reporting risk data aggregation or enterprise risk programs.
• Experience building immutable or append-only historical stores and reconstructing prior reporting periods.
• Experience with data lineage and metadata documentation and with tools such as Collibra.
• Working knowledge of Power BI as the consumption layer over a canonical model.
• Experience with Azure Databricks Synapse Fabric or other modern cloud analytics platforms.

Technology Stack

The clients target platform is confirmed during discovery. Experience with any of Azure Databricks Snowflake Synapse Fabric Informatica Talend Alteryx or Teradata is relevant; SQL dimensional and canonical data modeling and Power BI are the constants. Depth in these fundamentals matters more than experience with any specific technology stack.

Engagement Details

• Client: a large US bank. The role is embedded in the clients regulatory compliance function.
• Program: build-out of a regulatory reporting analytics capability - as-filed snapshot layer canonical loan model a rules and analytics engine an exception store and Power BI reporting.
• Location: hybrid Charlotte NC or Atlanta GA. Onshore US only; Eastern time zone hours. No visa sponsorship and no offshore delivery on this engagement.
• Duration: through Q1 2027 with extension into Q2 2027 likely.

Additional Requirements

• Must be able to pass client background screening requirements.
• Must successfully complete all third-party risk onboarding requirements. Client onboarding (background screening third-party risk badging and VDI access) runs three to four weeks and is on the critical path - candidates must be available to begin onboarding immediately upon selection.
• Any prior engagement at a large US bank must be disclosed at submission for conflict and non-compete review.
• Start dates are targets and may move by two to three weeks.

At RSM we offer a competitive benefits and compensation package for all our offer flexibility in your schedule empowering you to balance lifes demands while also maintaining your ability to serve more about our total rewards at 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/ 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 or send us an email at .

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