Data Analyst II - BIS
City National Bank
•
Remote
Company
City National Bank
Location
Remote
Type
Full Time
Job Description
DATA ANALYST II - BIS
WHAT IS THE OPPORTUNITY?
Data governance at City National Bank ("CNB") is a critical factor in the support of compliance with regulations required by the Office of the Comptroller of the Currency ("OCC") and the Federal Reserve Board ("FRB"). This position is responsible for providing support to the division by providing data reporting needs. Produce intelligence through querying data repositories, generating periodic reports, and identifying data patterns and trends through quantitative and qualitative analysis. This position will participate in the data collection and analysis required for the design and development of predictive models, related business processes, reporting structures and interfaces in Banking & Investment Services.
Banking and Investment Services Division
Banking and Investment Services plays an integral role in leading the strategic vision and execution of all banking operations. Our servicing and operations professionals partner closely with all of our lines of business to carry out critical functions, including client/deposit servicing, contact center operations, payments processing, and trade and lending operations, while identifying and mitigating risk throughout the organization. Servicing and operations professionals seek to transform and define an integrated support model through automation and cutting-edge digital technologies, to deliver an excellent experience for our clients and businesses.
Banking and Investment Services plays an integral role in leading the strategic vision and execution of all banking operations. Our servicing and operations professionals partner closely with all of our lines of business to carry out critical functions, including client/deposit servicing, contact center operations, payments processing, and trade and lending operations, while identifying and mitigating risk throughout the organization. Servicing and operations professionals seek to transform and define an integrated support model through automation and cutting-edge digital technologies, to deliver an excellent experience for our clients and businesses.
WHAT WILL YOU DO?
- Work with Business Users to define and document explicit data requirements for any routine and/or non-routine data collection and analysis activities
- Author queries on various source systems, data marts and data warehouse
- Identify trends and anomalies in the data in support of the requirements for various strategic and/or tactical projects
- Serve as Subject Matter Expert on Operational Data Stores, Data Warehouse, and Data Marts
- Identify data quality issues and concerns and support data governance initiatives
- Conduct on-going analysis of the business, operating practices, and data flows within and between various systems and applications
- Foster and maintain good working relationships with colleagues to meet expected customer service levels
- Develop and maintain positive, productive, and professional relationships with key business partners to meet expected customer service levels
- Comply fully with all Bank Operational policies and procedures as well as all regulatory requirements (e.g. Bank Secrecy Act, Know Your Client, Community Reinvestment Act, Fair Lending Practices, etc.)
WHAT DO YOU NEED TO SUCCEED
Must-Have*
- Bachelor's Degree
- Minimum 4 years of experience working in a data analysis role
- Minimum 3 years of experience with SAS or SQL, or other data management, reporting and query tools (Sharepoint, SAP, Business Objects, Tableau, Crystal reports/Dashboard, etc)
- Minimum 3 years of experience in banking/operations
Skills and Knowledge
- Bachelor's degree in Computer Science, Business Analytics or related discipline highly preferred
- Experience with writing database queries (i.e. SQL, MySQL, PL/SQL, T-SQL)
- Experience in using ETL tools, Business Objects or other related BI tools
- Experience with programming languages (i.e. VBA, C++, C#, Javascript) a plus
- Experience designing and generating scheduled and ad hoc reports using reporting/query tools (i.e. Brio, Toad, SQL Developer, MS Access, Crystal Reports, Business Objects, etc.)
- Must be detail-oriented and possess effective organizational and analytical skills
- Must have excellent verbal and written communications skills and ability to communicate clearly and professionally with all levels of the organization
- Ability to express complex technical concepts in business terms
Compensation
Starting base salary: $41.83 - $66.81 per hour. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
*To be considered for this position you must meet at least these basic qualifications
The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Benefits and Perks
At City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues. Get an inside look at our Benefits and Perks.
INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT
City National Bank is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by law.
City National Bank is an equal opportunity employer committed to diversity and inclusion. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by law.
ABOUT CITY NATIONAL
We start with a basic premise: Business is personal. Since day one we've always gone further than the competition to help our clients, colleagues and community flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues to drive phenomenal growth today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies.
Apply Now
Back to Job Listings
❤️Add To Job List
Company Info
View Company Reviews
Date Posted
03/07/2023
Views
9
Positive
Subjectivity Score: 0.8
Similar Jobs
Medical Support Assistant (Advanced) - Department of Veterans Affairs - Veterans Health Administration
Views in the last 30 days - 0
View DetailsAccount Manager, Care Partnerships - Headway
Views in the last 30 days - 0
Headway a mental health care company founded in 2019 aims to revolutionize mental healthcare by building a national network of providers accepting ins...
View DetailsDirector of Pricing - Garner Health
Views in the last 30 days - 0
Garner Health is a rapidly growing company backed by toptier venture capital firms Their mission is to transform the healthcare economy by delivering ...
View DetailsDirector, Product, Customer, and Lifecycle Marketing - Garner Health
Views in the last 30 days - 0
Garner Health is seeking an experienced Product Marketing Leader to join their team The ideal candidate will lead the product marketing efforts focusi...
View DetailsData Analyst - Agero
Views in the last 30 days - 0
Agero a leading B2B whitelabel provider of digital driver assistance services is revolutionizing the vehicle ownership experience through datadriven t...
View DetailsDirector, Product (Remote) - Dscout
Views in the last 30 days - 0
Dscout is a leading company in experience research technology offering a platform for major companies to gain insights into user needs and behaviors T...
View Details