This job has expired, please see additional jobs below
BI Developer (Senior)
Ubisoft
Montreal, , Canada
Job Details - this job has expired, please see similar jobs below
Summary
The incumbent will be responsible for the implementation of processes (scripts writing or automatic mappings design) to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store. He will be also in charge of the implementation of analytics reports using the available BI tools.
Mission
The main and routine functions of the Senior BI Developer are to:
• Work with business requirements analyst to identify and understand source data systems;
• Be watchful to the appropriateness of the business needs to technical best practices;
• Map source system data to data warehouse models;
• Develop and test extraction, transformation, and load (ETL) processes;
• Define and capture metadata and rules associated with ETL processes;
• Adapt ETL processes to accommodate changes in source systems and new business user requirements;
• Write technical documentations that will allow a better follow up of the system contents and developments made;
• Be aware of technical best practices (regular researches and studies on support websites, ask for relevant trainings...);
• Carry out all other related task.
Qualifications
Education
Bachelor’s formation in IT.
Relevant experience
• 10 years relevant experience in BI projects.
• Minimum 10 years of Teradata (including experience with components like TPT, QueryGrid, TDCH etc.)
• Minimum 5 years experience with Informatica (including experience with PDO)
• Experience working with Agile methodologies and tools (Scrum preferred)
Skills
• Good communication and interpersonal skills
• Strong organizational, problem solving and multitasking skills with ability to balance competing priorities
• Sense of initiative
• Strong analytical, written and oral communication skills
• Think like an analyst work like a developer / engineer
Knowledge
• Bilingualism (French-English)
• Understanding of source and target data structures, ETL processes, and products
• Ability to design and deploy enterprise level logical and physical Data Warehouse layers
• Strong awareness and understanding of business processes and functions (sales, finance etc).
• Knowledge of scripting language (Bash, Perl, Python), Linux and Java, HTML, Hadoop, Hbase and Hive
• Strong knowledge of data modeling concepts and experience using a data modeling tool (E/R Studio or Erwin)
• Experience with the challenges surrounding large data warehouse, developing data marts, integrating third party data sources, developing ETL or ELT scripts use tools when appropriate
• Knowledge of MicroStrategy V10 and Tableau