BUSINESS INTELLIGENCE (BI) DEVELOPER
WHAT IS THE OPPORTUNITY?
As a member of City National's Technology & Innovation group, you will drive, develop, and maintain solutions for clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our technology teams.
What you will do

• Develop dashboards, visualizations, semantic data model, and reports.
• Develop high level and detailed designs for existing reporting platforms, development activities along with process improvements.
• Work with business users to gather requirements, troubleshoot report issues, and drive resolutions towards completion.
• Effectively communicate and collaborate with business users, T&I support teams, providing an understanding of the problem and resolution.
• Become familiar with Operational Data Stores, Data Warehouse content, and other BI reporting data sources.
• Identify development and data quality issues, performing thorough testing and validation of reports, visualizations and dashboards in conjunction with business users.
• Setup and maintain access for new and current users in the BI Reporting environments.
• Research and trouble-shoot user-reported issues and incidents related to the BI reporting environment including performance, data discrepancies, access issues, etc.
• Be a self-starter, someone that will take the initiative to learn new things and research solutions without prompting.
• Ability to multi-task various projects and tasks with tight deliverables while keeping informed of existing and evolving development best practice, industry standards and technologies.
• Fosters and maintains good relationships with colleagues to meet expected customer service levels.
• Maintain all appropriate training and continuing education requirements for both internal programs and external licenses and certifications.
• Develop and maintain positive, productive, and professional relationships with key business users to meet expected customer service levels.

Must-Have*

• Minimum 3 years of report development experience using Business Objects, Tableau, Power BI, or other Business Intelligence technologies or equivalent.
• Minimum of 5 years of direct SQL experience

Skills and Knowledge

• Oracle, PL/SQL, MS SQL Server preferred
• Minimum 1-2 years of experience working in Financial Services preferred.
• BS in Computer Science or a related technical field preferred.
• Direct experience with Oracle databases, PL/SQL is strongly preferred.
• Direct experience with Business Objects 4.2 or above is strongly preferred.
• Direct experience with Tableau 2019 or above is strongly preferred.
• Direct experience with Power BI a plus.
• Direct experience with Tableau Prep a plus.
• Excellent analytical and problem-solving skills.
• Excellent oral and written communication and interpersonal skills.
• Strong organizational, multi-tasking, and time-management skills preferred.
• Ability to work independently or within a team for problem resolution
• Must demonstrate ability to multi-task and be flexible.

Compensation
Starting base salary: $92,114 - $156,880 per year. 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.'
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.