Sr. Business Intelligence & Reporting Analyst

RBC • Jersey City, NJ

83d • $210,000 - $210,000

About The Position

The Sr. Business Intelligence & Reporting Analyst at RBC Capital Markets, LLC, based in Jersey City, NJ, is responsible for designing, building, testing, and deploying Business Intelligence reports and dashboards using Tableau, SQL Server, and SSMS (SQL Server Management Studio). The role involves collaborating with database developers and business analysts to extract, transform, and load data as required by the business, employing data modeling and data warehousing concepts. The analyst will create rich visualizations by utilizing Tableau best practices and administer Tableau server content daily. Engaging with business users and stakeholders to gather key requirements, document high-level and functional specifications, review potential solutions, and prepare an execution plan is also a key part of the job. Additionally, the analyst will allocate development tasks to junior team members and provide training as needed. Telecommuting is permitted up to 40%.

Requirements

• Bachelor’s degree or foreign equivalent in Computer Science, Engineering, or a related field and 5 years of progressive, post-baccalaureate related work experience.
• Alternatively, a Master's degree or foreign equivalent in Computer Science, Engineering, or a related field, and 3 years of related work experience.
• 3 years of experience in Tableau Desktop and Server administration.
• 3 years of experience in SQL and programming in SQL Server.
• 3 years of experience in data refresh automation, dashboard building, and report distribution.
• 3 years of experience in data preparation (using ETL), data modeling, data visualization, analytics, or UI/UX.
• 3 years of experience in Python programming to build data extracts and call Tableau APIs.
• Experience with data connections to RDBMS on premise, Cloud data (Databricks, Snowflake, Cloudera Impala or similar), ODBC/JDBC, and Flat files.
• Knowledge of Global Markets, Investment Banking, Capital Markets, and Securitized Products business functions, process flows, and data structures.
• Experience with relational databases (Tables, Views, Functions, Indexes), data warehousing, and ETL.
• Understanding of architecture of application servers, configurations, high availability, and DR.
• Experience with BI tools (Alteryx, Qlik, or PowerBI).
• Experience in extracting large volumes of data for BI tools, performance optimization of reports, and security/access models.

Responsibilities

• Design, build, test, and deploy Business Intelligence reports and dashboards using Tableau, SQL Server, and SSMS.
• Collaborate with database developers and business analysts to extract, transform, and load data.
• Create rich visualizations using Tableau best practices and administer Tableau server content.
• Engage with business users and stakeholders to gather key requirements and document specifications.
• Review potential solutions and prepare an execution plan.
• Allocate development tasks to junior team members and provide training.

Benefits

• 401(k) program with company-matching contributions
• Health, dental, vision, life and disability insurance
• Paid time-off plan

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees