Database Analyst

Job Summary

Job Description

What is the opportunity?

The Database Analyst 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

What do you need to succeed?

Must-have

• 5 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

Country:

United States of America

Work hours/week:

40

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2024-06-18

Application Deadline:

2024-07-15

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.