Solution Architect / Senior Data Engineer

Finney-Taylor Consulting Group Ltd.; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading consulting firm is seeking a Solution Architect / Senior Data Engineer in Toronto, Ontario. The role involves architecting and implementing Azure Cloud solutions for data lakehouses and warehouses, designing ETL/ELT pipelines, and collaborating with stakeholders. The ideal candidate has extensive experience with Azure technologies, data governance, and a solid background in data architecture. Strong communication skills and expertise in the Microsoft ecosystem are required.

Qualifications

• 12+ years of strong technical experience in building and maintaining cloud data warehouses and data pipelines.
• Must have experience with development in the Microsoft ecosystem (.Net framework).
• Experience with event-driven architecture, data mesh, or self-serve analytics environments.

Responsibilities

• Architect and implement Azure Cloud native Enterprise Data Lakehouse and Data Warehouse solutions.
• Design scalable ETL/ELT pipelines.
• Collaborate with business and technical stakeholders to gather requirements.

Skills

Azure Cloud Technologies

Data Lakehouse architecture

ETL/ELT pipelines

Data governance

Excellent communication skills

Education

Microsoft Azure Data Engineer Associate (DP-203) or equivalent

Tools

Apache Spark

Microsoft Fabric

Power BI

Job description

Job Description: Our client is looking for Solution Architect / Senior Data Engineer.

Key Responsibilities

• Architect and implement Azure Cloud native Enterprise Data Lakehouse and Data Warehouse solutions integrating structured and unstructured data
• Design scalable ETL/ELT pipelines using tools like Apache Spark
• Design and implement Lakehouse and Data Warehouse Models for seamless data ingestion, transformation, and consumption
• Develop data governance, security, and compliance frameworks in Microsoft Fabric
• Collaborate with business and technical stakeholders to gather requirements and translate them into Microsoft Fabric architecture blueprints
• Work closely with Data Engineers, BI Developers, and Cloud Architects to implement end-to-end data solutions
• Guide the migration of legacy systems to Microsoft Fabric
• Lead architectural decisions and influence the evolution of the company's data platform for scalability and maintainability
• Create and maintain technical documentation including Architecture Diagrams, Solution Documents, and other related project documentation

Nice To Have Secondary Skills

• Years of experience as Senior Data / Solution Architect with proven experience in Data Lakehouse architecture
• Expert level experience in Azure Cloud Technologies including Microsoft Fabric
• 12+ years of strong technical experience in building and maintaining cloud data warehouses and data pipelines to support analytical and operational workloads
• Proficiency in data governance, data modeling, and metadata management
• Excellent communication and stakeholder management skills
• Experience with event-driven architecture, data mesh, data products, or self-serve analytics environments

Preferred Certifications

• Microsoft Azure Data Engineer Associate (DP-203) or equivalent

Mandatory Qualifications

• Must have previous experience with development in the Microsoft ecosystem (.Net framework) and specifically in the Microsoft Azure and Power BI
• Must adapt to TPS/ITS working conditions and core values

Preferred Qualifications (Additional)

• Experience working with Public Safety organizations
• Excellent listening, interpersonal, written, and oral communication skills
• Excellent communication skills
• Excellent problem-solving ability

Skills

• Databases
  • Experience In at least 12 years of experience with/in ETL
  • Experience In at least 12 years of experience with/in Data Warehousing

Industry experience required: Government