Senior Business Intelligence Engineer (GCS)
RBC
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
- Published on September 3rd, 2024
-
Starting date : 1 position to fill as soon as possible
Description
Job Summary
Job Description
What is the opportunity?
The GCS Strategic Services team has built out an Identity Data Intelligence pillar with the mandate to consolidate, cleanse, govern, and enrich our IAM data to make strong data driven strategic decisions, and identify opportunities to streamline processes through automation, in partnership with Operations teams. As the Senior Business Intelligence Engineer, the role mandate is to build intelligent, data driven solutions to support key partners across the IAM domain area, including Operations, Governance, Process development, and Metrics reporting, as well as other key stakeholders across GCS. You will perform tasks such as designing, building, and maintaining data pipelines, data integration processes, and data infrastructure, as well providing guidance and expertise on solution and process optimization to drive more efficient processes and reduce risk across the domain.
What will you do?
- Partner with stakeholders across the GCS Strategic Services team to design, build, and optimize data pipelines using technical programming languages (eg. SQL, Python)
- Handle multiple data projects in parallel by working closely with stakeholders to capture data requirements, develop data pipeline as per business requirements, and provide feedback and expertise to ensure optimal outcome and delivery to meet the objective.
- Contribute to Tableau dashboard development and data visualization, as well as identify and fix performance issues in Tableau dashboards.
- Create technical documentation and perform unit testing, develop and execute comprehensive test plans and test cases, and resolve identified defects to ensure highest data quality and accuracy.
- Perform data analysis to identify and uncover new and innovative insights from existing or potential data sources to identify opportunities to strengthen risk reporting
- Maintain SharePoint Forms to support data collection and management. Work with JSON format and REST API integration for effective data handling.
- Set up and manage automation processes using Windows virtual machines (VM) with Python and API integration.
- Provide ongoing support for production environments, addressing issues and ensuring smooth operation. Mentor and support junior team members, providing guidance and technical expertise.
What do you need to succeed?
Must-have
- Bachelor's degree in computer science, information systems, engineering, or a related field.
- 10+ years of overall industry experience specifically in data engineering
- Strong knowledge of data engineering principles, data integration, and data warehousing concepts
- Proficiency in building and maintaining data pipelines using Dataiku or equivalent work experience
- Solid understanding of ETL processes and REST API integrations with JSON-based data formats
- Proficient in Python (i.e. Pandas, Numpy, etc) amongst other data-analysis related tools and libraries
- Strong SQL skills, with experience in performance tuning and optimization of complex queries in SQL Server. Experience in maintaining SharePoint forms (HTML, JavaScript, jQuery)
- Excellent written and verbal communication skills with ability to influence and work collaboratively with diverse and cross-functional teams
Nice-to-have
- Python or Tableau certification or equivalent experience
- Familiarity with virtual machines (VM) deployment and config management (PowerShell)
- Proficiency with version control using GitHub.
- Managing all work in Jira, including but not limited to story creation, defect resolution, etc.
- Proficiency in manual testing techniques and familiarity with automated testing tools and frameworks (qTest)
- Managing all work in Jira, including but not limited to story creation, defect resolution, etc.
- Excellent troubleshooting skills to rapidly identify and resolve issues
- Strong understanding of IAM principles and data governance
Whats in it for you?
We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.
- A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable
- Leaders who support your development through coaching and managing opportunities
- Ability to make a difference and lasting impact
- Work in a dynamic, collaborative, progressive, and high-performing team
- A world-class training program in financial services
- Flexible work/life balance options
- Opportunities to do challenging work.
#LI-Hybrid
#LI-Post
#LI-PK
#TechPJ
Job Skills
Analytical Thinking, Automation Technology, Critical Thinking, Data Administration, Data Analysis, Data Engineering, Data Mining, Data Modeling, Data Quality, Data Validation, Detail-Oriented, Group Problem Solving, Python (Programming Language), Structured Query Language (SQL)Additional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Inclusion and Equal Opportunity Employment
At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.
Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign 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 at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
Requirements
undetermined
undetermined
undetermined
undetermined
Other RBC's offers that may interest you
- Job posting | Planificateur(rice) financier(ère) relationnel(le) | Rimouski,QC
- Job posting | | Planificateur(rice) Financier(ère), Planification en placements et retraite | Thetford-Mines,QC
- Job posting | 2024 Summer Student Opportunities Technology & Operations - Software Developer (Calgary), 8 Months | Calgary,AB