Pricing Data Analyst
PRICING DATA ANALYST
WHAT IS THE OPPORTUNITY?
Key member of the commercial pricing and profitability team responsible for managing pricing and profitability data. Develops and maintains management reporting and supporting process. Collaborates with internal business partners on developing business insights.
Executive Management Division
[n/a]
WHAT WILL YOU DO?
- Develop data models, build and manage databases to capture, store, report on and analyze large arrays of pricing and profitability data
- Develop analytical reports to inform management decisions; establish and manage efficient reporting processes
- Collaborate with Pricing Team and Business partners to gather requirements for data models, analysis and reporting
- Perform analysis of data to identify trends and patterns
- Participate in development of pricing models and pricing tools
WHAT DO YOU NEED TO SUCCEED
Must-Have*
- 5+ years of experience in data modeling, reporting and analysis
- 2+ years of experience developing reports with one or more data visualization tools (Tableau, Power Looker, Qlik, etc.)
- 2+ years of experience cleaning and analyzing data from different sources using SQL, Python and Excel
Skills and Knowledge
- Financial and business acumen
- Experience working in financial services and understanding of financial products
- Experience gathering business requirements/working with non-technical stakeholders
- Proficient with MS Office suite and expert knowledge of data management tools (SQL, Tableau, MS Access)
- Strong verbal and written communication. Collaboration skills and team player
- Experience with Hive/Cloudera and with developing in Pyspark preferred
- Experience working with Treasury Management data preferred
*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.
City National Bank requires all colleagues to be fully vaccinated against COVID-19 to work on-site at any of our locations.