Senior Business Intelligence Consultant

Yoush Consulting; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

Yoush Consulting is looking for an Azure DevOps Engineer in Toronto, Ontario, to focus on data engineering using Microsoft Azure technologies. You will be responsible for improving the data warehouse environment, designing ETL processes, and optimizing SQL queries. Applicants should have 3+ years of experience and familiarity with Azure Data Factory, Synapse Analytics, and other Azure tools. Strong communication and problem-solving skills are essential.

Qualifications

• 3+ years of proven experience as a Data Engineer focused on Microsoft Azure technologies.
• Experience with Azure Data Factory, Azure Synapse Analytics, and Azure Stream Analytics.
• Strong understanding of data modeling and database design principles.

Responsibilities

• Review and assess the enterprise data warehouse environment and propose improvements.
• Design and develop SSIS ETL processes focused on performance improvement.
• Analyze data, suggest optimizations for SQL queries and stored procedures.

Skills

Azure Data Factory

SQL

Python

Data modeling

ETL tools

Job description

Azure DevOps Engineer with D365 and F&O experience

As a Data Engineer, you will be responsible for building and maintaining the systems and processes that allow for the extraction, transformation, and loading (ETL) of data from various sources into our Azure-based data ecosystem.

Responsibilities

• Provide a detailed review and assessment of the enterprise data warehouse environment and proposed changes and implementation plan to improve scalability and performance.
• Design and develop SSIS ETL process using table partitioning with a focus on performance improvement of large tables.
• Perform data analysis and provide suggestions and feedback to the team to design and develop optimized SQL queries and stored procedures (SCD Type1, SCD Type2 using hash bytes) to improve performance.
• Design and implement an operational process to provide a high-level summary of SQL Server and database environment to assist in the upgrade and migration of SQL Server databases to newer versions.

Requirements

• 3+ years of proven experience as a Data Engineer, with a focus on Microsoft Azure technologies.
• Experience with Azure Data Factory, Azure Synapse Analytics, Azure Stream Analytics, Azure Event Hubs, OneLake, and MS Fabric.
• Proficient in SQL and scripting languages (e.g., Python).
• Strong understanding of data modeling and database design principles.
• Experience with data warehousing concepts and methodologies.
• Familiarity with data integration and ETL tools.
• Excellent problem-solving and communication skills.