Talent.com
freelance.ca
ETL Developer – Construction (1862)freelance.ca • Toronto, Canada
ETL Developer – Construction (1862)

ETL Developer – Construction (1862)

freelance.ca • Toronto, Canada
30+ days ago
Job type
  • Temporary
Job description
NOTE: HYBRID work model, 3 days/week onsite (initially more for first month for stakeholder engagement).Type: 6 Month Contract (with potential extension), 8 hours/day, 40 hours/weekWork Experience: 5–10+ years ETL Developer / Data Engineering, SQL, Microsoft Fabric, Data Pipelines, Power BI, API IntegrationIndustry: Construction / InfrastructureDESCRIPTION:
  • Design, develop, and maintain ETL processes within Microsoft Fabric and OneLake to build a centralized Common Data Environment (CDE)
  • Build scalable data pipelines to consolidate and standardize data from multiple enterprise systems into a single source of truth
  • Perform development lifecycle tasks, including:
  • Analyze and understand multiple data sources (e.g., Procore, Autodesk, Sage ERP, SharePoint, scheduling and safety systems) to design effective data integration strategies
  • Develop ETL/ELT solutions from scratch, integrating data via REST APIs and automated ingestion pipelines
  • Implement medallion architecture (Bronze, Silver, Gold) to manage raw, cleaned, and business-ready datasets
  • Design and implement master data models and common identifiers to eliminate duplication and ensure cross-system consistency
  • Build, optimize, and manage data models that support reporting and analytics
  • Design, develop, and maintain Power BI dashboards and semantic models to ensure consistent metric definitions
  • Implement data validation, quality checks, and exception reporting to ensure data integrity and trustworthiness
  • Configure and manage data security, access control, and governance using Microsoft/Azure identity and sensitivity labeling
  • Schedule, orchestrate, and automate ETL jobs and pipelines
  • Promote ETL processes and data models across environments
  • Document ETL pipelines, data models, architecture, and governance processes
  • Be proactive in providing status updates, effort estimates, and identifying risks impacting delivery
  • Collaborate with internal stakeholders (architects, analysts, BIM teams, IT, and business users) to gather requirements and deliver data solutions
  • Participate in evaluating and implementing new data technologies within the Microsoft ecosystem
  • Contribute to preparing the data platform for AI and Copilot adoption by ensuring trusted, governed data
REQUIREMENTS:
  • Bachelor’s degree in Computer Science, Engineering, or related field
  • 5–10+ years of hands-on experience as an ETL Developer / Data Engineer in a data platform or data warehouse environment
  • Strong experience building centralized data platforms or single source of truth solutions
  • Technical expertise in:
  • Microsoft Fabric (Data Factory, OneLake, Lakehouse, Warehouse concepts)
  • ETL / ELT pipeline development and orchestration
  • SQL (advanced querying, transformations, performance tuning)
  • Python / PySpark for data processing and transformation
  • REST API integration and automated data ingestion
  • Medallion architecture (Bronze, Silver, Gold layers)
  • Data modeling (star schemas, semantic models, master data management)
  • Power BI (DAX, dashboard development, publishing, semantic layer design)
  • Strong understanding of:
  • Data integration, data quality, and data validation frameworks
  • Data governance, security, and Azure identity/access management
  • Designing common identifiers to link datasets across systems
  • Converting business requirements into scalable data pipelines
  • Ability to work independently in a consulting environment with minimal supervision
  • Ability to manage multiple priorities and deliver under pressure
NICE TO HAVE:
  • Microsoft Purview or similar data governance tools
  • Experience preparing data platforms for AI / Copilot integration
  • Familiarity with hub-and-spoke architecture patterns
  • Experience integrating ERP, finance, or project management systems
  • Knowledge of ISO 19650 and construction/BIM data practices
  • Microsoft certifications (Fabric Analytics Engineer, Power BI Data Analyst)
KEY OBJECTIVE:To design and deliver a scalable, governed ETL framework within Microsoft Fabric that consolidates data from multiple construction business systems into a trusted single source of truth, enabling reporting, analytics, and future AI initiatives.
Create a job alert for this search

ETL Developer – Construction (1862) • Toronto, Canada

Similar jobs

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto, ON, CA
Full-time

We are on the lookout for a Senior ETL Developer with expertise in DataStage and Talend to lead our ETL initiatives.Enhance enterprise data integration and analytics through your skills.As a Senior... Show more

 • Promoted

ETL DataStage Developer

Apptoza Inc.Toronto, ON, CA
Full-time

We are looking for a skilled DataStage and Talend Developer responsible for designing, developing, and maintaining ETL processes to support enterprise data integration, data warehousing, and analyt... Show more

 • Promoted

Lead Software Developer for Advanced Embedded Vehicle Logging Solutions

