Job Summary
Job Description
What is the opportunity?
The Senior Database Engineer / Administrator will support the development and maintenance of scalable data stores that supply big data in forms needed for business analysis.
What will you do?
- Create software for retrieving, parsing and processing structured and unstructured data
- Handle large datasets and build large and complex data reporting, integrating data coming from diverse sources in different formats, while automating wherever and whenever possible
- Lead the development of project approaches, proposals, business cases and timelines to support the implementation of automation solutions (dev / test / production)
- Define and build scalable ETL / ELT workflows for reporting and analytics
- Developing scripts and programs for converting various types of data into usable formats
- The responsibilities will be a 50-50 split between support and development
What do you need to succeed?
Must-have
- Minimum 7 years' experience performing reporting and business analysis
- Post secondary degree
- Advanced SSIS Experience - must have experience with C# and VB Script Tasks; Data Flow Tasks, importing Excel (and other) files;
SQL Tasks; Loops; using Logging, etc. Understand the use of database backups, how to restore backups, etc.
Complex T-SQL : using stored procedure parameters; declaring variables; table variables; using system functions; using If statements and While loops;
using Begin / Catch; complex table joins
- Query Optimization : able to find query bottlenecks and solution changes to fix them. Understands when queries can be combined to avoid excessive table reads.
- Database Design : Creating tables, indexes, triggers, views, etc.
Nice-to-have
- 3+ years of experience in Financial Services
- Bachelors Degree in Business Statistics, Data Science, Predictive Analytics or other applicable field
- Prior experience with Service Now
- Exposure to Cloud Services such as AWS, Azure, Snowflake, etc.
What's 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 competitive compensation, bonuses, and flexible benefits
- Continued opportunities for career advancement
- World-class sales training, coaching, and development opportunities
- Support from a dynamic, collaborative, progressive, and high performing team, as well as world-class tools and training
- Opportunity to achieve great success and grow your career with RBC
Job Skills
Big Data, Big Data Management, Cloud Computing, Database Development, Databasing, Data Mining, Data Warehousing (DW), ETL (Extract Transform Load) Testing, ETL Operations, ETL Processing, ETL Workflows, Group Problem Solving, Quality Management, Requirements Analysis, Requirements Assessment, Workflow Management
Additional Job Details
Address :
8081 ARCO CORPORATE DRIVE : RALEIGH
City : Raleigh
Raleigh
Country :
United States of America
Work hours / week : Employment Type :
Employment Type : Full time
Full time
Platform :
TECHNOLOGY AND OPERATIONS
Job Type : Regular
Regular
Pay Type : Salaried
Salaried
Posted Date : 2024-06-18
2024-06-18
Application Deadline :
2024-10-25
I nclusion 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.