To join our team of consultants in Business Intelligence (BI) based in Montreal, we are looking for motivated and dynamic consultants with expertise in BI Microsoft stack (SSIS, SSRS, SSAS). They will play a challenging role and be key players in the success of our clients' projects.
Design, implement, and deploy enterprise data solutions using mostly the BI Microsoft stack (SSIS, SSRS, SSAS).
Work, research and introduce ETL, reporting, & business intelligence technologies to the project and stakeholders.
Collaborate with business analysts, data analysts, and other developers to deliver powerful new features.
Coordinate with other teams as part of a larger data-sharing system.
Contribute to a collaborative, positive, stimulating, and enjoyable environment for your development team.
Migrate existing ETL and BI processes to cloud technologies
Develop new ETL and BI processes in cloud. (design, script, deploy, maintain).
Build and maintain complex SQL queries for data analysis and data extract.
Perform quality assurance and testing of your work
Identify and propose solutions to various data related challenges, improve company operations and resolve identified gaps
Translate business requirements into system design specifications for development
Ensure design specifications are being followed throughout the development process
Work with third parties in order to effectively communicate business requirements and ensure successful project delivery
Act as a stakeholder throughout project management lifecycle
Work with the end users to identify power users and provide appropriate training
Work with the end users to document the business processes and maintain training material
Apply appropriate quality assurance methodology and ensure the business is guided through user acceptance testing
Oversee the hand off of new systems and services to the maintenance team
Ensure system performance, availability and business continuity
Ensure adequate production monitoring of scheduled tasks and that escalation processes are defined and followed
Bachelor's Degree in MIS, B.Com, Computer Science or related field. Equivalent experience may be accepted
5 - 10 years of experience Business Intelligence (BI) / Data IT development and ETL or related fields
Excellent understanding of the MS BI Stack (SQL, SSIS, SSAS (tabular & multidimensional), SSRS, Power BI)
Knowledge and experience with product lifecycle management, software development lifecycle and data modeling
Experience developing technical business requirements, operating procedures, and training materials
Excellent communication skills, both verbally and in writing (French and English)
A go-getter able to work independently as well as collaboratively
Resilient, with the ability to quickly adapt to changing priorities
Excellent attention to detail, organizational skills and serial-tasking abilities
Some advantages of joining Amaris are:
Be part of an international consultancy group in continuous growth and with a strong presence in Europe, America, and Asia.
Having the opportunity to develop your career as a professional consultant, with a rapid career growth
Becoming part of an international employee community across and within our offices, this will enable you to expand your professional network.