General Motorsmarkham, york region, Canada
Full-time

Drive innovation in vehicle logging technology as a Staff Embedded Logging Software Developer.Utilize your robust skills in C/C++ and Android to develop embedded logging systems in a hybrid work se... Show more

 • Promoted

SaaS Developer

Redwood Softwaremarkham, on, Canada
Full-time

At Redwood, we empower our customers with lights-out automation for their mission-critical business processes.Redwood Software is the leading orchestration platform for the autonomous enterprise, d... Show more

 • Promoted

Data Engineer

searchlabsmarkham, on, Canada
Full-time

This Data Engineer role is a one-year contract, working on a hybrid in-office/remote model in the GTA.The compensation range is $60-$100/hr.Build and maintain ETL pipelines for enterprise data inte... Show more

 • Promoted

ETL Developer - Informatica PowerCenter

Aviva CanadaMarkham, York Region, CA
Full-time

ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Join to apply for the ETL Deve... Show more

 • Promoted

Client Technology - Etl Developer - $94,300 - $141,500 A Year

CitigroupToronto, Canada
Full-time

We are seeking a highly skilled and pragmatic ETL Developer (Applications Development Sr Programmer Analyst - C12) to design, develop, and deploy advanced ETL solutions.This multifaceted role invol... Show more

 • Promoted

Developer

ScotiabankToronto, ON, CA
Full-time

Join a purpose driven winning team, committed to results, in an inclusive and high‑performing culture.We are seeking a detail‑oriented and proactive softwareDeveloper to design, develop, and mainta... Show more

 • Promoted

Talend Lead Developer — ETL & Data Integration

Aarorn Technologies IncToronto, ON, CA
Full-time

A technology firm is seeking a highly skilled Talend Lead Developer in Toronto, ON to design and optimize ETL workflows.The successful candidate will lead data engineering initiatives, ensuring dat... Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

FidelityToronto County, Canada
Remote
Full-time

Develops and supports ETL data integration solutions using Informatica and Snowflake SQL for Fidelity Canada. Show more

 • Promoted

Software Developer Etl 9222-0715 - C$140,000 - C$180,000 A Year

FoilconEast York, Canada
Full-time

Develop and manage ETL processes for data migration, including data analysis, transformation, and testing.Requires strong ETL principles and Azure skills. Show more

 • Promoted

ETL Developer

United States Digital Space LLCToronto, ON, CA
Full-time

ETL Developer to join our team and support the development and maintenance of enterprise data integration solutions.In this role, you will design, develop, and optimize ETL pipelines while ensuring... Show more

 • Promoted

ETL Developer with Azure Expertise

Source CodeToronto, ON, CA
Temporary

Take on a pivotal role as a Senior Software Developer focusing on ETL at OPGT.Engage in data migration projects leveraging your Azure Synapse and ETL skills in a collaborative environment.This 10-m... Show more

 • Promoted

Senior ETL Engineer – Databricks, Delta Lake, Hybrid

Rubicon PathToronto, ON, CA
Full-time

A leading technology firm in Toronto seeks a Software Developer - ETL to design and implement ETL processes using Azure Databricks.This role involves optimizing data flow for analytics and data lak... Show more

 • Promoted

Developer

Absorb SoftwareToronto, ON, CA
Full-time

Absorb is seeking an intermediate-level Developer to take ownership of an internal ETL tool that supports billing, accounting, and operations.In this individual contributor role, you’ll help mainta... Show more

 • Promoted

ETL Developer & QA for UNICEF Fundraising

UNICEF CanadaToronto, ON, CA
Full-time

Join UNICEF Canada as a Data Integration Developer & QA to create ETL solutions that support child welfare initiatives.Your role will be crucial in a flexible hybrid setting.As part of UNICEF Canad... Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

Fidelity CanadaNorth York, Canada
Remote
Full-time

Develop and support ETL data integration solutions using Informatica and Snowflake SQL for Fidelity Canada.Requires 3+ years of relevant experience. Show more

 • Promoted

Senior ETL Consultant

Maarut IncToronto, ON, CA
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Maarut Inc.Participate in the review of project, work request and m... Show more

 • Promoted

ETL Developer - Snowflake (Pharmaceutical client experience mandatory)

Cygnus Professionals Inc.Toronto, Ontario, Canada
Temporary

ETL Developer - Snowflake (Pharmaceutical client experience mandatory).ETL Developer - Snowflake (Pharmaceutical client experience mandatory).Direct message the job poster from Cygnus Professionals... Show more

 • Promoted

Senior Engineer - ETL Data for Autonomous Vehicles

Waabitoronto, on, Canada
Full-time

Lead advancements in self-driving technology with Waabi as a Senior Engineer focused on ETL data pipelines.This key role develops critical data infrastructure for autonomous vehicle mapping solutio... Show more