IT Audit & Data Analyst

City National Bank (CNB); Coral Gables (FL); On-site; USD 70,000 - 110,000; Full time

Job summary

City National Bank of Florida is seeking a data analytics specialist to support the Internal Audit Department with analytics-based testing and risk-based assurance. You will work on data extraction, dashboard development, and continuous monitoring across IT and operational audits.

The role emphasizes data analytics, control testing, and collaboration with business and technology stakeholders to improve processes and strengthen controls.

Qualifications

• 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.
• Knowledge of data analytics concepts and reporting.

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 data reliability and completeness 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.
• Evaluate IT general controls, including access, change management, and data protection.

Skills

SQL

Power BI

Tableau

Python

Alteryx

Education

Bachelor's Degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Cybersecurity, Business Administration

Tools

Excel

Job description

Overview

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.

What You'll Do:

Data Analytics 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.

IT Audit Responsibilities

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

General Responsibilities

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

Qualifications

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

Education

• Bachelor's Degree in Information Systems, Computer Science, Data Analytics, Accounting, Finance, Cybersecurity, Business Administration.
• An equivalent combination of education and/or relevant professional experience may be considered in lieu of a degree.

Special Instructions to Candidates

Equal Opportunity

City National Bank of Florida is an Equal Opportunity Employer. We do not discriminate based on race, color, religion, sex, national origin, age, disability, genetic information, protected veteran status, or any status protected by federal, state, or Florida law. We comply with the ADA and applicable Florida laws.

Interview Guidelines

To ensure a fair and consistent interview process, applicants are not permitted to use AI-enabled devices during interviews, including AI glasses or similar wearable technology that can record, transmit, or generate real-time information.

Applicants who require a reasonable accommodation to participate in the interview process should contact [e-mail] in advance of the interview to submit an accommodation request. City National Bank of Florida will engage in the interactive process and provide reasonable accommodations in accordance with applicable law.