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 ManagementAdditional 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.
Other Jobs from Royal Bank of Canada
Sr. Software Engineer
Associate Director, Lead Full Stack Developer
Senior Software Developer
Senior Site Reliability Engineer
Similar Jobs
Senior Support Engineer
Senior Staff Engineer - Backend
Software Engineer II - Back End (Platform & Infra - Observability)
Data Engineer (Entry Level)
Integration Engineer Intern
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 401 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- Salaries for the engineering jobs on our site range from $100K-$200K. On average, senior engineer positions on our EchoJobs are about $160K.
- The EchoJobs positions have been sourced and vetted from the top companies to work for in the US as a software engineer, including LinkedIn and other reputable job sites. We also have syndicated jobs from companies that have just raised funding, as well as those that have great unique products and culture. From all of these sources, our founder, Morgan, has also resourced the company's authenticity in terms of their website, public appearance, and more.
- Yes, our users asked us for just this, so now our search filters allow you to search for your top jobs via location, as well as by onsite, remote, or both. Approximately 30% of our jobs are remote, so you’ve got the best options for you!
- We have not yet implemented this option, but are considering doing so in the future. For the moment, you would need to cancel your subscription, and resubscribe when you wanted to come back.
- We add new jobs to EchoJobs every day! We scan our sources for the newest jobs, verify them, and post them to EchoJobs within minutes. We add about 2,000-3,000 new jobs for you each day!
- From starting your job search to getting hired, the entire job search process can take us software engineers anywhere between 3-6 months. However, at EchoJobs, we’re striving to shorten this duration by finding the best, newest jobs for you, so you can do less job searching, and more applying.
- We’d recommend checking EchoJobs daily, as we add new jobs to the site each day. Additionally, if you got a chance to read our previous email on “what makes EchoJobs different from any other job search tools,” we also recommended that you set a job alert based on your job filters, so if you get emails on those new jobs, you could be checking more than once per day.
- If you decide to continue with us after the 1-month trial, we definitely recommend this, as we all know it usually takes 3-6 months to find a quality job as a software engineer these days. So to best support you, we just adjusted our membership options at EchoJobs to monthly, 3 months, or 12 months (this option is more for passive job seekers looking a little bit for the future if they want to come back to work or make a job switch potentially. This lets you see what’s out there in case an even better fit job becomes available.)
- EchoJobs is truly the only job site of its kind. We want to be THE spot for you to find the best job for you, and haven’t encountered any other company doing this. Other job sites are in niches besides software engineering or focus on a small portion of engineering jobs (like a specific coding language). In the words of Morgan, our founder, “I think what makes EchoJobs different is the amount of jobs, frequency that we add new jobs (we add 2,000-3,000 new jobs daily!), and the powerful search engines to find exactly the job you want more easily and efficiently. We can provide you with the most jobs that are vetted by us, we’ll continually find more new jobs for you, and we make it easier for you to apply and get hired.
What Fellow Engineers Say