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. The incumbent assists in planning, executing, and reporting operational, General Technology, and data-focused audits, using 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. Responsibilities include querying, extracting, cleansing, transforming, and analyzing data from multiple source systems; developing dashboards, reports, and visualizations; validating and reconciling audit data; identifying trends, exceptions, anomalies, and potential control gaps; and supporting automated audit tests, continuous auditing, and emerging automation and AI-enabled audit solutions. The role also assists with General IT, data, and operational audits; performs risk and control assessments and audit testing under supervision; evaluates IT general controls; participates in stakeholder walkthroughs and interviews; documents audit workpapers and observations; tracks remediation; and supports risk assessments, continuous monitoring, and special projects. The analyst is expected to maintain professional skepticism, confidentiality, and objectivity; build knowledge of banking operations, regulations, cybersecurity risks, technology controls, and audit frameworks; communicate results professionally; and collaborate effectively to provide a Best-in-Class Client Experience. A bachelor's degree in a relevant field is required, though an equivalent combination of education and/or relevant professional experience may be considered in lieu of a degree.

Requirements

0–3 years of 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, cybersecurity, 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 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.
Bachelor's degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Cybersecurity, or Business Administration; an equivalent combination of education and/or relevant professional experience may be considered in lieu of a degree.

Responsibilities

Query, extract, cleanse, transform, and analyze data from multiple source systems for audit engagements and continuous monitoring.
Develop and maintain dashboards, reports, and visualizations using approved analytics tools.
Perform data validation and reconciliation to assess the reliability and completeness of audit data.
Identify trends, exceptions, anomalies, and potential control gaps through analytical techniques.
Assist in developing automated audit tests and continuous auditing routines.
Support implementation of emerging technologies, including automation and AI-enabled audit solutions.
Assist in executing General IT, data, and operational audit engagements.
Perform risk and control assessments under the supervision of senior auditors and audit management.
Execute audit testing and document results in accordance with Internal Audit methodology and applicable professional standards.
Evaluate IT 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 assessments, 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 concisely, accurately, and professionally.
Collaborate effectively to provide a Best-in-Class Client Experience.