Description
Position Purpose:
Member of the Advanced Client Experience program in Data team. Main responsibilities: analyze business requirement and build solution to export information from core application to feed Enterprise Data Lake.
PRIMARY RESPONSIBILITIES
Overall Technical Analysis and design activities
Assess and analyze business needs, exploring alternative options to recommend technology solutions and designs that meet sponsor needs.
Lead detailed design phases
Prepare high level and detailed technical specifications
Collaborate with Project Manager to determines best choice between internal development, applications interfacing, third party vendor solutions to meet business requirements and project objectives.
Contribute to successful project completion by identifying risks and recommending mitigation strategies.
Manage application datamodeling and collaborate with DBA to create the best database structures.
Activities specific to ACE program
Understand the data required by consumers (RBC One portal, API, other surfacing capabilities)
Understand the data sources (core applications, third party solutions, ) >= architecture, data model, volumes, interfaces, .
Design and build the solution to export data and feed the data lake
Coding, Testing & Documentation
Develop solution according to design phase
Execute unit test, system, integration and acceptance test
Provide documentation.
Planning, Implementation & Support
Develop detailed plans and accurate estimates for analysis, build, system testing and implementation phases of project.
Perform performance tuning to meet SLA.
Ensure on-call support of applications.
Relationships & Communication
Manage communication with 3rd party vendors.
Create good relationship with team members, IT and business stakeholders.
Facilitate meetings for technical design, decision making, problem solving and task implementation.
Prepare and deliver presentations to business, technology partners and senior management, selecting the appropriate approach based on the audience.
Resolve conflicts/issues and escalates others as appropriate.
Development & Coaching
Act as workstream leader to manage project scope
Provide direction, expertise, feedback, coaching to junior staff.
POSITION REQUIREMENTS/EXPERIENCE
Technical Knowledge:
Oracle and SQL
Datawarehouse development tools and practices
ETL and reporting Tools (SAP BO is welcome)
Unix, Windows
Any experience in Big data technologies (Hadoop ecosystem) is welcome
COMPETENCIES
Behaviour
Decision making skills
Teamwork
Business and results oriented
Autonomy
Agile mindset
Ability to motivate and convince associates
Good collaboration and communication
Business Knowledge:
Experience in Banking/financial sector
Experience un fund administration domain
Profile:
Degree in information technology or scientific study with experience in data processing and database developments
Fluent in English, French is ideal