Senior Associate - Data Analyst - Internal Audit (7-15 yrs)

Key Responsibilities and Duties:

- Understands industry-specific data analytics, business intelligence and quantitative analysis techniques and uses this information to ensure the organization's internal controls are effective.

- Defines and implements data analytic standards to ensure Internal Audit's data analytics program is effective and efficient in identifying internal control deficiencies.

- Emphasis on analytics delivery and quality, responsible for partnering across IAS andcompany to brainstorm, define, design and implement analytics and supporting procedures across projects and critical business areas.

- Reviews and develops detailed data analytics routines, scripts, queries, and procedures that identify potential internal control issues and recommends solutions.

- Manages complex audit engagements and teams in special projects or implementation of initiatives.

- Collaborates with Internal Audit's Data Analytics Champions and IT personnel to identify source systems and relevant databases across the organization and utilize applicable tools (e.g., SSIS, APIs, etc.) to qualify, extract, standardize/normalize, optimize and import data from source to target data mart.

- Employs multiple analysis and automation tools (e.g. Python, Snowflake, SQL, SSIS, Tableau, Power BI, RPA tools such as Selenium, Power Automate , DataStage, and APIs) and audit methods, techniques and approaches for obtaining optimal results.

- Experience in data acquisition (i.e. ETL, ELT), data management (cataloging, ensure quality, profiling), data analysis, Business Intelligence and advanced analytics (AI/ML/RPA)

- Leverages data architecture knowledge from user perspective to design data models to support longitudinal, cross-sectional, and self-service analytics for auditors

- Documents production data assets to create and maintain a data catalog, data dictionaries, data profiles and data quality reports.

- Supports Internal Audit's data governance and administration processes and procedures. This includes, but not limited to, ensuring the data security and operations are as per the DA SOPs, periodic review and fine-tuning the databases for optimization, etc.

- Participates in data analysis projects and continuous improvement programs, as necessary, to support relevant Internal Audit projects.

- Liaises with senior management when communicating data analytic results and associated control recommendations.

- Advises senior personnel within Internal Audit and across the company resolve issues, gain needed information and influence outcomes.

Required Experience:

- 7+ years of experience in data acquisition, data architecture, data management, data governance, data analytics & reporting & administration in a regulated financial services environment

- Preferred Experience: Hands on experience in data management, governance, data acquisition and modeling, data structures and architecture

Skills and Abilities:

- Data Integration and Management Tools - SQL Server Integration Services (SSIS), DataStage, APIs, Python, SQL Server Database Management / SQL Agent Job Scheduling, Snowflake

- Basic Data Analysis and SQL Query Writing Skills

- Data Visualization Concepts and Tools - Tableau, Microsoft Power BI