Skip to main content

Or use LinkedIn Job Matching to find an opening that matches your experience.

Start Matching

Reporting Analyst- Pricing & Profitability

Apply Now
Job ID EXEC-12788 City Los Angeles State California Exempt/Non Exempt Exempt Shift Day Work Schedule M-F, 805
Job Details:
WHAT IS THE OPPORTUNITY?
Key member of the Commercial Pricing and Profitability Office responsible for development and support of reporting, analytics, models, tools related to pricing and profitability of banking products and services. Support development of market and business insights across a range of banking products and services. Collaborates with internal business partners and external data and service providers.


WHAT WILL YOU DO?
  • Assist with delivery of reports and analysis for Pricing projects through various analytical tools and database systems
  • Manage pricing and profitability dashboards and other reporting based on needs by internal business partners
  • Continuously monitor, audit and analyze pricing activity to assure systematic risks are identified and corrected, sales training issues are identified and addressed, and pricing formulas and database are properly maintained for approved pricing changes
  • Coordinates the development of specialized databases for pricing decisions and justifications. Coordinates the preparation of reports on various aspects of pricing and profitability.
  • Perform routine audits of data and validation checks to ensure delivery of accurate pricing information
  • Manage Earning Credit Rate pricing and reporting, inclusive of managing tool and data sources that support ECR.
  • Develop and enhance scorecard and reporting to include measuring of ECR and Treasury Management Service initiative.
  • Develop and maintain Tableau based reporting and analytics that provide clear insight for business decision making and pricing/profitability efforts.
  • Engage with data architect and technical teams in supporting robust management of data repository. Efforts to include updating records, expanding fields and overall data quality checks.
  • Manage financial and analytics models to include updating/enhancing VBA scripts and data management
  • Use database queries to analyze performance indicators, evaluate performance, and support reporting and generally insights that lead to improved profitability.
  • Engage on alignment of Core Platforms data with proprietary database supporting analytics and pricing tools used by Treasury Management Sales Officer and other partners.


WHAT DO YOU NEED TO SUCCEED

Must-Have*

  • Bachelor's Degree Business, Economics, Finance, Accounting or related field
  • 5+ years of experience working with large amounts of data and complex reports
  • 3+ years of experience working with Tableau


Skills and Knowledge

  • Expert skills with MS Excel and PowerPoint
  • Strong skills with SQL and VBA
  • Strong communication skills
*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.


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.


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.
#CA-TT1
#LI-TT1
Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
Apply Now

Sign up for job alerts.

We will email you when relevant jobs are posted.

Interested InSelect a job category from the list of options. Select a location from the list of options. Finally, click “Add” to create your job alert.

  • Banking Operations/Back Office, Los Angeles, California, United StatesRemove

"By submitting your information, you acknowledge that you have read and consent to City National Bank’s privacy policy and California Employee Privacy Statement and further consent to receive email communication from City National Bank relating to your application.