Salary Range: CAD 90K - CAD 120K (Depend upon experience)

• Establish and maintain the overall enterprise data model, working closely with the business lines, data governance team and data engineers across the organization.
• Capture business requirements to establish relational, dimensional or data vault data models to support different data use cases.
• Review data models proposed by data engineers, analysts and scientists in order to optimize them, align them with the global model, and operationalize them, while ensuring adherence to industry standards and laws related to GDPR and SOX.
• Define and implement the architecture elements that will ensure the timeliness, quality, security and availability of data
• Continuously improve the BI platform architecture, from raw data capture to the presentation layer
• Be a leader in defining best practices and creative thinking

Required Skills

• Master Degree in Business Intelligence or equivalent
• Solid and demonstrated experience on following technologies:
• Snowflake
• DBT
• Microsoft SQL Server
• Power BI
• Git
• Fluent in various programming languages such as:
• SQL
• Python
• Understands and puts into practice data modeling, design and development of solid ETL/ELT data pipelines
• Fluent in writing, executing and optimizing complex SQL queries
• Experience implementing API Service architectures ( REST)
• Develop clean and maintainable code in a CI-CD Environment
• Experience in using cloud BI technologies such as Azure or similar