Your life at Ubi
The IT Department of Ubisoft is currently seeking a full-time Senior Data Warehouse Developer specialized in designing and developing Data Warehouse solutions.
The future colleague would have to become quickly autonomous and cover by himself / herself the technical project developments related to Production Costs / HR & KM / Procurement reporting solution : technologies involving Snowflake, TERADATA and MicroStrategy.
He / she will work also with our business contacts, technical representatives of our external partners and the support team.
Your main mission
Design, develop and maintain ETL jobs and related data warehouse models / objects / systems, using an in-house, code based , ETL framework.
This will mainly involve writing SQL code for the target database systems we use (Snowflake, Teradata), which will be executed by the custom ETL framework.
Working with Linux or Python may also be required.
Participate in architectural and model decisions during the design and build phases of new projects; test the solutions implemented and analyzing potential data quality issues to determine the root cause.
Perform database tuning including monitoring, troubleshooting, and optimizing performance of the databases
Proactively identify critical roadblocks during development phase& their impacts and recommend optimized solutions
When needed, assume the role of Technical Project Coordinator for a given business project : define the project technical backlog;
working with the architecture and development team to define the project technical design; help fix any roadblocks that may occur during development phase;
be a key developer in the project
Be aware and ready to implement trends in BI Domain and propose new technologies and methodologies which bring added value to our business projects and Data Warehouse solution
Take initiatives regarding the creation of reusable components and help expanding the functionalities of the existing ETL framework.
Play an active role in sharing the technical knowledge inside the development team, and the creation of Technical Documentation, also in being a technical mentor for more junior developers
The professional value you bring
Very good expertise on BI developments
Previous work experience within designing and developing Data Warehouse solutions on database engines (Snowflake, TERADATA / SQL Server or Oracle) and ETL tools (SSIS / Informatica PowerCenter / IBM DataStage / Abinitio or other major ETL tools)
Experience in developing ETL processes with data from various sources : NoSQL, SQL Server, Oracle, Online contents.
Excellent English communication skills (written and verbal)
Nice to have
Agile methodology knowledge is an asset
The personal value you bring
Analytical skills and being accountable for his / her actions
Strong capacity to communicate ideas and solutions to non-technical people
A passion for being involved with / use new technologies and standards to change