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
