Financial Analyst Junior

careers-citynational; Coral Gables (FL); On-site; USD 55,000 - 75,000; Full time

Job summary

City National Bank of Florida is seeking a Junior Financial Analyst to support routine financial reporting and analyses. You will collect, review, and organize data, identify trends, and assist in developing internal reports and dashboards to present financial information clearly.

You will apply problem-solving skills to large data sets, learn BI tools (Tagetik, OneSumX, Prologue, Qlik), and collaborate across departments while ensuring accuracy under supervision.

Qualifications

• 2 years experience in financial analysis, accounting, or related work is helpful; internship may be considered.
• Experience applying problem-solving skills through statistical analysis or working with large data sets is highly preferable.
• Ability to learn and use BI tools to collect, evaluate, and analyze management information.
• Familiarity with Wolters Kluwer ERP systems such as CCH Tagetik.
• Experience using Python, SQL, or comparable tools to support data querying, validation, and financial analysis preferred.
• Strong analytical skills with the ability to apply independent judgment and discretion when reviewing financial data.
• Advanced proficiency in Microsoft Excel (Pivot Tables, VLOOKUP, IFs, SUMIFs); Word and PowerPoint proficiency.
• Familiarity with learning Wolters Kluwer ERP systems like CCH Tagetik and OneSumX.
• Experience working with large datasets and applying problem-solving techniques through data analysis.
• Basic to intermediate experience with SQL or similar tools for data querying and validation.
• Knowledge of profitability, pricing, and risk concepts.
• Effective communication skills for cross-department collaboration.
• Strong attention to detail, organizational skills, and ability to manage multiple tasks under deadlines.

Responsibilities

• Performs data mining and querying to support turning raw data into meaningful information for reporting purposes.
• Assists in preparing financial analyses to improve information available to management.
• Maintains and updates data analysis tools, reports, and templates under supervision.
• Helps develop internal reports and dashboards to present financial data clearly.
• Compiles pricing and volume data for analysis.
• Supports evaluations of products and business lines by gathering and organizing financial data.
• Tracks the impact of previously recommended actions and provides follow-up data.
• Learns and applies department tools like Tagetik, OneSumX, Prologue, and Qlik; assists in setup and use.
• Participates in documentation and update of departmental policies and procedures.
• Monitors variances in financial reports and follows up to identify discrepancies.
• Performs other related duties and special assignments as requested.

Skills

Data analysis

Python

SQL

Excel (Advanced)

BI tools

Problem solving

Communication

Attention to detail

Cross-functional collaboration

Education

Bachelor's Degree in Finance/Accounting/Economics

Tools

Tagetik

OneSumX

Prologue

Qlik

Job description

Overview

The Financial Analyst Junior is responsible for preparing routine financial reports and supporting analyses to assist management in understanding the bank's financial position. This role focuses on collecting, reviewing, and organizing financial data, as well as assisting in identifying trends and variances. Working under general supervision, the Analyst helps ensure timely and accurate reporting to support informed decision-making.

What You\'ll Do:

• Performs data mining and querying to support turning raw data into meaningful information for reporting purposes.
• Assists in preparing financial analyses that help improve information available to management.
• Maintains and updates existing data analysis tools, reports, and templates under supervision.
• Helps develop internal reports and dashboards to present financial data in a clear and consumable format.
• Compiles pricing and volume data (e.g., interest rates, indexes, product averages, and outliers) for analysis.
• Supports evaluations of products and business lines by gathering and organizing financial data related to profitability and concentration.
• Tracks the impact of previously recommended actions and provides follow-up data for evaluation purposes.
• Learns and applies department tools such as Tagetik, OneSumX, Prologue, and Qlik; assists in their setup and use.
• Participates in the documentation and update of departmental policies and procedures.
• Monitors variances in financial reports and follows up to identify discrepancies or missing data.
• Performs other related duties and special assignments as requested by management to support department goals and initiatives.

Qualifications

• 2 years expwerience in financial analysis, accounting, or related work is helpful; prior internship experience may be considered.
• Experience applying problem-solving skills through statistical analysis or working with large data sets is highly preferable.

• Ability to learn and use Business Intelligence (BI) tools and technologies to collect, evaluate, and analyze management information.

• Familiarity with or willingness to learn Wolters Kluwer ERP systems, such as CCH Tagetik.
• Experience using Python, SQL, or comparable tools to support data querying, validation, and financial analysis preferred.

• Strong analytical skills with the ability to apply independent judgment and discretion when reviewing financial data.

• Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP, IFs, and SUMIFs; proficiency in Microsoft Word and PowerPoint.

• Familiarity with or willingness to learn Wolters Kluwer ERP systems, such as CCH Tagetik and OneSumX.

• Experience working with large datasets and applying problem-solving techniques through data analysis.

• Basic to intermediate experience with SQL or similar tools for data querying and validation.

• Knowledge of financial concepts related to profitability, pricing, and risk.

• Effective communication skills with the ability to collaborate across departments.

• Strong attention to detail, organizational skills, and ability to manage multiple tasks under deadlines.

Education

• Bachelor\'s Degree in Finance/Accounting/Economics or 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 interview process, the use of AI wearables, AT tools, AI applications, or other external assistance is strickly prohibited.

Accommodations

If you require a reasonable accommodation to apply or participate in the hiring process, please contact our Talent Attraction team at [e-mail]