IT Audit & Data Analyst

City National Bank of Florida•Coral Gables, FL

About The Position

This role supports the Internal Audit Department by combining data analytics, technology risk assessment, and audit execution activities. The incumbent assists in planning, executing, and reporting operational, General technology, and data-focused audits while using data analytics to identify trends, risks, control issues, and process improvement opportunities. The role works closely with audit teams to develop analytics-based testing, assess control effectiveness, and support risk-based assurance activities throughout the Bank.

Requirements

0 - 3 years experience in data analytics, information technology, internal audit, risk management, accounting, or a related field.
Experience with SQL, Power BI, Tableau, Python, Alteryx, or similar analytical tools.
Experience in banking, financial services, technology Infrastructure, Cyber Security, compliance, or audit environments.
Knowledge of data analytics concepts, including data extraction, cleansing, transformation, analysis, visualization, and reporting.
Basic understanding of information technology risks, cybersecurity concepts, and internal control frameworks.
Familiarity with audit methodologies, risk assessment techniques, and control testing procedures.
Ability to analyze complex data sets, identify exceptions and trends, and communicate results effectively.
Working knowledge of Microsoft Excel and familiarity with SQL, Power BI, Tableau, Alteryx, Python, or similar analytics tools.
Strong attention to detail, organizational skills, and commitment to complete and accurate documentation.
Ability to manage multiple assignments, follow established procedures, and meet deadlines in a fast-paced environment.
Strong written and verbal communication skills and the ability to work effectively with business and technology stakeholders.
Critical thinking, professional skepticism, analytical, research, and problem-solving skills.
Ability to work independently under appropriate supervision and collaboratively within an audit team.

Responsibilities

Query, extract, cleanse, transform, and analyze data from multiple source systems to support audit engagements and continuous monitoring activities.
Develop and maintain dashboards, reports, and visualizations using approved data analytics tools.
Perform data validation and reconciliation procedures to assess the reliability and completeness of data used during audits.
Identify trends, exceptions, anomalies, and potential control gaps through analytical techniques.
Assist in developing automated audit tests and continuous auditing routines.
Support the implementation of emerging technologies, including automation and AI-enabled audit solutions.
Assist in the execution of General IT, data, and operational audit engagements.
Perform risk and control assessments under the supervision of senior auditors and audit management.
Execute audit testing procedures and document results in accordance with Internal Audit methodology and applicable professional standards.
Evaluate information technology general controls, including logical access, change management, computer operations, data protection, and related technology processes.
Participate in walkthroughs, interviews, and control testing with business and technology stakeholders.
Prepare clear, complete, and well-supported audit workpapers, observations, and supporting documentation.
Assist in tracking remediation efforts and validating management corrective actions.
Support annual and dynamic risk assessment activities, continuous monitoring, and special projects as assigned.
Maintain professional skepticism, confidentiality, objectivity, and adherence to Internal Audit and regulatory expectations.
Develop knowledge of banking operations, applicable regulations, cybersecurity risks, technology controls, and audit frameworks.
Communicate audit and analytics results in a concise, accurate, and professional manner.
Demonstrate a sense of urgency and collaborate effectively to provide a Best-in-Class Client Experience.