Job description
We are currently looking for a BI Architect to join the team of a company in the financial sector in Montreal.
The incumbent will be responsible for designing data models, including data warehouses and stores, as well as developing data flow processes. As an expert in business intelligence, he/she will establish standards and best practices, and share his/her expertise in BI and data analysis with the team.
Missions
Key Responsibilities
- Design data models, data flow processes, and visual dashboards (KPIs);
- Write functional and technical specifications for data processing;
- Maintain up-to-date technical documents;
- Establish standards and best practices in business intelligence;
- Share best practices in BI and data analytics.
Desired Profile
Technical Specializations
- Have a minimum of 5 years of experience in a BI architect role
- Data Modeling for BI: OLAP, ODS, and OLTP
- Experience with the Snowflake platform
- Experience with data integration/ingestion tools (Asset: Matillion)
- Experience with data visualization tools (Required: Power BI)
- Experience with automated testing and CI/CD pipelines
- Experience with cloud services (Azure, AWS, GCP) is an asset
- Knowledge of R or Python is an asset
General criteria:
- University degree in computer science, BI or equivalent
- Bilingualism (English and French)
- Knowledge of the general insurance industry
Benefits
We will present everything to you during our meeting!
Recruitment process
A total of 3 interviews:- 1st: interview with Sandra or Alicia
- 2nd: Technical interview with a director of our analytical team
- 3rd: Interview with the client
Only applications from Permanent Residents or Canadian Citizens will be accepted for this role