New Jersey Staffing
Sr. Business Intelligence & Reporting Analyst
New Jersey Staffing, Jersey City, New Jersey, United States, 07390
Sr. Business Intelligence & Reporting Analyst
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 $210,000 per year. Minimum Requirements: 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, the employer will accept a Master's degree or foreign equivalent in Computer Science, Engineering, or a related field, 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 API's; 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 Securtitized 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 DR; BI Tools (Alteryx, Qlik, or PowerBI); and, Extracting large volumes of data for BI tools (full and incremental), performance optimization of reports, and security/access models. Telecommuting permitted up to 40%. Employer will accept any suitable combination of education, training, or experience. To Apply: Visit rbc.com under "careers" and search for Requisition ID #R-0000143540 and click "Apply".
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 $210,000 per year. Minimum Requirements: 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, the employer will accept a Master's degree or foreign equivalent in Computer Science, Engineering, or a related field, 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 API's; 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 Securtitized 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 DR; BI Tools (Alteryx, Qlik, or PowerBI); and, Extracting large volumes of data for BI tools (full and incremental), performance optimization of reports, and security/access models. Telecommuting permitted up to 40%. Employer will accept any suitable combination of education, training, or experience. To Apply: Visit rbc.com under "careers" and search for Requisition ID #R-0000143540 and click "Apply".