DATAWAREHOUSE ANALYST DEVELOPER (M/F) recruitment
RBC Dexia Investor Services offers a complete range of investor services to institutions worldwide. Our unique offshore and onshore solutions, combined with the expertise of our 5,200 professionals in 16 markets, help clients grow their business and sustain enhanced performance through efficiency improvements and robust risk management practices.
Equally owned by RBC and Dexia, the company ranks among the world's top 10 global custodians with USD 2.8 trillion in client assets under administration.
rbcdexia.com
PURPOSE
Having a strong experience in Datawarehouse Development and support, member of the “Datawarehouse Management” team
PRIMARY RESPONSIBILITIES
- Analysis of the business requirements
- Architecture Design of target solution.
- Enhancements of application contents to follow business needs and operational systems evolutions
- Workload estimation and proposition of planning including all the involved teams and stakeholders.
- Optimization tuning of the application
- Preparation and execution of test scenarios
- Quality and best practices review
- Sharing of expertise, training and coaching of other team members
- 3rd line support of production environment
POSITION REQUIREMENTS/ SPECIFICATIONS
Behavioural Competencies
- Ability to change, Open minded
- Sense of organization and analytical spirit
- Motivated, communicative
- Proactive, dynamic
- Well organized and structured
Experience (to enter position)
3 years experience in Business Intelligence/Datawarehousing domain,
Education Experience
- Degree in information technology or scientific study with experience in data processing and database developments
- Fluent in French and English
Technology Knowledge
- Sybase IQ 12.7 and 15 (incl. Transac SQL)
- Oracle 11g (incl PL/SQL)
- SAP/BusinessObjects suites (incl. BODS, WebI)
Business Knowledge
- Banking knowledge with specific experience in fund administration and financial instrument management
- Analytics knowledge
KEY ORGANIZATION RELATIONSHIPS
- Enterprise Architect
- Solution Architect
- Reporting Team
- Service Management
- Service owner/Delivery Manager
- Project/Program management
- Business analyst/Subject Matter Experts
- Providers