30 Jul
|
Yoush Consulting
|
Toronto
30 Jul
Yoush Consulting
Toronto
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 setting 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 workplace 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). Solid 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.
J-18808-Ljbffr
📌 Senior Business Intelligence Consultant Toronto
🏢 Yoush Consulting
📍 Toronto