Business Intelligence (BI) Developer - Salesforce

$92,114 - $156,880/Yr

Royal Bank of Canada - New York, NY

Full-time - Mid Level

New York, NY

5,001-10,000 employees

Credit Intermediation and Related Activities

About the position

As a Business Intelligence (BI) Developer at City National Bank, you will be a key member of the Data & Analytics team, responsible for driving, developing, and maintaining BI reporting solutions for internal clients. This role involves creating dashboards, visualizations, and reports while collaborating with business users to gather requirements and troubleshoot issues. You will also be involved in ensuring data quality and performance within the BI reporting environment, making this an exciting opportunity to contribute to technology advancements within the bank.

Responsibilities

• Develop dashboards, visualizations, semantic data models, and reports.
• Create high-level and detailed designs for existing reporting platforms and development activities.
• Collaborate with business users to gather requirements and troubleshoot report issues.
• Communicate effectively with business users and T&I support teams to resolve problems.
• Familiarize yourself 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 and dashboards.
• Set up and maintain access for new and current users in the BI Reporting environments.
• Research and troubleshoot user-reported issues related to the BI reporting environment.
• Take initiative to learn new technologies and research solutions independently.
• Manage multiple projects and tasks with tight deadlines while staying informed of industry standards and best practices.
• Maintain positive relationships with colleagues and business users to meet customer service expectations.
• Fulfill training and continuing education requirements for internal programs and external certifications.

Requirements

• Bachelor's Degree or equivalent.
• Minimum 3 years of BI report development experience using Salesforce CRM Analytics, SAP Business Objects, Tableau, Power BI, or other BI technologies.
• Minimum 3 years of direct SQL experience.
• Minimum 3 years of experience in finance or banking.
• Direct experience with Oracle, MS SQL Server, and Snowflake preferred.
• Excellent analytical and problem-solving skills.
• Strong oral and written communication and interpersonal skills.
• Strong organizational, multi-tasking, and time-management skills.

Nice-to-haves

• BS in Computer Science or a related technical field preferred.
• Direct experience with Salesforce CRM Analytics, Business Objects 4.2 or above, Tableau 2021 or above is strongly preferred.

Benefits

• Competitive salary with eligibility for bonuses and commissions.
• Comprehensive benefits package including health insurance, retirement plans, and paid time off.