
BI Developer
- Montreal, QC
- Permanent
- Full-time
- Take part in all BI project phases (analysis, design, development and tests).
- Understand the needs of internal clients and translate these needs into technical specifications
- Design and build database framework for the DW, ETL processing, multidimensional databases and reports.
- Build complex SQL queries and scripts
- Define standards and train the team on BI technologies.
- Draft technical documents, user manuals and installation guides.
- Contribute to the continued enhancement of the products, code and documents.
- Communicate and collaborate with the business partners; ability to present technical artefacts to a non-technical audience
- Strong experience delivering scalable, maintainable, and reusable code components to build data pipelines using Python and SQL, ideally in a Cloud environment (Databricks, Snowflake, etc.)
- In-depth experience designing and developing Data Warehouse solutions
- Proficient with data pipeline orchestration tools such as Airflow
- Familiar with DataOps and governance practices including CI/CD, monitoring and observability, unit testing, etc.
- Experienced with reporting and analytics tools such as Power BI
- Skilled in analysis, synthesis, problem-solving, initiative, attention to detail, and adaptability to change