ETL/Azure data engineer

2 days ago


Toronto, Ontario, Canada Cleo Consulting Full time
Job Summary: Senior ETL/Azure data engineer required to design and implement a data warehouse/lakehouse on Microsoft Azure, develop reports and dashboards in Power BI, and integrate data from diverse sources. Assignment: RQ Software Developer - Senior Job Title: ETL/Azure data engineer Client: Justice Technology Services Organization: Justice Technology Services Ministry: Ministry of Solicitor General Job Description: The successful candidate will be responsible for designing and implementing a data warehouse/lakehouse on Microsoft Azure, developing reports and dashboards in Power BI, and integrating data from diverse sources. The candidate will work closely with the reporting team to deliver the Minimum Viable Product (MVP) for reporting, build the new data warehouse/lakehouse, and deliver the required reporting. Key Responsibilities: • Design and implement a data warehouse/lakehouse on Microsoft Azure • Develop reports and dashboards in Power BI • Integrate data from diverse sources • Collaborate with the reporting team to deliver the MVP for reporting • Build the new data warehouse/lakehouse • Deliver the required reporting Requirements: • Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, and utilizing advanced features • Experience with ETL/Microsoft Azure Synapse Analytics, including its architecture, data storage options, data ingestion mechanisms, and security features • Development experience with Dynamics 365 and understanding of the Common Data Model for Dynamics • Familiarity with version control systems and collaboration tools Skills and Knowledge: • Data Warehouse/Lakehouse Concepts: Strong understanding of data warehousing principles, including data modeling, ETL processes, data integration, and data governance • Microsoft Azure Synapse: In-depth knowledge and experience with Azure Synapse Analytics, including its architecture, data storage options, data ingestion mechanisms, and security features • Power BI: Proficiency in Power BI, including data modeling, creating interactive reports and dashboards, configuring data gateways, and utilizing advanced features • SQL and Query Optimization: Strong SQL skills for writing complex queries, optimizing database performance, and troubleshooting query performance issues Criteria: • PowerBI (25 Points) + Demonstrated experience working Power BI, creating interactive reports and dashboards, configuring data gateways, utilizing advanced features such as DAX and Power Query + Experience with SSIS, SSRS • ETL / Azure Platform (25 Points) + Experience with Azure Synapse Workspaces and/or Azure Data Factory + Azure cloud certifications • Dynamics (20 Points) + Demonstrated software development experience with PowerApps platform, Power Automate, Dynamics CE &F&O and producing reports from Dynamics • SQL / DB (15 Points) + Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning + Demonstrated experience with SQL Server, Oracle, Azure SQL Databases • Azure DevOps (10 Points) + Demonstrated experience with Azure DevOps for version control, managing code, tracking changes, and collaborating with team members

  • Toronto, Ontario, Canada Cleo Consulting Full time

    About the RoleCleo Consulting is seeking a highly skilled Senior Data Engineer to join our team as an Azure ETL Specialist. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data warehousing and ETL solutions on the Microsoft Azure platform.Key ResponsibilitiesDesign and develop data warehouses...


  • Toronto, Ontario, Canada Cleo Consulting Full time

    About the RoleCleo Consulting is seeking a highly skilled Senior Data Engineer to join our team as an Azure ETL Specialist. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data warehousing and ETL solutions on the Microsoft Azure platform.Key ResponsibilitiesDesign and develop data warehouses...


  • Toronto, Ontario, Canada Cleo Consulting Full time

    About the RoleCleo Consulting is seeking a highly skilled Senior Data Engineer to join our team as an Azure ETL Specialist. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data warehousing and ETL solutions on the Microsoft Azure platform.Key ResponsibilitiesDesign and develop data warehouses...

  • Azure Data Engineer

    3 weeks ago


    Toronto, Ontario, Canada Hafman Consulting Group Full time

    Hafman Consulting Group is seeking a highly skilled and experienced Data Engineer to join our growing team. In this role, you will play a pivotal part in designing, developing, and maintaining robust data infrastructures within the Microsoft Azure cloud environment. As a key member of our engineering team, you will be responsible for crafting efficient...

  • Azure Data Engineer

    3 days ago


    Toronto, Ontario, Canada Procom Labs Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Procom Labs. As a Data Engineer, you will play a critical role in designing and implementing data solutions using Azure cloud management solutions.Key ResponsibilitiesDesign and develop data pipelines using Azure Data Factory and Azure Synapse AnalyticsDevelop and implement data...

  • Azure Data Engineer

    4 days ago


    Toronto, Ontario, Canada Procom Labs Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Procom Labs. As a Data Engineer, you will play a critical role in designing and implementing data solutions using Azure cloud management solutions.Key ResponsibilitiesDesign and develop data pipelines using Azure Data Factory and Azure Synapse AnalyticsDevelop and implement data...

  • Azure Data Engineer

    2 weeks ago


    Toronto, Ontario, Ontario, Canada Themesoft Inc. Full time

    Role: Azure Data EngineerLocation: Toronto, ON(Hybrid)Exp: 15+yearsResponsibilities:Oversee the integration of geospatial data from various sources using Azure Data Factory ETL and Azure Data Factory.Provide expertise in Databricks and Azure Databricks to optimize data processing workflows and enhance data analysis capabilities. Collaborate with...

  • Azure Data Engineer

    3 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Azure Data Engineer Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Azure Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data systems on Azure.Key Responsibilities:Design and implement data pipelines using Azure Data Factory,...

  • Azure Data Engineer

    3 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Azure Data Engineer Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Azure Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data systems on Azure.Key Responsibilities:Design and implement data pipelines using Azure Data Factory,...

  • Data Engineer

    4 days ago


    Toronto, Ontario, Canada Pacific Data Integrators Full time

    Job Title: Data EngineerPacific Data Integrators is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a critical role in supporting our client's OCM Self-serve platform.Key Responsibilities:Design and implement data pipelines deployed to the client's investment entitiesCultivate a business relationship that assists in...

  • Data Engineer

    4 days ago


    Toronto, Ontario, Canada Pacific Data Integrators Full time

    Job Title: Data EngineerPacific Data Integrators is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a critical role in supporting our client's OCM Self-serve platform.Key Responsibilities:Design and implement data pipelines deployed to the client's investment entitiesCultivate a business relationship that assists in...

  • Azure Data Engineer

    4 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Azure Data EngineerAstra North Infoteck Inc. is seeking a highly skilled Azure Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data marts on Azure.Key Responsibilities:Design and implement ETL processes using Azure Data Factory, Synapse, and...

  • Azure Data Engineer

    4 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    Job Title: Azure Data EngineerAstra North Infoteck Inc. is seeking a highly skilled Azure Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, building, and maintaining large-scale data marts on Azure.Key Responsibilities:Design and implement ETL processes using Azure Data Factory, Synapse, and...

  • Data Engineer

    4 days ago


    Toronto, Ontario, Canada Pacific Data Integrators Full time

    About the RolePacific Data Integrators is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a critical role in supporting our client's OCM Self-serve platform.Key ResponsibilitiesDesign and implement data pipelines deployed to our client's investment entities, ensuring high reliability, scalability, and...

  • Azure Data Engineer

    6 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    About the RoleAstra North Infoteck Inc. is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining large-scale data marts and data warehouses using Azure Data Factory and other cloud-based technologies.Key ResponsibilitiesData Mart Design and DevelopmentDesign and develop...

  • Azure Data Engineer

    6 days ago


    Toronto, Ontario, Canada Astra North Infoteck Inc. Full time

    About the RoleAstra North Infoteck Inc. is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining large-scale data marts and data warehouses using Azure Data Factory and other cloud-based technologies.Key ResponsibilitiesData Mart Design and DevelopmentDesign and develop...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    Job DescriptionWe are seeking a highly skilled Senior Data Engineer to join our team at S.i. Systèmes. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data pipelines using Azure data technologies such as Azure Data Factory, Databricks, Azure Synapse, and SQL Data Warehouse.Key...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    Job DescriptionWe are seeking a highly skilled Senior Data Engineer to join our team at S.i. Systèmes. As a key member of our data engineering team, you will be responsible for designing, developing, and implementing data pipelines using Azure data technologies such as Azure Data Factory, Databricks, Azure Synapse, and SQL Data Warehouse.Key...


  • Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job Title: Senior Azure Data Architect/EngineerAbout the Role:We are seeking an experienced Azure Data Architect/Engineer to join our team at Lyons Consulting Group. As a key member of our data engineering team, you will be responsible for designing and implementing cloud-based data solutions that meet the needs of our clients.Key...


  • Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job Title: Senior Azure Data Architect/EngineerAbout the Role:We are seeking an experienced Azure Data Architect/Engineer to join our team at Lyons Consulting Group. As a key member of our data engineering team, you will be responsible for designing and implementing cloud-based data solutions that meet the needs of our clients.Key...