Sr. Business Intelligence & Reporting Analyst

Sr. Business Intelligence & Reporting Analyst, RBC Capital Markets, LLC – Jersey City, NJ

Design, build, test, and deploy Business Intelligence reports and dashboards using Tableau, SQL Server, and SSMS (SQL Server Management Studio). Collaborate with database developers and business analysts to extract, transform, and load data as required by the business, employing data modeling and data warehousing concepts. Create rich visualizations by utilizing Tableau best practices and administer Tableau server content daily. Engage with business users and stakeholders to gather key requirements, document high-level and functional specifications, review potential solutions, and prepare an execution plan.

Allocate development tasks to junior team members and provide training as needed.

Telecommuting permitted up to 40%.

Full time employment, Monday - Friday, 40 hours per week, Salary of $ per year.

• Must have a 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 and 3 years of related work experience.
• Must have 3 years of experience in each of the following:
• Tableau Desktop and Server administration.
• SQL and programming in SQL Server.
• Data refresh automation, dashboard building and report distribution.
• Data preparation (using ETL), data modeling, data visualization, analytics, or UI/UX.
• Python programming to build data extracts and call Tableau APIs.
• Data connections to RDBMS on premise, cloud data (Databricks, Snowflake, Cloudera Impala or similar), ODBC/JDBC and flat files.
• Global Markets, Investment Banking, Capital Markets and Secured Products business functions, process flows and data structures.
• Relational Databases (tables, views, functions, indexes), data warehousing, and ETL.
• Architecture of application servers, configurations, high availability, and disaster recovery.
• BI tools (Alteryx, Qlik, or Power
  
  BI).
• Extracting large volumes of data for BI tools (full and incremental), performance optimization of reports, and security/access models.

Employer will accept any suitable combination of education, training, or experience.

The base salary for this job is $ per year. This salary does not include other elements of total compensation, including a discretionary bonus and benefits such as a 401(k) program with company‑matching contributions; health, dental, vision, life and disability insurance; and paid time‑off plan.

RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and play a critical role in attracting, engaging and retaining talent that:

• Drives RBC’s high performance culture.
• Enables collective achievement of our strategic goals.
• Generates sustainable shareholder returns and above‑market shareholder value.

• Big Data Analytics
• Critical Thinking
• Data Administration
• Data Mining
• Data Modeling
• Data Movement
• Detail‑Oriented
• Group Problem Solving
• Quantitative Research
• Research Documents

TO APPLY:

Please click “Apply Now” Button.

Applications will be accepted until 11:59 PM on the day prior to the Final date to receive applications date above.

Inclusion and Equal Opportunity Employment.

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities.

RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Location:

Jersey City, NJ – 30 Hudson Street.

Employment Type:

Full time.

Work hours per week: 40 hours.

Posted Date: .

Stay in‑the‑know about great career opportunities n up and get customized info on our latest jobs, career tips and recruitment events that matter to you. Expand your limits and create a new future together d out how we use our passion and drive to enhance the well‑being of our clients and communities at