Description
Citizens Bank is seeking an experienced Financial Data Analyst to join our Asset-Backed Finance team in Charlotte.
Citizens Bank is seeking an experienced Financial Data Analyst to join our Asset-Backed Finance team in Charlotte.
Responsibilities:
- Collect data from numerous data sources/files/feeds. Initiate automated data upload process while identifying and troubleshooting any arising data issues/problems.
- Query and analyze collected loan level data for the purpose of evaluating financial performance and identifying historic trends.
- Participate in portfolio strategy meetings and present loan market risks/trend data to portfolio management team.
- Develop and maintain data visualization reports that frame analysis into useful data tables and charts.
- Maintain monthly deal-level portfolio analysis and historical charting reports.
- Provide ad-hoc data analysis and reporting to various banking team members.
- Conduct independent data analysis, create models, and build reports on assigned research projects.
Long Term Objectives:
- Streamline the data gathering and ingestion process for more efficient data processing and timelier data availability.
- Identify and troubleshoot and data source file inconsistencies, omissions, errors and other data problems.
- Develop useful data visualization reports evaluating deal level financial performance and loan market trend analysis.
- Provide expertise and input on developing stable, long-term data solutions for multiple banking teams.
- Collaborate with our internal technology team on providing stable, cloud-based database solutions for various banking teams.
Requirements:
- Strong analytical skills including excellent data analysis/optimization skills, and very proficient in Excel.
- Experience with database design and knowledge of structured query language (SQL)
- Familiarity with capital markets, finance, banking, and/or corporate leveraged loan markets.
- Experience with coding in VBA, ADO, Java, C#, Excel macros. Familiar with the Microsoft/Excel development platform
- Experience creating data visualizations using modern business intelligence (BI) tools (Power BI, Tableau, etc)
- Proficient technical problem solving/critical thinking skills.
- Strong communication skills. Communication with business line (non-technical) and technology team members will be required.
- Bachelors degree
Work Schedule and Hours
Work Schedule: Monday – Friday
Hours: 40
Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.
Equal Employment Opportunity
At Citizens we value diversity, equity and inclusion, and treat everyone with respect and professionalism. Employment decisions are based solely on experience, performance, and ability. Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression (including transgender individuals who are transitioning, have transitioned, or are perceived to be transitioning to the gender with which they identify), genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague’s or a dependent’s reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws.
Equal Employment and Opportunity Employer
Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.
Why Work for Us
At Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth
Background Check
Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.