Azure Data Factory Expert

7 days ago


Toronto, Ontario, Canada Procom Labs Full time
About the Role:

In collaboration with the Business Intelligence (BI) Manager, the Data Engineer will undertake the responsibility of executing and managing Azure Data Factory Pipelines.

This includes the design and implementation of the Data Lake, as well as the optimization of data refresh performance.

The role encompasses ownership (both execution and management) of Extract, Transform, Load (ETL) processes, Azure Data Lake, and Data Warehouse.

Additionally, the Data Engineer will oversee the Power BI Semantic Data Model, ensuring its efficient operation and maintenance.

This position requires a strong understanding of data architecture and cloud-based data services, particularly within the Microsoft Azure platform.

The individual will play a critical role in the organization's data strategy and its implementation.

Responsibilities:
  • Develop and implement data using Azure cloud management solutions.
  • Design and Develop Power BI Semantic models and custom reporting.
  • Design and Develop Star Schema for Power BI Data Models.
  • Design and manage data storage and data processing solutions in Azure.
  • Integrate data sources and build data pipelines for data transformation and ingestion.
  • Implement data security and governance measures in Azure.
  • Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Azure.
  • Work together with data scientists and analysts to understand the needs for data and create effective data workflows.
  • Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage.
Qualifications:
  • 5+ years of experience in a Data Engineering role
Required Skills:
  • 4+ years of proven experience building data pipelines using MSFT Azure tools and services (Azure Data Factory, Azure Synapse, Azure Blob, Azure Databricks, Azure SQL Server, Azure Data Warehouse, Azure Batch)
  • 3+ years of experience in Power BI Modeling and Reporting.
  • Azure Expertise: Proficiency in designing comprehensive Azure solutions, considering infrastructure, apps, data, security, and ETL Development. This includes Azure administration skills and experience with Azure Data Factory for data ingestion and transformation.
  • Database Management: Proficiency in managing database systems.
  • Analytical Skills: Strong ability to analyze and solve complex problems.
  • Data Modeling and Architecture: Expertise in designing data models and architectural frameworks.
  • Programming Proficiency: Knowledge of SQL, Python, DAX & M is essential.
  • Communication Skills: Effective interpersonal skills and the ability to work well in a team.
DevOps Expertise:
  • IT Operations: Advanced knowledge of IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platform, budgeting, and governance.
  • Data Pipeline Construction: Experience in building data pipelines and applying data transformations for batch and real-time messaging systems.
  • Data Source Evaluation: Ability to assess the effectiveness and accuracy of new data sources and data-gathering techniques.
  • Data Transformation and Modeling: Ability to work on various aspects of data transformations and data modeling.
  • Data Collection Enhancement: Experience in enhancing data collection procedures to include information relevant for building analytic systems.
  • Best Practices: Ability to follow and document best practices and processes.
  • Multitasking: Demonstrated ability to handle multiple assignments in parallel and meet demanding timelines.
Based Analytics Tools:

Familiarity with Azure cloud-based analytics solutions, Experience in Power BI is an advantage.

A Bit About Us

Procom Labs is building a world-class digital ecosystem of products to find, employ, and manage the contingent workforce of today and tomorrow.

Our products offer end-to-end solutions in Recruiting Technologies, Workforce Management, and Back-Office Processing.

We are a group of people that love to try out creative and sometimes crazy solutions to solve complex problems.

We want you to join us in our journey.



  • Toronto, Ontario, Canada Blanc Labs Inc. Full time

    About Blanc Labs Inc.Blanc Labs Inc. is a leading digital transformation partner for global enterprises, specializing in the development of next-generation digital products and services. Our expertise in digitization and automation empowers businesses to accelerate service delivery, drive customer engagement, and foster growth.Job SummaryWe are seeking an...


  • Toronto, Ontario, Canada Blanc Labs Inc. Full time

    About Blanc Labs Inc.Blanc Labs Inc. is a leading digital transformation partner for global enterprises, specializing in the development of next-generation digital products and services. Our expertise in digitization and automation empowers businesses to accelerate service delivery, drive customer engagement, and foster growth.Job SummaryWe are seeking an...


  • Toronto, Ontario, Canada Blanc Labs Inc. Full time

    About the RoleBlanc Labs Inc. is a leading digital transformation partner for global enterprises, driving innovation and excellence in the development of next-generation digital products and services.We are seeking an experienced and dynamic ETL Developer Lead with deep expertise in Azure Data Factory to lead our ETL development efforts and work closely with...

  • Data Analyst

    5 days ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...

  • Data Analyst

    6 days ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...

  • Data Analyst

    5 days ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...

  • Data Analyst

    6 days ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...

  • ETL Development Lead

    4 hours ago


    Old Toronto, Ontario, Canada Blanc Labs Full time

    Blanc Labs, a leading digital transformation partner for global enterprises, is seeking an experienced ETL Development Lead with deep expertise in Azure Data Factory to lead our ETL development efforts and work closely with one of our prestigious banking clients.The ideal candidate will have a proven track record in leading ETL projects, driving data...


  • Old Toronto, Ontario, Canada Blanc Labs Full time

    Blanc Labs, a leading digital transformation partner for global enterprises, is seeking an experienced ETL Development Lead with deep expertise in Azure Data Factory to lead our ETL development efforts and work closely with one of our prestigious banking clients.The ideal candidate will have a proven track record in leading ETL projects, driving data...

  • Azure Data Engineer

    5 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...

  • Data Analyst

    24 hours ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...

  • Data Analyst

    20 hours ago


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

    Job DescriptionAstra North Infoteck Inc. is seeking a highly skilled Data Analyst to join our team in a key role that involves working with Azure Data Factory and Azure Data Lake.Key Responsibilities:Data Analytics and Data Warehouse Expertise: We are looking for a professional with 6-8 years of experience in data analytics, data warehouse, and data...


  • Old Toronto, Ontario, Canada S I Systems Full time

    Senior Data Engineer for Azure Data Factory MigrationDuration: 1-2 yearsLocation: Downtown Toronto (1-2x/week)Job Responsibilities:The successful candidate will work with end users to rework workflows and pipelines as part of a migration from Informatica to Azure Data Factory.Key Requirements:Experience reworking workflows and pipelinesExperience migrating...


  • Old Toronto, Ontario, Canada S I Systems Full time

    Senior Data Engineer for Azure Data Factory MigrationDuration: 1-2 yearsLocation: Downtown Toronto (1-2x/week)Job Responsibilities:The successful candidate will work with end users to rework workflows and pipelines as part of a migration from Informatica to Azure Data Factory.Key Requirements:Experience reworking workflows and pipelinesExperience migrating...


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

    About the RoleAstra North Infoteck Inc. is seeking a highly skilled Azure Data Analyst to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining data pipelines using Azure Data Factory and Azure Data Lake.Key ResponsibilitiesData Analytics and Data WarehousingDevelop and maintain data...


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

    About the RoleAstra North Infoteck Inc. is seeking a highly skilled Azure Data Analyst to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining data pipelines using Azure Data Factory and Azure Data Lake.Key ResponsibilitiesData Analytics and Data WarehousingDevelop and maintain data...

  • Azure Data Engineer

    23 hours 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

    20 hours 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 Dimensional Strategies Inc. Full time

    About Dimensional Strategies Inc.Dimensional Strategies Inc. (DSI) is a premier Microsoft partner located in the Greater Toronto Area (GTA). Our customer base extends across Canada and the contiguous US states. Our primary goal is to help our customers execute their business processes more efficiently and effectively via investments in applications and...