Business Intelligence Engineer

Alltech Consulting Services; Mississauga; Hybrid; CAD 110,000 - 190,000; Full time

Job summary

Alltech Consulting Services is seeking a Senior Data Architect to design and lead scalable cloud data platforms across AWS and Azure. The role focuses on Bronze-Silver-Gold Medallion architectures, data lakes and warehouses, and data governance in a hybrid Mississauga setting.

You will lead architecture efforts, develop high-level designs, and mentor data engineering teams while driving modernization and cost optimization across enterprise-scale data platforms.

Qualifications

• 8–10 years of experience in Data Architecture / Data Engineering.
• Strong experience with AWS and/or Azure.
• Expertise in Medallion Architecture, Data Lakes/Lakehouses & Data Warehousing.
• Strong SQL and Python proficiency.
• Experience with Spark, Databricks, Kafka, Airflow/dbt or equivalent technologies.
• Experience working with structured and unstructured data.
• Knowledge of Data Governance, Security, CI/CD & DevOps.
• Excellent architecture, communication and stakeholder management skills.

Responsibilities

• Design enterprise-scale cloud data architecture, data lakes, warehouses & lakehouses.
• Develop HLDs and architecture blueprints for data platforms.
• Design and implement Medallion Architecture (Bronze/Silver/Gold) layers.
• Define data models, integration patterns, governance and security frameworks.
• Lead ETL/ELT, batch & real-time data architecture.
• Drive cloud data modernization, performance and cost optimization.
• Provide technical leadership and mentor Data Engineering teams.

Skills

Data Architecture

Cloud (AWS/Azure)

Medallion Architecture

SQL

Python

Spark/Databricks

Kafka

Airflow/dbt

Data Governance

CI/CD & DevOps

Tools

Databricks

Kafka

Airflow

dbt

Snowflake

Job description

Role: Senior Data Architect (AWS/Azure) Location: Mississauga, ON (Remote-Hybrid) Employment Type: Full-Time We are looking for a Senior Data Architect to design and lead scalable, secure, and high-performance cloud data platforms across AWS and/or Azure . Key Responsibilities Design enterprise-scale cloud data architecture, data lakes, warehouses & lakehouses Develop HLDs (High-Level Designs) and architecture blueprints for data platforms Design and implement Medallion Architecture (Bronze, Silver & Gold layers) Define data models, integration patterns, governance and security frameworks Lead ETL/ELT, batch & real-time data architecture Drive cloud data modernization, performance and cost optimization Provide technical leadership and mentor Data Engineering teams Must-Have Skills 8–10 years of experience in Data Architecture / Data Engineering Strong experience with AWS and/or Azure Expertise in Medallion Architecture, Data Lakes/Lakehouses & Data Warehousing Strong experience creating HLDs, architecture diagrams and technical design documents Strong SQL and experience with Python or equivalent programming languages Experience with Spark, Databricks, Kafka, Airflow/dbt or equivalent technologies Experience working with structured and unstructured data Knowledge of Data Governance, Security, CI/CD & DevOps Excellent architecture, communication and stakeholder management skills Good to Have AWS/Azure certifications Databricks Certification Snowflake experience Data Mesh concepts MLOps / AI data platform experience Powered by JazzHR