Job Title Summer Internship 2019 - IT WHO WE ARE As one of the worlds leading diversified financial services companies providing personal and commercial banking, wealth management services, insurance, corporate and investment banking, and transaction processing services on a global basis, Royal Bank of Canada (RBC) employs approximately 80,000 people who serve close to 15 million clients worldwide. RBC Wealth Management-US was founded in St. Paul, Minnesota in 1909 and is headquartered in Minneapolis. We are the 7th largest brokerage firm in the U.S. with 1,900 Financial Advisors in 41 states. Our technology strategy is to deliver a superior, differentiated client and employee experience that is secure and highly available, with best-in-class economics, through continuous transformation and innovation. As part of a global organization, our 200+ IT employees in Minneapolis have opportunities to support both local and global initiatives. WHAT WE ARE LOOKING FOR Our Summer Internship 2019 IT program is a great opportunity to gain valuable work experience to complement your education. Our program is 40 hours a week and runs June to August (specific dates may vary). Candidates must have excellent written and verbal communication skills and a strong academic record (minimum GPA of 3.0 on 4.0 scale). HOW TO APPLY Complete an online application and attach a resume listing current GPA and degree of study as well as any experience or coursework pertaining to our Internship Opportunity Areas listed below. Attach an optional cover letter if there are Internship Opportunity Areas of highest interest. Students will be contacted by an RBC Recruiting professional if there is interest in pursuing their application further. POSSIBLE INTERNSHIP OPPORTUNITY AREAS Business Analyst Analyze clients existing systems and business models, document business process flows, map and document interfaces between legacy and new applications, translate business needs into requirements, and identify options for potential solutions while assessing both technical and business suitability. Experience or interest in Software Development Life Cycle (SDLC), MS Office suite and Visio. Data and Reporting Analyst Experience or interest in relational databases, business intelligence tools, SQL Server Integration Services (SSIS), data analysis, data governance, data mapping, and data dictionary work. Developer Experience or interest in WPF, MVVM, Windows Forms, SQL Server, C#, VB.NET, ASP.NET, and IIS. Knowledge Management & Data/Reporting Analyst This individual will review the current Knowledge Base articles and make necessary updates as well as complete trend analysis of service desk tickets. Strong technical writing skills and proficiency in Excel required. Portfolio Reporting Analyst Experience or interest in Project Portfolio Coordination and Reporting within a global Project Delivery Office. Requires advanced Excel (pivot tables, macros, functions) and data analysis. Preferred knowledge of reporting best practices, business intelligence tools (e.g. Tableau), and SharePoint administration experience. Production Support Experience or interest in problem solving and a creative analytical thinker who is self-driven and likes working in a fast-paced environment. Preferred technical knowledge and experience with RedHat/Linux platform technologies. Ideal candidate would have a basic understanding of SQL and HTML, as well as excellent written and verbal communication skills. Strong experience in Word, Outlook, Excel and PowerPoint required. Project Coordinator This individual will be responsible for successful project management framework and delivery. This includes coordination, follow-up, documentation, auditing, communication plans, governance, data entry, and processing forms. Must be proficient in Microsoft Excel. Quality Assurance Experience or interest in Software Development Life Cycle (SDLC), documenting and reporting defects, analyzing functional requirements, designing manual test cases, functional testing, ad hoc testing, regression testing, creating and running SQL database queries. Ideal candidate will have some experience with coding in Java and .NET. Software Automated & Performance Testing Experience or interest in developing automated and performance tests. Preferred skills include knowledge of internet technologies, Ajax, HTTP/HTTPs/HTML/XML, Java script, CSS, XSL/XSLT, and/or XPATH. You will be using automation tools such as HP QTP/UFT LoadRunner, Performance Center and/or Selenium. Experience with environment configurations, defect tracking, build or release management and debugging tools are a plus. Software Development Experience or interest in developing UI components or building APIs. Preferred skills include knowledge of application technologies, c#, XAML, UX Design, etc. You will be participating in working on an in-house application, either testing, providing UI feedback, and developing user interface components or developing an API. Experience using Visual Studio is required. Technical Service Desk This individual will help the business continue to function without any hiccups by providing services to figure out issues with hardware or application. The hardware can be a PC, Laptop or Printer. The application can be a suite of Microsoft applications, applications built by RBC or vendor built applications. Ideal candidate would knowledge of System Center Configuration Manager (SCCM) and scripting would be beneficial, but it is not required. You also need a basic understanding of PC applications and how to troubleshoot issues. Technical Systems Analyst (TSA) Support Back Office Application team, primarily the vendor FIS Protegent Surveillance application. Experience or interest in relational databases and queries (DB2), data analysis, business application testing, business process analysis, and problem research (root cause analysis and solution design). UI Experience (UX) Solid knowledge of user interface design process and methodology. Preferred fields of study include interaction design, visual design, human-computer interaction, human factors, or computer science. About RBC Royal Bank of Canada is Canadas largest bank, and one of the largest banks in the world, based on market capitalization. We are one of North Americas leading diversified financial services companies, and provide personal and commercial banking, wealth management, insurance, investor services and capital markets products and services on a global basis. We have over 80,000 full- and part-time employees who serve more than 16 million personal, business, public sector and institutional clients through offices in Canada, the U.S. and 37 other countries. For more information, please visit rbc.com. 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 rbc.com/careers. Inclusion and Equal Opportunity Employment RBC is an equal opportunity employer committed to diversity and inclusion. We are pleased to consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veterans status, Aboriginal/Native American status or any other legally-protected factors. Disability-related accommodations during the application process are available upon request. JOB SUMMARY City: Minneapolis Address: 60 South Sixth Street Work Hours/Week: 40 Work Environment: Office Employment Type: Regular - U.S. Career Level: Entry Level Pay Type: Hourly Required Travel (%): 0 Exempt/Non-Exempt: Non-Exempt People Manager: No Application Deadline: 12/31/2018 Req ID: 171398 Posting Notes: