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:

o Analyze and understand multiple data sources (e.g., Procore, Autodesk, Sage ERP, SharePoint, scheduling and safety systems) to design effective data integration strategies

o Develop ETL/ELT solutions from scratch, integrating data via REST APIs and automated ingestion pipelines

o Implement medallion architecture (Bronze, Silver, Gold) to manage raw, cleaned, and business-ready datasets

o Design and implement master data models and common identifiers to eliminate duplication and ensure cross-system consistency

o Build, optimize, and manage data models that support reporting and analytics

o Design, develop, and maintain Power BI dashboards and semantic models to ensure consistent metric definitions

o Implement data validation, quality checks, and exception reporting to ensure data integrity and trustworthiness

o Configure and manage data security, access control, and governance using Microsoft/Azure identity and sensitivity labeling

o Schedule, orchestrate, and automate ETL jobs and pipelines

o Promote ETL processes and data models across environments

o 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:

o Microsoft Fabric (Data Factory, OneLake, Lakehouse, Warehouse concepts)

o ETL / ELT pipeline development and orchestration

o SQL (advanced querying, transformations, performance tuning)

o Python / PySpark for data processing and transformation

o REST API integration and automated data ingestion

o Medallion architecture (Bronze, Silver, Gold layers)

o Data modeling (star schemas, semantic models, master data management)

o Power BI (DAX, dashboard development, publishing, semantic layer design)

· Strong understanding of:

o Data integration, data quality, and data validation frameworks

o Data governance, security, and Azure identity/access management

o Designing common identifiers to link datasets across systems

o 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/

Pay: From $90.00 per hour

Benefits:

• Casual dress
• On-site parking

Ability to commute/relocate:

• Vaughan, ON L4K 5W4: reliably commute or plan to relocate before starting work (preferred)

Application question(s):

• What is your hourly rate?

Experience:

• Power BI: 7 years (preferred)
• Python: 5 years (preferred)
• BIM: 1 year (preferred)
• Commercial construction: 1 year (preferred)
• Medallion : 1 year (preferred)
• Rest API: 5 years (preferred)
• Data modeling: 5 years (preferred)
• Autodesk: 1 year (preferred)
• Data Validation: 5 years (preferred)
• DAX: 5 years (preferred)
• ISO 19650: 1 year (preferred)
• SSIS: 2 years (preferred)
• Microsoft Fabric : 1 year (preferred)

Work Location: Hybrid remote in Vaughan, ON L4K 5W4