Ubisoft - Job details

Job details

Job 1 of 1
Senior BI ETL Developer
Information Systems
Canada - Montreal

Senior BI ETL Developer

Ubisoft, producer, editor and distributor of video games, interactive software, and multimedia applications situated in a loft in Montreal, offers a stimulating work environment where creativity, friendliness and leading edge technology are how what we pride ourselves in. You will benefit from a competitive salary and a range of social advantages, packaged with the strong possibility of advancement, as well as profit from a learning environment allowing you to get hands on experience with the latest innovations of your field.

The Senior BI ETL Developer will be part of the central Business Intelligence team to contribute to design, build and maintain critical warehouses. The developer will provide ETL solutions to answer technically challenging business requirements.


The ideal candidate will have a deep understanding of technical and functional designs for ETL, Database, Data Warehousing, and Reporting areas. This job plays a key role in financial analytics projects, systems design and development. This team is accountable for ensuring that the overall functional and technical design of work processes and applications meet business and functional requirements. In addition, the work must be sustainable and conform to operation infrastructure.

- DW schema/models/objects/systems design, implementation and optimization;
- ETL framework design, implementation and management;
- Analyze performance bottlenecks and recommend tuning optimization;
- Participate in architectural and model decisions during the design and build phases of new projects;
- Work closely with application developers and administrators to streamline data flows between internal/external systems and the data warehouse;
- Good understanding of user requirements and functional specifications;
- Ensure that formal documentation is produced for all development projects.

Education and Experience

- BSc. In Computer Science or related degree.;
- 5+ years of experience on implementing ETL for Data Warehouse and Business Intelligence solutions.


- Good understanding of general data warehousing concepts;
- Full lifecycle experience surrounding large scale DW/BI solutions having Microsoft SQL Server as backend;
- Developing ETL processes with Data from various sources: SQL Server, Oracle, Online content etc;
- Strong expertise with SQL Server programming objects such as Stored Procedures, Views and Function;
- Good communications skills in English (spoken and written);
- Good understanding of data warehousing concepts;
- Excellent knowledge of SQL;
- Data modeling skills are required;
- Working knowledge of one or more BI suite is important (Business Objects, SQL Server, …).


- Excellent communication skills (both written and oral) in English;
- Strong organizational and multi-tasking skills;
- Ability to communicate ideas and solutions to non-technical people;
- Ability to efficiently QA your own work to ensure that processes you built generate high quality output;
- Ability to autonomously lead and implement a requirement from end-to-end.


- Excellent communication skills (both written and oral) in French;
- Experience on Business Analysis and/or Project Management;
- Experience with informatica;
- Exposure to SQL 2012 is a plus;
- MDM (Master Data Management) knowledge is a plus.