Sr. Application Specialist

RBC • Minneapolis, MN

3d • $70,000 - $130,000

About The Position

What is the opportunity? Partners across IT and with assigned business line(s) to assess, research, and analyze business, technical and system needs in order to resolve business systems issues by recommending and owning technology solutions that meet sponsor/stakeholder needs. Will work on large projects/programs with multiple applications with multiple interfaces and/or 3rd parties. What will you do? Technical Analysis, Design and Consulting Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers. Manages detailed design phases for large projects/ programs identifying, tracking and resolving technical issues and ensuring solution meets sponsor needs. These include Alternative investments, Order Entry and Performance Reporting data file creation process. Provide quality and timely support to our business partners through contributions to mid-size, heavily integrated programs through building and running SQL queries to perform data analysis, impact analysis, and/or building ad hoc report Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies Provides input and co-ordinates with technical team members in creating new and modifying existing database structures using different types of databases and recommending appropriate DB based on required functionality across multiple systems. Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers. System Implementation Provides or participates in technical liaison between business the project or support team for project installations. Partners with development and support team in release activities and Post Implementation Validation activities for the application(s) supported. Testing & Documentation Partners with Quality Engineering team and manage User Acceptance testing and verification ensuring all tasks are performed for all interfaces. Ensures adequate technical documentation and training. Planning, Implementation & Support Manages all aspects of implementation planning & coordination. Develops detailed plans and accurate estimates for the design, build, implement and stabilize phases of the project. Performs database/ disaster recovery planning for multiple systems. Relationships & Communication Acts as primary IT liaison with multiple interfacing applications, 3rd party vendors, IT Executive and/or Project Managers. Effectively communicates and builds rapport with team members, stakeholders and interface groups using a variety of techniques and collaboration from initiation to close. Facilitates complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning. Prepares and delivers presentations to business and technology partners, senior management and executives, selecting the appropriate approach based on the audience. What do you need to succeed? Must-have Position requires 7+ years of experience in IS/IT performing business/systems & data analysis. Experience working with product owner, business analysts and developer Creating presentation, flow charts, business process documents with appropriate level of details and abstractions Translating requirements into technical solutions Understand business requirements Working knowledge and experience with cloud services – SaaS, preferred IaaS, PaaS Experience with building / running SQL query at an advanced level to perform data analysis, impact analysis, and/or producing ad hoc report Good understanding of data models and large data analysis Nice-to-have Hands on experience with Informatica MDM (Master Data Management) Experience working in Agile development setting & familiarity with Jira Experience working in an enterprise environment and Service Oriented Architecture with multiple integration with upstream & downstream systems. Experience with financial industry and / or customer data / client information 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 bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable. Leaders who support your development through coaching and managing opportunities. Ability to make a difference and lasting impact. Work in a dynamic, collaborative, progressive, and high-performing team. A world-class training program in financial services. Flexible work/life balance options. Opportunities to do challenging work. The expected salary range for this particular position is $70,000-$130,000, depending on your experience, skills, and registration status, market conditions and business needs. You have the potential to earn more through RBC’s discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals. RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that: Drives RBC’s high-performance culture. Enables collective achievement of our strategic goals. Generates sustainable shareholder returns and above market shareholder value. #TechPJ #LI-Post

Requirements

• Position requires 7+ years of experience in IS/IT performing business/systems & data analysis.
• Experience working with product owner, business analysts and developer
• Creating presentation, flow charts, business process documents with appropriate level of details and abstractions
• Translating requirements into technical solutions
• Understand business requirements
• Working knowledge and experience with cloud services – SaaS, preferred IaaS, PaaS
• Experience with building / running SQL query at an advanced level to perform data analysis, impact analysis, and/or producing ad hoc report
• Good understanding of data models and large data analysis

Nice To Haves

• Hands on experience with Informatica MDM (Master Data Management)
• Experience working in Agile development setting & familiarity with Jira
• Experience working in an enterprise environment and Service Oriented Architecture with multiple integration with upstream & downstream systems.
• Experience with financial industry and / or customer data / client information

Responsibilities

• Facilitates Requirement gathering with the business and translates the business requirements into technical specifications for the vendor or internal developers.
• Manages detailed design phases for large projects/ programs identifying, tracking and resolving technical issues and ensuring solution meets sponsor needs.
• Provide quality and timely support to our business partners through contributions to mid-size, heavily integrated programs through building and running SQL queries to perform data analysis, impact analysis, and/or building ad hoc report
• Contributes to successful project completion by identifying risks and developing/recommending mitigation strategies
• Provides input and co-ordinates with technical team members in creating new and modifying existing database structures using different types of databases and recommending appropriate DB based on required functionality across multiple systems.
• Provides or participates in technical liaison between business the project or support team for project installations.
• Partners with development and support team in release activities and Post Implementation Validation activities for the application(s) supported.
• Partners with Quality Engineering team and manage User Acceptance testing and verification ensuring all tasks are performed for all interfaces.
• Ensures adequate technical documentation and training.
• Manages all aspects of implementation planning & coordination.
• Develops detailed plans and accurate estimates for the design, build, implement and stabilize phases of the project.
• Performs database/ disaster recovery planning for multiple systems.
• Acts as primary IT liaison with multiple interfacing applications, 3rd party vendors, IT Executive and/or Project Managers.
• Effectively communicates and builds rapport with team members, stakeholders and interface groups using a variety of techniques and collaboration from initiation to close.
• Facilitates complex group meetings (including business partners) for technical design, decision making, problem solving, implementation and strategic planning.
• Prepares and delivers presentations to business and technology partners, senior management and executives, selecting the appropriate approach based on the audience.

Benefits

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
• Leaders who support your development through coaching and managing opportunities.
• Ability to make a difference and lasting impact.
• Work in a dynamic, collaborative, progressive, and high-performing team.
• A world-class training program in financial services.
• Flexible work/life balance options.
• Opportunities to do challenging work.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed