Hybrid Data Audit & Controls Lead

RSM US LLP; Chicago (IL); Hybrid; USD 74,000 - 113,000; Full time

Job summary

RSM US LLP is seeking an experienced Data Audit Manager to support a global financial services client in validating remediation efforts, strengthening data governance, and improving control environments. The role focuses on data management, reporting, analytics, and validation activities to ensure regulatory compliance.

The position involves evaluating data processing, data lineage, and access controls, with exposure to Python, SQL, and Alteryx.

Qualifications

• 5+ years of experience in data risk, controls, compliance, validation, audit, consulting, or related functions.
• Experience supporting regulatory remediation, issue validation, consent order activities, or control assessment efforts preferred.
• Strong understanding of data management, data governance, reporting, and analytics processes.
• Working knowledge of technologies such as Python, SQL, Alteryx, and database management systems.
• Experience reviewing and testing controls within complex data and reporting environments.
• Strong written and verbal communication skills, including the ability to prepare clear and professional documentation.
• Ability to analyze technical processes and communicate findings to both technical and non-technical stakeholders.
• Experience within banking or other highly regulated industries preferred.

Responsibilities

• Review and assess data management processes, data processing solutions, and data consumption workflows.
• Evaluate data transformation and processing logic, including code written in languages such as Python.
• Review SQL queries, data models, and transformation processes used to support reporting and analytics outcomes.
• Assess database management systems (DBMS) and related data governance practices.
• Evaluate reporting and analytics platforms (e.g., Alteryx or similar tools) used for data preparation, reporting, and analytical activities.
• Review user access management and other controls designed to protect data assets.
• Assess data lineage and trace data flows across data processing, storage, reporting, and analytics environments.
• Support issue validation, remediation review, and control effectiveness testing activities.
• Document findings, observations, and recommendations in accordance with established project standards and methodologies.

Skills

Data risk

Controls

Compliance

Validation

Audit

Consulting

Tools

Python

SQL

Alteryx

Job description

RSM US LLP is seeking an experienced Data Audit Manager to support a global financial services client in validating remediation efforts, strengthening data governance, and improving control environments. The role focuses on data management, reporting, analytics, and validation activities to ensure regulatory compliance.

The position involves evaluating data processing, data lineage, and access controls, with exposure to Python, SQL, and Alteryx.