Technology Risk Manager

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 pod’s 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., * 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., The client’s 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 client’s 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.

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

At RSM, 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.

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.