Ubisoft Montreal, an industry leading developer of video games, located in the heart of Montreal’s Mile-End, offers a unique environment where creativity, teamwork and cutting-
edge technology bring to life critically acclaimed video games and iconic AAA franchises.
When you join Ubi Montreal, you enter a community of passionate, extraordinary people connected by their need to innovate, to be creative and to work with the latest technology.
You’ll discover a world where employees enjoy constant career advancement, a supportive learning environment, and competitive compensation packages.
The IT Department of Ubisoft is currently seeking a full-time Business Intelligence (BI) Support Developer to support and maintain our Enterprise Data Warehouse and Analytics solutions.
You will be responsible for supporting and improving the extract, transform, and load process into our data warehouse using ETL tools (Informatica and Teradata), and troubleshooting batch problems.
Ensure 3rd level support for the ETL processes developed in Enterprise Data Warehouse (monitor the hourly, daily, monthly batches, troubleshoot and fix issues)
Monitor existing data quality indicators (freshness, completeness, accuracy, etc.), adjust, improve and create new indicators.
Maintain and improve the ETL jobs and related Data Warehouse models and objects
Adapt ETL processes to accommodate changes in source systems and new business user requirements
Provide technical assistance for support requests
Have good understanding of user requirements and functional specifications.
Identify long-term solutions, propose and suggest the most suitable alternatives
Be aware of technical best practices (regular researches and studies on support websites, ask for relevant trainings...)
Bachelor’s degree in IT.
Relevant Experience :
More than 3 years’ relevant experience in BI domain.
More than 3 years’ experience working with Data Warehouse solutions on :
Database engine : Teradata or SQL Server or Oracle
ETL Tools : Informatica or Data Stage or Oracle Warehouse Builder
Good communication and interpersonal skills
Strong problem-solving and metadata skills
Good organizational skills
Language : Must be fluent in English (both spoken and written)
Knowledge of Hadoop and related technologies such as HDFS and HIVE is an advantage
Shell Scripting or Python is an advantage
Experience with data quality process implementation
Experience with reporting and analytic presentation tools and technologies such as MicroStrategy or Tableau, an asset
Understanding of relational and multi-dimensional data design and development techniques
Clear Understanding of data warehousing and data modeling concepts
We are an equal-opportunity employer and value diversity at our company. We do not discriminate on the basis of race, ethnicity, religion, gender, sexual orientation, age or disability status.