IT Audit, Data Analyst

City National Bank of Florida

. Query, extract, cleanse, transform, and analyze data from multiple source systems for audit engagements and continuous monitoring .

Posted 9/24/2026full-timeCoral Gables • Florida • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analytics, including data extraction, cleansing, transformation, and visualization, while applying knowledge of internal audit methodologies and risk assessment techniques. Proficient in utilizing analytical tools such as SQL, Power BI, and Tableau to support audit engagements and communicate findings effectively.

Highest-signal resume keywords

Data AnalyticsSQLPower BIInternal Audit MethodologiesRisk Assessment Techniques

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ExtractionData CleansingData TransformationData VisualizationData AnalysisAudit TestingControl TestingRisk ManagementCybersecurity ConceptsInformation Technology Risks

Soft Skills

Attention to DetailOrganizational SkillsCritical ThinkingProblem-Solving SkillsEffective Communication

Tools & Technologies

Power BITableauSQLPythonAlteryxMicrosoft Excel

Industry Keywords

Banking OperationsFinancial ServicesAudit FrameworksComplianceTechnology Controls

Tech Stack

Tools & technologies

Cyber SecurityPythonSQLTableau

About the role

Key responsibilities & impact

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 data analytics tools
Perform data validation and reconciliation to assess data reliability and completeness
Identify trends, exceptions, anomalies, potential control gaps, and process improvement opportunities
Develop automated audit tests and continuous auditing routines
Support emerging technologies, including automation and AI-enabled audit solutions
Assist with General IT, data, and operational audit engagements
Perform risk and control assessments under senior auditor and audit management supervision
Execute audit testing and document results according to Internal Audit methodology and 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 audit workpapers, observations, and supporting documentation
Track remediation efforts and validate management corrective actions
Support annual and dynamic risk assessments, continuous monitoring, and special projects
Maintain professional skepticism, confidentiality, objectivity, and adherence to Internal Audit and regulatory expectations
Develop knowledge of banking operations, regulations, cybersecurity risks, technology controls, and audit frameworks
Communicate audit and analytics results concisely, accurately, and professionally

Requirements

What you’ll need

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

Benefits

Comp & perks

Hybrid workplace policy
Equal opportunity employment
Reasonable accommodations for interviews and applicable law
Best-in-Class Client Experience focus