ETL Developer – Construction (1862)
About the role
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/week Work Experience: 5–10+ years ETL Developer / Data Engineering, SQL, Microsoft Fabric, Data Pipelines, Power BI, API Integration Industry: Construction / Infrastructure
DESCRIPTION:
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.
As part of our hiring process, we use AI‑based systems to support initial applicant screening. TO APPLY: https://directitrecruiting.com/job/data-analyst-construction-1862/
Not the right fit? Search for ETL Developer jobs in Vaughan, Ontario, Canada
About Direct IT Recruiting Inc.
Direct IT Recruiting is a Canadian IT Recruiting Agency, owned and operated in Canada by a Canadian, Darla Somerville since 2007. Specializing in IT recruitment for full-time and contract placements. Contact us via phone at 416-316-3333 or email us at careers@directitrecruiting.com
Direct IT Recruiting Inc. was established in 2007, and has persistently punched above its weight when pitted against larger recruiting agencies. Customers frequently praise our unceasing attention to detail, in addition to our relentless quest to find the best fit for a role. Our size allows a competitive advantage, as we can mold ourselves to the unique requirements of our valued customers, as opposed to a one-size-fits-all approach. Whether you are looking for a job opportunity or hoping to hire, we are always willing to help you succeed.
Direct IT Recruiting Inc. currently works in numerous industries, including (but not limited to) Banking, Financial, Capital Markets, Investments, Wealth Management, Insurance, Software Development Companies, Internet-Based Companies, Healthcare, Pharmaceutical, Legal, Manufacturing, Supply Chain, Engineering, Education, IT Consulting Firms, and Government Entities.
Similar Jobs
ETL Developer – Construction (1862)
About the role
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/week Work Experience: 5–10+ years ETL Developer / Data Engineering, SQL, Microsoft Fabric, Data Pipelines, Power BI, API Integration Industry: Construction / Infrastructure
DESCRIPTION:
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.
As part of our hiring process, we use AI‑based systems to support initial applicant screening. TO APPLY: https://directitrecruiting.com/job/data-analyst-construction-1862/
Not the right fit? Search for ETL Developer jobs in Vaughan, Ontario, Canada
About Direct IT Recruiting Inc.
Direct IT Recruiting is a Canadian IT Recruiting Agency, owned and operated in Canada by a Canadian, Darla Somerville since 2007. Specializing in IT recruitment for full-time and contract placements. Contact us via phone at 416-316-3333 or email us at careers@directitrecruiting.com
Direct IT Recruiting Inc. was established in 2007, and has persistently punched above its weight when pitted against larger recruiting agencies. Customers frequently praise our unceasing attention to detail, in addition to our relentless quest to find the best fit for a role. Our size allows a competitive advantage, as we can mold ourselves to the unique requirements of our valued customers, as opposed to a one-size-fits-all approach. Whether you are looking for a job opportunity or hoping to hire, we are always willing to help you succeed.
Direct IT Recruiting Inc. currently works in numerous industries, including (but not limited to) Banking, Financial, Capital Markets, Investments, Wealth Management, Insurance, Software Development Companies, Internet-Based Companies, Healthcare, Pharmaceutical, Legal, Manufacturing, Supply Chain, Engineering, Education, IT Consulting Firms, and Government Entities.