Senior Database Engineer / Administrator

Royal Bank of Canada - Raleigh, NC

Full-time - Senior

Raleigh, NC

Credit Intermediation and Related Activities

About the position

The Senior Database Engineer / Administrator at RBC Capital Markets will be responsible for supporting the development and maintenance of scalable data stores that provide big data for business analysis. This role involves creating software for data retrieval and processing, handling large datasets, and leading the development of automation solutions.

Responsibilities

• Create software for retrieving, parsing, and processing structured and unstructured data.
• Handle large datasets and build complex data reporting, integrating data from diverse sources in different formats.
• Lead the development of project approaches, proposals, business cases, and timelines for automation solutions.
• Define and build scalable ETL/ELT workflows for reporting and analytics.
• Develop scripts and programs for converting various types of data into usable formats.
• Split responsibilities equally between support and development.

Requirements

• Minimum 7 years' experience in reporting and business analysis.
• Post secondary degree.
• Advanced SSIS experience, including C# and VB Script Tasks, Data Flow Tasks, SQL Tasks, and logging.
• Complex T-SQL skills, including stored procedure parameters, table variables, and complex table joins.
• Query optimization skills to identify and resolve query bottlenecks.
• Database design experience, including creating tables, indexes, triggers, and views.

Nice-to-haves

• 3+ years of experience in Financial Services.
• Bachelor's Degree in Business Statistics, Data Science, Predictive Analytics, or a related field.
• Prior experience with Service Now.
• Exposure to Cloud Services such as AWS, Azure, Snowflake.

Benefits

• Comprehensive Total Rewards Program including competitive compensation and bonuses.
• Continued opportunities for career advancement.
• World-class sales training, coaching, and development opportunities.
• Support from a dynamic, collaborative, and high-performing team.
• Opportunity to achieve great success and grow your career with RBC.