Senior Business Intelligence & Reporting Analyst,, Jersey , NJ

Senior Business Intelligence & Reporting Analyst, RBC Capital Markets, LLC, Jersey City, NJ

Manage and govern enterprise Tableau platforms for Global Markets analytics, overseeing BI developers and enforcing SDLC protocols. Deliver secure, high-performance reporting by architecting advanced Tableau dashboards and administering Tableau Server in high-availability environments. Lead data engineering efforts with SQL Server, optimizing schemas and queries, and automate data refresh and report distribution using Control-M and Python. Integrate data from multiple sources including Snowflake, Databricks, Cloudera Impala, and relational databases.

Translate business requirements into robust data models and documentation, supervise two BI Developers, and ensure compliance with governance standards.

Telecommuting permitted up to 1 day per week.

#LI-DNI

Full time employment, Monday
- Friday, 40 hours per week, $ 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.

• Administering Tableau Server in High Availability (HA), clustered enterprise environments, including Tableau Service Manager (TSM) and Tabcmd, content governance.
• Security Assertion Markup Language (SAML), Active Directory (AD) integration, row level security, subscriptions, scheduling, backup, restore, migrations, and upgrade planning.
• Advanced development in Tableau Desktop including Level of Detail (LOD), table calculations, parameter actions, complex joins, blends, extract optimization and performance recording.
• Programming in SQL Server and T SQL, including indexing, partitioning, query plan optimization, stored procedures, functions, and security models including schemas and roles.
• Python for BI automation, including production use of the Tableau REST API and Tableau Server Client (auth, publish, permissions, schedules, and metadata).
• Building and orchestrating Control M jobs for data refresh and distribution.
• Snowflake, Databricks and Delta Lake, and Cloudera Impala and cloud based analytics tools including Sigma, Alteryx and Tableau on cloud.
• Hands on Open Database Connectivity and Java Database Connectivity configurations and performance tuning.
• Supporting Global Markets, Capital Markets, Securitized Products functions, including product data structures, trade lifecycle, pricing, exposure calculations, and control, reporting workflows.

• Supervising BI developers through task allocation, code reviews, mentoring, and performance feedback.
• Enterprise SDLC in regulated financial institutions: change management, segregation of duties, release controls, evidence capture for audit including
  - System Development Life Cycle (SOX), SOC
  2.
• Extracting and securing large data volumes for Business Intelligence (full and incremental), row level security, and performance optimization for high concurrency user bases.

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 plays 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

Address:

City:

Country:

Work hours/week: 0

Employment Type: Full time

Platform: CAPITAL MARKETS

Job Type: Regular

Pay Type: Salaried

Posted Date:

Final date to receive applications:

Note:

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

At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One RBC. We believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most…